FORMSOF Term in SharePoint Search SQL Syntax
Applies to: SharePoint Server 2010
Performs matches by using other linguistic forms of the word.
FORMSOF (<generation_type>,<match_words>)
Remarks
The generation type specifies how SharePoint Server 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")')