Sounds like soundex might work for you. Not sure how it handles diacritics though.
http://www.mail-archive.com/sqlite-users@sqlite.org/msg35316.html Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Dotan Cohen [dotanco...@gmail.com] Sent: Tuesday, May 03, 2011 12:25 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Feature request: Fuzzy searching Hi all, I am interested in seeing "fuzzy searching" in SQLite, for lack of a better term. This type of search would return more results than LIKE currently does today. The search would return matches based on expanded criteria, each one may be considered a separate RFE for LIKE or for another specialized function (FLIKE, maybe). 1) Case insensitivity This is already implemented in SQLite for ASCII characters, but it would be nice to have for the rest of the UTF-8 characters (those defined with tolower values, of course). 2) ASCII-equivalent searching This would allow users to search for non-ASCII characters using ASCII-equivalents. For example, searching for "beisen" would return both "beisen" and "beißen". Another example would be a search for "daemon" returning both "daemon" and "dæmon". 3) Diacritic-elimination searching This would allow user to search for words without adding the diacritics. For example, searching for "Jose" would return both "Jose" and "José". Another example would be a search for "דותן" returning both "דותן" and "דוֹתָן". 4) Punctuation-elimination searching This would allow user to search for words without adding punctuation. For example, searching for "Marc Anthony" would return both "Marc Anthony" and "Marc-Anthony". Another example would be a search for "Beer Sheva" returning both "Beer Sheva" and "Be'er Sheva". I have seen this issue brought up on all types of software, from Anki to Kontact to Yum: https://groups.google.com/group/ankisrs/browse_thread/thread/6fc8374b75a4bf4f/bbce3eb5e8401356 https://bugs.kde.org/show_bug.cgi?id=158365 http://comments.gmane.org/gmane.linux.redhat.fedora.general/389336 Thanks! -- Dotan Cohen http://gibberish.co.il<http://gibberish.co.il/> http://what-is-what.com<http://what-is-what.com/> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org 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
