FORMSOF Term in SharePoint Search SQL Syntax

Last modified: April 21, 2010

Applies to: SharePoint Server 2010

Performs matches by using other linguistic forms of the word.


FORMSOF (<generation_type>,<match_words>)

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.

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")')
Show: