>>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
>
>I've always used phdBase - and my guess is that's the one Micheal Fournier was talking about that he uses that's no longer supported..as matter of fact I don't think you could even find anyone selling it.
>
>http://fox.wikis.com/wc.dll?Wiki~PhdBase
>
>A real shame to cause the thing is awsome. It would be nice if the author would make it open source and it was on VFPx.

I've done something close - you guessed it, word index tables - against a huge table with about quarter gigabyte of memo, and I started getting results within three seconds where it took north of thirty (or would never finish) by SQL involving memo fields. I also assigned brownie points for the quality of the hit - the position-in-memo/size-of-memo ratio, length of the word, number of occurrences in the text and a few other simple criteria. It was just whooosh fast.