Neither search method supports any kind of patterns! Do not be tempted to try a regex, or anything remotely like one. Not even wildcards!
No, all strings are interpreted as plain, simple strings. Search/SuperSearch simply look for these strings occurring anywhere in the title or body. (Search looks only in titles; SuperSearch looks in titles or bodies, as you choose.) No word boundaries are inferred, either. And all searching is case-insensitive.
Note that, in SuperSearch, the default string separator is space, but this can be changed. In Quick Search, this default cannot be overridden.