Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Querying data » Types of full text searches

 

Fuzzy searches

Fuzzy searching can be used to search for misspellings or variations of a word. To do so, use the FUZZY operator followed by a string in double quotes to find an approximate match for the string. For example, CONTAINS ( Products.Description, 'FUZZY "cotton"' ) returns cotton and misspellings such as coton or cotten.

Note

You can only perform fuzzy searches on text indexes built using the NGRAM term breaker. For more information about the NGRAM term breaker and how it applies to fuzzy searches, see Text configuration object settings.

Using the FUZZY operator is equivalent to breaking the string manually into substrings of length n and separating them with OR operators. For example, suppose you have a text index configured with the NGRAM term breaker and a MAXIMUM TERM LENGTH of 3. Specifying 'FUZZY "500 main street"' is equivalent to specifying '500 OR mai OR ain OR str OR tre OR ree OR eet'.

The FUZZY operator is useful in a full text search that returns a score. This is because many approximate matches may be returned, but usually only the matches with the highest scores are meaningful.