Full-Text Stoplists in Management Studio

Date: 29.07.2012

The MatchPoint tag picker control sometimes seems to behave "strange". For example, the user can not find the tag "e 09" by typing "e 09".

The reason for this is the default stoplist for full-text search in SQL Server 2008. It includes meaningful information like this:

FULLTEXT STOPLIST [demo] ADD '?' LANGUAGE 'Simplified Chinese';

but also this...

ALTER FULLTEXT STOPLIST [demo] ADD 'e' LANGUAGE 'Neutral';
ALTER FULLTEXT STOPLIST [demo] ADD 'e' LANGUAGE 'Traditional Chinese';
ALTER FULLTEXT STOPLIST [demo] ADD 'e' LANGUAGE 'German';
ALTER FULLTEXT STOPLIST [demo] ADD 'e' LANGUAGE 'French';
...
ALTER FULLTEXT STOPLIST [demo] ADD 'e' LANGUAGE 'Spanish';

To make "e" available in the full-text index, you have to either turn full-text stoplist off on your database table or create your own full-text stoplist and associate it with the appropriate table.

Turn Off Full-Text Stoplist in SQL 2008 Server

You can do directly in SQL Management Studio. To turn it off is very easy. Just navigate to your database table. In our case this is "TagName" and choose Full-Text index->Properties. On this screen you can choose the existing full-text stoplists.

Create an Adjusted Full-Text Stoplist in SQL 2008 Server

If you want to keep your index clean and performant you can just create a stoplist from the system stoplist and and adjust it to your needs.

It works

Now you are able to find the Tag "e 09".