Full Text Search in SQL 2008
I don't believe that full text search will match based on the back end of the word being passed in.  You could have it match "Wher*" but not "*here".  This is called prefix matching.


  &lt; prefix term> ::= {"word*" | "phrase*" }


Trying to match based on "*here" would be a VERY expensive match for the full text engine to do.