2

I want to use CONTAINS on a fulltext index and use FORMSOF(...) on Hungarian data. Is it possible? I KNOW it is not supported by default in SQL Server.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
TDaver
  • 7,164
  • 5
  • 47
  • 94

1 Answers1

4

SQL Server can load custom word breakers and stemmers, see Word Breakers and Stemmers. If you cannot find a Hungarian stemmer there is always the possibility of creating one your own: Word Breaker and Stemmer Sample, see also Getting the LRSAMPLE custom word-breaker to work on 64-bit SQL Server 2008. You don't have to implement the dictionary yourself, you could simply reuse for instance the libstemmer Hungarian Snowball algorithm and package it as a SQL Server stemmer.

Remus Rusanu
  • 288,378
  • 40
  • 442
  • 569
  • That's way more work than what I can do on this project. I was hoping for a nice link to "Download Hungarian word breaker here"... :( No wonder I didn't find any googling by myself. – TDaver Aug 20 '11 at 08:29