SQL Server 2012 “Denali” Full-Text Search introduces a new custom proximity operator, which we’ve been calling “customizable NEAR.” The new NEAR operator lets you query with 2 optional requirements that you could not previously specify:
The maximum gap between the search terms.
The order of the search terms. (For example, “John” must appear before “Smith.”)
Here is a partial example of the new NEAR operator:
CONTAINSTABLE (Documents, Content, 'NEAR((... [More]