The full text search does not work as expected if an asterisk (*) is used as a wildcard at the beginning of a text.
When using the asterisk behind some characters the searching works correctly
Leading Wildcard searches (e.g. using "*uster" to match "Cluster") is not supported in MS SQL.
"... All text that matches the text specified before the asterisk (*) is returned. If the text and asterisk are not delimited by double quotation marks, as in CONTAINS (DESCRIPTION, 'top*'), full-text search does not consider the asterisk to be a wildcard..."