Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We're implementing a tagging system for our site, where tags are delimited by a comma (",") and using fulltext-search in sql server to search for items tagged with something. The problem is, whe're finding the search results a bit too forgiving and would like searches to only break on commas.

We found an article on msdn ( describing how to install custom word breakers, but we're not to keen on paying a third party to deliver a .dll to us - is there any other way?

share|improve this question

You mean except implementing the DLL yourself? No. But that is something you can do. Just start programming ;)

Note taht this is 208 R2 (!) only as a solution, so it is not even applciable to your database server (which you say is 2008).

share|improve this answer
Here's the SQL 2008 version at that article. Customer word breakers are fully supported on SQL 2008 as well. There isn't much change in full text search (if any) between SQL 2008 and SQL 2008 R2. – mrdenny Jan 27 '11 at 17:48

You would probably need to write a custom word breaker dll and attach that to the SQL Server. Also here's the SQL 2008 version of that article (unless you are actually on R2).

share|improve this answer
How would this compare to writing a replacement set in the sql server thesaurus replacing all delimiters with nothing? I.E: <replacement> <pat>-</pat> <sub></sub> </replacement> – nillls Jan 28 '11 at 9:17
A custom word breaker would be more efficient over all, as string replacement in SQL Server is not efficient in the slightest. – mrdenny Jan 28 '11 at 18:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.