Noise Words in Search Argument -- HHHEELLLPP!!!

Hi,
I am experiementing with SQL Server 2005 Full Text Search.  The user key in an Organization Name and I'm searching a column.

My problem is the noise words which are eliminated from the index are not eliminated from the search string or criteria - so what the point!!!

For example (using AdventureWorks)
  Select Comments from Production.ProductReview
  where Contains(Comments, ' "worth" AND "heavy"  AND "the"');

This returns no rows (with a noise word warning).  If I have to eliminate the noise words from the user input, then I don't see the point of them!!  They would be usefull if SQL Server eliminated them from the search strings also.

Now if you use a string and the noise words are ONLY at the beginning or the end, it seems to be OK:
  Select Comments from Production.ProductReview
  where Contains(Comments, ' "the the learning curve the, the" ');

This returns a row with a noise word warning.

I'm confused because I thought the purpose of the noise words was to create a better "fuzzy search".  But it seems I have to scan the input string and remove them manually?

Am I missing something?

Thanks in advance!!!
hefterr
LVL 1
hefterrAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
>>But it seems I have to scan the input string and remove them manually?<<
Yes or ignore the error.

>>Am I missing something?<<
Not really.
0
 
hefterrAuthor Commented:
Hi acperkins,
I discoved for my search needed, the best you can di is either use :

 Select Comments from Production.ProductReview
  where Contains(Comments, ' "the the learning curve the, the" ');

In this case the precedeing and trailing noise words are ignored in the input (OK).


Or use
SELECT Title
FROM Production.productionReview
WHERE FREETEXT (Comments,  "the the learning curve the, the");

In this case a more "fuzzy" search takes place.  An exact match is not needed.

hefterr
0
 
hefterrAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.