Share via

FORMSOF Term in SharePoint Foundation Search SQL Syntax

  • Article

[This documentation is preliminary and is subject to change.]

Performs matches by using other linguistic forms of the word.

FORMSOF (<generation_type>,<match_words>)

Remarks

The generation type specifies how 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")')

See Also

Reference

CONTAINS Predicate in SharePoint Foundation Search SQL Syntax