How about look at following URL? https://github.com/jonasfj/trilite
AFAIK, FTS doesn't support substring search. I also tried to edit FTS to find substring by changing simple tokenizer. It was worked partially, but not a good solution to use generally. 2012/11/9 Dan Kennedy <danielk1...@gmail.com> > On 11/09/2012 01:49 AM, Paul Vercellotti wrote: > >> >> >> Hi there, >> >> I wanted to clarify if FTS could provide any optimization for substring >> matches like '*ion*' or similar? >> > > No. I think it will actually search for tokens that start with the 4 > ASCII characters "*ion" if you try that. > > Dan. > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users