When using the native SQL text search, you can only specify a trailing wildcard for word searches.

There may be matching Records that are prevented from being displayed because of filtering, or for security reasons.