Searching "teh" or tihs"

[Bob Sneidar]

There is always the soundex() sql function. SELECT soundex('the') = soundex('teh') returns true. Not sure what the tolerance is though. Because of the arbitrary nature of languages, this really requires a lookup table for commonly mistyped words, with the ability to "learn" as corrections are made. Then you would need to be able to "uncorrect" or delete entries. Eventually you end up with something that is likely built into the OS already, so at that point it would be better to write an extension in C or Java. 

Bob S


> On Mar 9, 2017, at 16:26 , hh via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Searching is important for your project?
> Would you like to ask "Did you mean the?" if user searches "teh"?
> 
> I've implemented a fuzzySearch algorithm in LiveCode script:
> http://forums.livecode.com/viewtopic.php?p=152202#p152202
> 
> Now if you wish to look up "the" or "this" then fuzzySearch will find
> it (among others) by searching "teh" or tihs", with a penalty score of
> one only for swapping the chars. 
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode