Hi Claude,

I had a quick look at the FoxWeb Full text search utility last night. It looks like it will work well for applications needing to have a search in memo fields, but it doesn't have (or at least I can't find them) some of the capabilities that I need in my application.

It's got these features:

* Wild-card matching (* and ?)
* Search for phrases (consecutive words)
* Search for all, or any terms in the search phrase

but does not have these:

1. Stemming
2. Phonic
3. Fuzzy searching
4. Synonyms
5. Related words
8. Boolean.

But if price is an issue with my client we'll probably go with the FoxWeb stuff.

>Hi Frank,
>It would be helpful if you could help me identify any shortcomings in the FoxWeb full-text search. To me, it looks promising. Although it's probably geared to the web, it looks generic enough to use anywhere. It also has a re-index command you could issue after additions are made...
>>Thanks Claude, I'll look into those utilities.
>>
>>
>>>I used to use PhdBase for Memo searches in version 1 of a VFP Web Discussion Forum I did. I just re-evaluated it and it just seemed like too much trouble. This time around, I'll probably use this free search class from the folks at Foxweb: http://www.foxweb.com/fwFullText/ . Also, I believe you could find a similar search engine in the WWC discussion forum..
>>>>Hi,
>>>>
>>>>I need to add some searching capabilities to an application. I have found a tool called dtSearch (www.dtsearch.com) which has the features I am looking for. These features are:
>>>>
>>>>1. Stemming
>>>>2. Phonic
>>>>3. Fuzzy searching
>>>>4. Synonyms
>>>>5. Related words
>>>>6. Any words
>>>>7. All words
>>>>8. Boolean.
>>>>
>>>>Can anyone recommend any other tools/utilities out there with similar features?
>>>>
>>>>Thanks,