FORMSOF Term in Enterprise Search SQL Syntax
Performs matches by using other linguistic forms of the word.
FORMSOF (<generation_type>,<match_words>)
Remarks
The generation type specifies how Enterprise Search chooses the alternative word forms.
Two values are available:
INFLECTIONAL chooses alternative inflection forms for the match words. If the word is a verb, alternative tenses are used. If the word is a noun, the singular, plural, and possessive forms are used to detect matches.
THESAURUS chooses words that have the same meaning, taken from a thesaurus.
The <match_words> portion can be one or more words, separated by using commas. The words cannot contain spaces or punctuation, so you do not need to enclose them in quotation marks.
Examples
The following example searches for inflectional matches for the word "run". This example matches documents containing "run", "running", or "ran".
…CONTAINS('FORMSOF(INFLECTIONAL,"run")')
The following example searches for thesaurus matches for the word "happy". This example matches documents containing "happy", in addition to words like "glad", "cheerful", and "pleasant".
…CONTAINS('FORMSOF(THESAURUS,"happy")')