The Contains Search allows you to search for a segment of a keyword. For example, if you searched for "goo", in the Keyword Search section of the autocomplete menu, you could select "goo in App Name", which contains your keyword segment. Search results contain any App Name with "goo" in it, and display any Google app.
The Contains Search is available in the Omnibar on the Connected Apps page.
On the Connected Apps page, you can also search by Google OAuth Scope and Client ID.