I have a full text index, consisting of products and their descriptions. Most of the descriptions are sized based, ie. 2" x 4" x 6" Box or 2.50" x 6" Pole, etc... I'm having issues getting a fulltext query to work properly, users may enter 2" or 2 in or 2in. or 2 inch, etc. all the different ways to possibly say 2 inch. I thought I'd be able to setup expansion entries in the thesaurus file, but it doesn't seem to be working properly, it looks like SQL is adding nn as a prefix to the number, then throwing a duplicate thesaurus phrase error, I don't think I'm handling the " properly, etc.
and quite a few other variations, I'm thinking in maybe causing some grief since its a system stopword, but I thought it being a thesaurus entry overrides the noise list.