• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

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
0
hefterr
Asked:
hefterr
  • 2
1 Solution
 
Anthony PerkinsCommented:
>>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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now