Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

semanticsimilaritydetailstable (Transact-SQL)

SQL Server 2012

Returns a table of zero, one, or more rows of key phrases that are common across two documents (a source document and a matched document) whose content is semantically similar.

This rowset function can be referenced in the FROM clause of a SELECT statement like a regular table name.

Topic link icon Transact-SQL Syntax Conventions

SEMANTICSIMILARITYDETAILSTABLE
    (
    table,
    source_column,
    source_key,
    matched_column,
    matched_key
    )
table

Is the name of a table that has full-text and semantic indexing enabled.

This name can be a one to four part name, but a remote server name is not allowed.

source_column

Name of the column in the source row that contains the content to be compared for similarity.

source_key

The unique key that represents the row of the source document.

This key is implicitly converted to the type of the full-text unique key in the source table whenever possible. The key can be specified as a constant or a variable, but cannot be an expression or the result of a scalar sub-query. If an invalid key is specified, no rows are returned.

matched_column

Name of the column in the matched row that contains the content to be compared for similarity.

matched_key

The unique key that represents the row of the matched document.

This key is implicitly converted to the type of the full-text unique key in the source table whenever possible. The key can be specified as a constant or a variable, but cannot be an expression or the result of a scalar sub-query.

The following table describes the information about key phrases that this rowset function returns.

Column_name

Type

Description

keyphrase

NVARCHAR

The key phrase that contributes to the similarity between source document and the matched document.

score

REAL

A relative value for this key phrase in its relationship to all the other key phrases that are similar between the 2 documents.

The value is a fractional decimal value in the range of [0.0, 1.0] where a higher score represents a higher weighting and 1.0 is the perfect score.

For information and status about semantic similarity extraction and population, query the following dynamic management views:

Permissions

Requires SELECT permissions on the base table on which the full-text and semantic indexes were created.

The following example retrieves the 5 key phrases that had the highest similarity score between the specified candidates in HumanResources.JobCandidate table of the AdventureWorks2012 sample database. The @CandidateId and @MatchedID variables represent values from the key column of the full-text index.

SELECT TOP(5) KEY_TBL.keyphrase, KEY_TBL.score
FROMSEMANTICSIMILARITYDETAILSTABLE
    (
    HumanResources.JobCandidate,
    Resume, @CandidateID,
    Resume, @MatchedID
    ) AS KEY_TBL
ORDER BY KEY_TBL.score DESC;
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.