>>Hi.
>>Anybody know if a 'Fuzy Search' can be done in Foxpro.
>>Not exactly sure what is a Fuzzy Search but a few people have requested it .
>>Regards,
>>Gerard
>
>Hi Gerard,
>
>I did some research into this relatively recently. Here are some sites with algorithms that might help:
>
>http://www.creativyst.com/Doc/Articles/SoundEx1/SoundEx1.htm
>http://fox.wikis.com/wc.dll?Wiki~ImproveSoundex
>http://fox.wikis.com/wc.dll?Wiki~MetaphoneImplementation-SoundexAlternative
>http://fox.wikis.com/wc.dll?Wiki~DoubleMetaphone-SoundexAlternative
>
>Now, having said that, :) I found they were all too slow for my purpose (searching through a huge database for possible matches). I ended up looking at tools like dtSearch and Netrics Search Server, both of which did admirable jobs, but both of which weren't cheap. My client decide Netrics was the one they wanted so I implemented the solution using that.

Ummm. I recently incorporated DoubleMetaphone for surname searches. I added another field which holds the DoubleMetaphone code for that Surname. Of course, during a save, I update the surnamemetaphone field with the translated Surname. Then when the user does a search "Surname sounds like BLAH " I replace surname with the surnamemetaphone field and BLAH with the metaphone code. This yields the completely Rushmore optimized expression "upper(surnamemetaphone) = 'PL'". It is extremely fast. :)