Word List: Attributes

Fuzzy_Match: Fuzzy matching routines to be used for the column. Fuzzy matching is currently supported for English, Japanese, and, to a lesser extent, the Western European languages.
Values: GENERIC (default), JAPANESE_VGRAM, KOREAN, CHINESE_VGRAM, ENGLISH, DUTCH, FRENCH, GERMAN, ITALIAN, SPANISH, or OCR

Note: The fuzzy_match attribute values for Chinese and Korean are dummy attribute values that prevent the English and Japanese fuzzy matching routines from being used on Chinese and Korean text.

Fuzzy_Numresults: Maximum number of fuzzy expansions.
Values: number between 0 and 5000

Fuzzy_Score: Default lower limit of fuzzy score; scores below this number are not produced.
Values: number between 0 and 80

Stemmer: The stemmer used for word stemming in text queries.
Values: blank (no stemming), ENGLISH (default: English inflectional), DERIVATIONAL (English derivational), DUTCH, FRENCH, GERMAN, ITALIAN, or SPANISH

Substring_Index: If YES, causes a pattern table to be created to expedite wildcard searching. Because wildcard searches are processed by expanding the pattern using a LIKE, they force a full-table scan of the main index table. This type of query, sometimes called a left-truncated search, takes a long time. A pattern table (with parameters specified by the P_Table_Clause) stores rotations of all unique words in the main index table. Using the pattern table instead of the main index table allows left-truncated searches to be processed more quickly. However, the query-time savings come at the cost of significantly increased index time and space. Therefore, this option should be used only when left-truncated wildcard searches are frequent and need to be fast.
Values: YES or NO (default)

Wildcard_Maxterms: Maximum number of words to extend the pattern for wildcard searches. The default is 5000. Wildcard searching is done by expanding the pattern against the main index table using LIKE, and searching on all the resulting words. Larger Wildcard_Maxterms values provide more wildcarding flexibility but use up memory more quickly. If wildcard patterns match more words than Wildcard_Maxterms, a "query too complex" error occurs.
Values: number (default: 5000)

Buttons (Apply, Revert, Show SQL/Hide SQL)

See also: Main topics (outline)