Full-Text Search misses last word?

[codecontractor]

Does full text indexing not include the last word in a phrase?

I have found that the last word in a field of several sentances is universally missed in my 'contains inflectional forms of...' queries. Is this a known bug, or am I doing something wrong either in my query or my indexing?

Here are some examples:

A search for horsepower finds this record, but a search for graphs does not.​

How to be sure your horsepower and shaft speed are matched with prop diameter and blade area to get the most power. 4 pages with diagrams and graphs.

A search for called finds this record, but a search for Caravel does not.​

Out-of-Production 22-foot monohull aft-cockpit sloop from Bristol Yachts. Designed by Halsey Herreshoff. Formerly built in the USA. 325 produced from 1968 to 1978. Also called the Caravel.

Thank you.
-Ben

 

[SQLSister]

What is your specific code that you use for the search?

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[codecontractor]

Sorry, here it is:

ALTER PROCEDURE CRSearchProc
(
-- Search Term
@word varChar(64)
)
AS

DECLARE @query varChar(128)
SET @query = 'FORMSOF (INFLECTIONAL, ' + @word + ')'

SELECT   *
FROM     TABLE
WHERE	
CONTAINS ( Description, @query )

 

[SQLSister]

AS a guess, I'd say that it doesn't consider punctuation as one of the inflectional forms. Just to prove if this is right, try to search for Herreshoff. It isn't the last word but it does have a period after it.



Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[codecontractor]

Herreshoff shows up and I tried Yachts as well and that worked.

 

[SQLSister]

Are you up to date on your service packs? Some fixes to fulltext search are inthem.

Aslo is your fulltext index out of date? MAybe it needs repopulating.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief