Does anyone know if there is a list of German words used in the Fulltext word breaker?
SQL Server Full Text Search uses language specific Word Breakers.
For the German language this is used to break/split words including compound words. However, it appears not all known compound words are included in the Word Breaker. I would like to know if a list is available of the words the Word Breaker does know about.
have you read this page, somewhere in microsoft msdn says how to see the list of words. The following links might help you.
Good luck with that...
in sql server 2008 this works... the language_id i put here is for german. I wanted to see the same thing but for spanish.
SELECT * FROM sys.fulltext_system_stopwords WHERE language_id = 1031
edit: in sql server 2005 the words are stored here "$SQL_Server_Install_Path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\", If you edit the noise-word file, you have to repopulate the full-text.
The answer is there is no answer. According to Microsoft , the words are not stored - they use a formula to "break" them. This will never be 100% accurate so i will just have to live with this fact.