Full text search does not work if stop word is included even though stop word list is empty

by

Meanwhile I have managed to solve the issue. The problem was that I had my own stop list which was indeed empty but my fulltext catalog was associated not with my own stoplist but with the system one. Here are a couple of useful queries for solving stopword and full text search issues:

Query stopwords (does not give back the system ones!):

select * from sys.fulltext_stopwords

Query stop lists (does not give back the system list!):

select * from sys.fulltext_stoplists

Check what words are included in the catalog:

SELECT * FROM sys.dm_fts_index_keywords(DB_ID('dbname'), OBJECT_ID('tablename'))

Check the association:

select fulltext_catalog_id,stoplist_id, * from sys.fulltext_indexes;

Turn stoplist off:

ALTER FULLTEXT INDEX ON CremeSearchFT SET STOPLIST = OFF

I hope it helps someone. 🙂

More Related Contents:

  1. Is it possible to use Full Text Search (FTS) with LINQ?
  2. How do you get leading wildcard full-text searches to work in SQL Server?
  3. SQL Server Full Text Search Escape Characters?
  4. 7645 Null or empty full-text predicate
  5. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  6. Full text catalog/index search for %book%
  7. How to multiply column in Sql
  8. What is the best way to create and populate a numbers table?
  9. SQL Server IN vs. EXISTS Performance
  10. How Can I Log and Find the Most Expensive Queries?
  11. How to drop a table if it exists?
  12. How to run the same query on all the databases on an instance?
  13. SQL Server truncation and 8192 limitation
  14. Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]
  15. How to list all dates between two dates [duplicate]
  16. SQL Server variable columns name?
  17. SQL Server BCP export corrupted file?
  18. PRINT statement in T-SQL
  19. Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
  20. What is the point of “Initial Catalog” in a SQL Server connection string?
  21. How can I know when SQL Full Text Index Population is finished?
  22. Should I index a bit field in SQL Server?
  23. Setting up maven dependency for SQL Server
  24. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  25. Escaping single quote in SQL Server
  26. How to set value to variable using ‘execute’ in t-sql?
  27. Data generators for SQL server? [closed]
  28. Taking the second last row with only one select in SQL Server?
  29. SQL Server Maximum rows that can be inserted in a single insert statment
  30. How to Bulk Insert from XLSX file extension?

Leave a Comment