The fuzzy search operator can be helpful in finding word variants or misspellings in a database--the result of typographical mistakes or errors during OCR (optical character recognition) processing.
Note: Regardless of where you position the fuzzy search operator in a query term, the first character of the term will be anchored.Syntax:
string1~string2where string1 is the part of the query term that must be matched exactly, and string2 is the part that will be matched with similar spelling patterns.
Kir~gizia cyclo~hexeneThe first query will retrieve records that contain Kirgizia or alternate spellings of the word, such as Kirghizia.
The second query will retrieve records that contain cyclohexene or similarly spelled words like cyclooctene and cyclohexane.
CAUTION: Use of this operator may result in a search for words relating to entirely different subjects. For example, the query anti~ might search for antics, antique, and Antigua.[Previous Topic] [Contents] [Next Topic]