Smart-Search

A predictive search API that gives you the freedom to search on millions of entries in a database with ease. A combination of Full Text Search, Ranking and Stemming to give you the best output for your android application/Application using SQLite3.

App Link

What is predictive search?

Besides the fast search with matching substrings what predictive does is, its stemms your search word ie. gets the root and then searches on the FTS Tables to get a list of matches, then it sorts the list on the basis of the probability of matching and returns the sorted list.

How to use

Add the following in your build files.

      allprojects {
          repositories {
		...
		maven { url 'https://jitpack.io' }
                             }
           }
      
      dependencies {
        compile 'com.github.gauravat16:Smart-Search:1.2'
             }

Example

      PredictiveSearch search = new PredictiveSearch(getApplicationContext());
      ArrayList<String> columns = new ArrayList<>();
      columns.add("<column-name>");
  columns.add("<column-name>");

  try {
          search.createFTS4Table("<db-name.db>", "<table-name>", columns);
          search.ftsRebuilder(); //Use it to rebulid after any change
          ArrayList<String> resp1 = search.getSearchList("potatoes"); //Get result w/o stemming
          ArrayList<String> resp2 = search.getPredictedList("try"); //Get result with stemming - predictive

      } catch (Exception ex) {
          ex.printStackTrace();
      } finally {
          search.close();
      }

Important functions

1. createFTS4Table(String dbToBeSearched, String tableOfData, ArrayList columnNames)

Creates/Builds the Full Text Search Virtual Table.

• String dbToBeSearched The name of the database that has the table you want to smart-search.

• String tableOfData The name of the table containing the data.

• ArrayList columnNames The list of all the columns in above table.

2. ftsRebuilder()

Rebulids the FTS Virtual Table. Run this each time you make changes to your main database.

3. getMatchesWOStemming(String partWord)

returns the list of the words that match with your query. This is without stemming search.

4. String getMatchesWStemming(String word)

Performs everything that getSearchList() does but with stemming. Use it for prediction.