Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fuzzy Search
Message
From
22/09/2008 11:14:33
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01349328
Message ID:
01349496
Views:
21
>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.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform