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.

Word Breakers and Stemmers


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.

Need Your Help

Stringbuilder adding % to end of URL

c# stringbuilder

I have a slight issue with a string being built in my code. When I debug my page the url is incorrect. For example Google's url is this when clicking on the link on my page.

Are there cases where a "finally" construct would be useful in C++?

c++ raii finally

Bjarne Stroustrup writes in his C++ Style and Technique FAQ, emphasis mine: