Analyzer support for query and index options

The basic text search analyzer that you specify affects whether you can use stopwords or a thesaurus when you create an index and which query term modifiers you can use when you query text.

The following table shows which analyzers support query term modifiers, lowercase processing, stopwords, and a thesaurus.

Table 1. Analyzers and query term modifiers and index parameters
Analyzer Word Phrase Wildcard Fuzzy Proximity Range Boolean Lowercase Stopwords Thesaurus
Alnum yes yes yes yes yes yes yes yes yes yes
CJK yes yes 1 1 1 1 yes yes yes yes
eSoundex yes yes 2 2 no no yes yes yes no
Keyword yes yes yes yes yes no yes no no no
Simple yes yes yes yes yes yes yes yes no yes
Soundex yes yes 2 2 no no yes yes yes no
Snowball 3 3 4 4 4 3 yes yes yes yes
Standard yes yes yes yes yes yes yes yes yes yes
Stopword yes yes yes yes yes yes yes yes yes yes
User-defined analyzer yes 5 5 5 5 5 yes yes yes yes
Whitespace yes yes yes yes yes yes yes no no yes
  • 1 = ISO Latin characters are supported.
  • 2 = Must use the Soundex or eSoundex codes in the search terms.
  • 3 = Depends on the stem word.
  • 4 = The patterns must be on the stem word. The operation works on the stem word.
  • 5 = Depends on the user-defined analyzer code.