In SQL full-text search, the wildcard * works only at the end of the query.

Example

You cannot search for *ord, while you can search for wor*.