On 3 May 2011, at 6:25pm, Dotan Cohen wrote: > 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).
Write your own collating function, which ignores all the things you consider fuzzy (accents, case, etc.), define it in SQLite, then use existing SQLite functions with it. More details on http://www.sqlite.org/c3ref/create_collation.html No reason why you should restrict it to the obvious. You could, for example, take care of Hebrew-English transliteration at the same time, by writing a function which considered 'beer' identical to 'בר', and 'len', 'לנ' and 'לן' all identical. Does anyone have an example of collation function source code they can point to ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
