On Sat, Aug 27, 2011 at 12:04 AM, Jean-Christophe Deschamps < j...@antichoc.net> wrote:
> If you also need to search names with uncertain spelling, you can also > use my typos() function to perform a fuzzy search. Here's a sample of > its use on a decently populated ZipCodes table (848207 rows): select pays, zip, ville, region from allcountries where typos(ville, > 'saopaul%') < 3 group by pays, ville, region > Cool - can you please post a link to the sources? -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users