Full-text Search Stemming Not Returning Consistent Results In Different Languages

I have an Sql Server 2016 database with full text indexes defined on 4 columns, each configured for a different language: Dutch, English, German & French. I used the wizard to

Solution 1:

I found that there is simply no specific stemming library for Dutch (and other languages). It is not clearly stated, but this article explains how to revert word breaker and stemming to previous versions, and it appears the word breaker and stemmer are actually using the same dll.

The following query shows that for Dutch (LCID 1043) the default neutral language word breaker/stemmer is used, which explains the bad results.

EXEC sp_help_fulltext_system_components 'wordbreaker';

To get the LCID per language:

SELECT*FROM sys.fulltext_languages;