I just did a query on soundex for 3 values: Whittier Fun Center, Whitier Fun Center and Wittier Fun Center. All returned the same result. I think what I will do is create a column populated with the soundex of the customer name as a secondary lookup when I don’t get an exact match, then alert the user and ask him if this isn’t really what he wanted.
Bob On Feb 26, 2014, at 19:38 , Richard Gaskin <ambassa...@fourthworld.com> wrote: > I'm still missing it - where can one find Devin's Levenstein function? > > > Bob Sneidar: >> Don’t know how I missed that, thanks. >> >> On Feb 26, 2014, at 18:50 , Peter Haworth wrote: >> >>> >>> If I remember correctly, Devin has some functions that implement a >>> Levenstein Distance algorithm which will identify potential misspellings of >>> a word > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
