Posts Tagged ‘Fuzzy Search’

Full-Text in SQL Express

In order to perform full text search in SQL 2005 or 2008 you need to create a catalog and define the fields to be indexed for full text search. The difficultyis that if you are using SQL Express you will realize that the steps and menus which are explained in is not available for you. So the only way to prepare your database is using SQL Statements. In summary the following steps are needed:

  1. Disable user instances: sp_configure ‘user instances enabled’,0
  2. Make sure your database has full-text search enabled, by checking the “use full-text indexing” in database properties, Going to “Files” and checking the “use full-text indexing” option
  3. Create catalogue: CREATE FULLTEXT CATALOG MyFullTextCatalog
  4. CREATE FULLTEXT INDEX ON Production.ProductReview(Comments)
    KEY INDEX ui_ProductReview ON MyFullTextCatalog

Important: the table should have unique intexed not-null field.

You can find a more comprehensive instruction in

Other articles to read:

Getting Started with Full-Text Search


Full-Text Sql Search Tips