Maybe this is old news, but you can use mysql wildcards in the k100 interface when running searches. Ex. If I had a ticket/user lookup for a Donald MacSomething or McSomething that I cant recall, I can search for DMemail@example.com and return the users with that combo. It looks like the % wildcard at the beginning and end of the term is implied. The single wildcard '_' (no quotes) also works. % wildcard for multiple characters, _ wilcard for single character.