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

xcode custom tab bar 1 pixel gap at top

ios objective-c xcode tabs

I am currently updating some old Xcode apps in Xcode 6.

Sending data with radio buttons

php template-lite

I need to send some data with radio button.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.