Full Text Search Word Breaker

Posted on September 4, 2008


We have an issue currently with the Word Breaker in Full Text Search. Using SQL 2008 , we were able to identify what was actually being parsed using the new sys.dm_fts_parser function.

In German they have compound words. Using the German Word Breaker it should split these compound words out. If you use the following query in SQL 2008 you will see this works for the word used in the example:

SELECT * FROM sys.dm_fts_parser
 (‘wirtschaftsprüfung’, 1031,0,0)

However, not all german compound words are split. If you use the same function with ‘Installationsingeneur’ :

SELECT * FROM sys.dm_fts_parser
 (‘Installationsingeneur’, 1031,0,0)

It does not split the word at all.

I want to ask anyone out there if there is an answer to this.