There used to be a program called phDbase which has most (all?) of the features you mention, but sadly it is no longer available, and it also had some very serious bugs.

>The data is stored in multiple tables in a VFP database. The searches will be text strings. The text may occur in multiple fields in any of the tables and may just be a part of the entire field. Also we need to find close matches based on possible mis-spellings and derivative words.
>
>>Where are you searching? What would you be searching for?
>>
>>
>>>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,