"Combining a free-style member name input with that search would make it horribly expensive (computing resource cost) and slow."
Not really. I've spent the last 20 years as a DBA and optimizing database systems. Put an index on the member-names and that query is nearly instantaneous.