The ANSI ISO standards have a predicate for this! SIMILAR TO is based on the POSIX version of grep, which means the wildcards are keywords bracketed by colons. We picked it based on the popularity of POSIX in the US federal government at the time, but it's it's pretty strong.