FullText Not Searching On Phrase With Space Correctly

Question

I have a fulltext query that uses the containstable function. The phrase being searched is "over speed". I'm using a case insensitive sort. The result sets are coming back with the word speed but not the word over. The message return states:

The full-text search condition contained noise word(s).

The phrase is not negiotable as I am specifically looking for the phrase "over speed". Is over a noise word?

---

DJ Baby Anne's Biggest Fan................

Answer 1

Yes, it is. You will need to remove it from your noise word list and rebuild your catalog to be able to search on it.

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

The scary thing is that I don't see any noise files. I've run the 

select * from sys.fulltext_stopwords

and

select * from sys.fulltext_stoplists

statements and they both returned no rows. There's some mention of a resource database but I can't attach to it. I don't want to mess this up but if I create a StopList does it inherit all the stopwords from the Resource database? I'm running SQL 2008.

---

DJ Baby Anne's Biggest Fan................

Answer 3

The system one does not show up in these queries. You will need to create a custom one and then remove over from it.

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 4

I actually ended up setting the Full-Text Index StopList to off  and the query works correctly.

---

DJ Baby Anne's Biggest Fan................