Fuzzy search

"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.