Collapse the table of content
Expand the table of content

NEAR Term in SharePoint Search SQL Syntax

Last modified: April 21, 2010

Applies to: SharePoint Server 2010

Specifies that two content search terms must be located relatively close to one another to be recognized as matching by the CONTAINS predicate.

<content_search_term> NEAR | ~ <content_search_term>

The NEAR term can be represented by the keyword NEAR or by a tilde (~).

When the words in the query joined by NEAR are found within approximately 50 words of one another in the column that is being searched, the NEAR term returns a match. The closer together the two words are, the higher the calculated rank for the NEAR term. The farther apart the two words are, the lower the rank.

Note Note

The number of words is approximate; it can be less than 50. If the match words specified with the NEAR term are both found in the column being searched, but are farther apart than 50, the result is still returned but has a rank of 0.

The following table describes content search term types that can be used with a NEAR term in a CONTAINS predicate.





A single word without spaces or other punctuation. Double quotation marks are not necessary.


NEAR software)'


Multiple words or included spaces.

…WHERE CONTAINS('"computer software" NEAR hardware)'


Words or phrases with the asterisk (*) added to the end. For more information, see Using Wildcards in the CONTAINS Predicate in SharePoint Search SQL Syntax.

…WHERE CONTAINS('"compu*" NEAR "soft*"')

The following example shows how you can chain NEAR terms, using both the short and long forms of the term.

…WHERE CONTAINS('computer NEAR software ~ "setup application"')
© 2016 Microsoft