How do you get leading wildcard full-text searches to work in SQL Server?

Workaround only for leading wildcard:

• store the text reversed in a different field (or in materialised view)
• create a full text index on this column

• find the reversed text with an *

  SELECT * 
  FROM TABLENAME 
  WHERE CONTAINS(TextColumnREV, '"mrethcraes*"');
  

Of course there are many drawbacks, just for quick workaround…

Not to mention CONTAINSTABLE…