Drayven
09-15-2010, 03:08 PM
Anyone here have any experience with Microsoft Full Text Searching? I'm trying to track down an issue at work and can't seem to make any traction. Basically it's like this, we allow keyword searching across assets in a database. The stemming feature allows users to search for a word like "run" and find variations such as "running." It appears that when searching for "Best" it is also finding "Good" as a stemming value which is fine, the problem is that it doesn't actually return any results containing the word 'best', it only finds results with the word 'good' in them. In other cases like the above example it would find both 'run' and 'running'. I've been trying to Google this up but with terms like "microsoft full text search stem good best" you can only imaging the number of results I get that aren't relevant :P Anyone got any ideas?