"Fuzzy" search searches for words that are spelled in a similar way to the search term.
SELECT AUTHOR, TITLE FROM DB2EXT.TEXTTAB WHERE CONTAINS(COMMENT, 'fuzzy form of 80 "pullitzer"') =1
In this example, the search could find an occurrence of the misspelled word pulitzer.
The match level, in the example "80", specifies the degree of accuracy. Use a fuzzy search when misspellings are possible in the document. This is often the case when a Optical Character Recognition device, or phonetic input creates the document. Use 1 to 100, where 100 is an exact match and below 80 is "fuzziness".
Note |
---|
If the fuzzy search does not provide the appropriate degree of accuracy, search for parts of a term using character masking. |