A full-text function returning a table of matching rows, each with a KEY and a RANK for relevance, so results can be ranked.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains CONTAINSTABLE in context, with comparison tables and the common traps.
Terms in this definition
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Index field attributes
Settings applied to each field in an Azure AI Search index:
searchablefor full text,retrievableto return it,filterablefor exact-match$filter,sortable,facetablefor counts, andkeyfor the unique document ID. - RANK
A window function, found in T-SQL (used with OVER) and in DAX, that gives each row's position within its partition. In DAX it accepts ORDERBY and PARTITIONBY, skips ranks after ties unless DENSE is chosen, and returns blank for total rows.
Related terms
- FORMSOF
Used within CONTAINS or CONTAINSTABLE to also match thesaurus synonyms (THESAURUS) or other inflections of a word (INFLECTIONAL, so hike also finds hiked and hikes).
- Hybrid search in T-SQL
Combines keyword and meaning-based results by running a vector search alongside a full-text query (CONTAINSTABLE or FREETEXTTABLE) on the same data, then merging the two rankings, usually with Reciprocal Rank Fusion.