The wildcard symbol is %.  Use the wildcard to match any letters.

For example a search for %CAFE might find MARTHA'S CAFE and JAVA CAFE and CAFE MARINA because they all have the word CAFE.

Without the wildcard, a search for CAFE would only show CAFE MARINA (because it STARTS with CAFE).