Share via


RANKMETHOD Term in Windows SharePoint Services Search SQL Syntax

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Used to specify which statistical algorithm to use to rank the documents that match one or more of the ISABOUT match terms. Following is the syntax of the ISABOUT term when using RANKMETHOD.

ISABOUT ( <match_terms> RANKMETHOD <rank_method> )

Remarks

The following table describes the available rank methods.

Rank method

Description

JACCARD COEFFICIENT

Calculates ranking results from the relative proportion of matching terms, excluding any terms that are not matched.

DICE COEFFICIENT

Calculates ranking results from the frequency of multiple terms found together, compared with the probability that they are found in isolation.

INNER PRODUCT

Calculates ranking results by using the integral of the products of the ranks of the individual matching documents.

MINIMUM

Calculates ranking results from the lowest rank score from all the matching documents.

MAXIMUM

Calculates ranking results from the highest rank score from all the matching documents.

Note If you do not specify a RANKMETHOD, Search uses the default JACCARD COEFFICIENT method.

Examples

The following example shows an ISABOUT term that specifies a RANKMETHOD.

…WHERE CONTAINS(Description, 'ISABOUT("computer","software") RANKMETHOD INNER PRODUCT')

See Also

Reference

CONTAINS Predicate in Windows SharePoint Services Search SQL Syntax