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

Reply via email to