SQL Server 2005. Full Text Search. Need Thesaurus working with NEAR/AND/OR keywords

Question

does anyone know if it's possible to do a thesaurus search together with NEAR or AND/OR keywords. Here is an example of the type of query I want to run:

    SELECT Title, RANK
            FROM Item INNER JOIN
            CONTAINSTABLE(Item, Title, 'FORMSOF(Thesaurus, "red" NEAR "wine")') AS KEY_TBL
            ON Item.ItemID = KEY_TBL.[KEY]
    ORDER BY RANK DESC

....But I get the error message:

Syntax error near 'NEAR' in the full-text search condition 'FORMSOF(Thesaurus, "red" NEAR "wine")'.

score 1 · Answer 1 · edited Jul 07 '17 at 11:34

1

Near and FormsOf don't work well with each other. Read the following link Is it possible to combine NEAR and FORMSOF together in a fulltext search?

use IsAbout

SELECT   K.RANK, name, Description
FROM      Diagnosis AS C
INNER JOIN
CONTAINSTABLE(diagnosis,name, 'ISABOUT (
FORMSOF(Thesaurus, "red"),
FORMSOF(Thesaurus, "wine"))', 50) AS K
ON C.ID = K.[KEY];
GO

edited Jul 07 '17 at 11:34

gawi

2,843
4
29
44

answered Jul 07 '17 at 11:10

Asfandyar Peerzada

96
5

score 0 · Answer 2 · answered Jul 29 '10 at 13:12

The syntax of thesaurus is slightly different, you you might be looking for is something like:

SELECT Title, RANK
            FROM Item INNER JOIN
            CONTAINSTABLE(Item, Title, 'FORMSOF(Thesaurus, "red") NEAR FORMSOF(Thesaurus, "wine")') AS KEY_TBL
            ON Item.ItemID = KEY_TBL.[KEY]
    ORDER BY RANK DESC

SQL Server 2005. Full Text Search. Need Thesaurus working with NEAR/AND/OR keywords

2 Answers2