Thanks Tore,

I remember phDbase, never used it, though I had considered it many moons ago.

>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,