If you really need to manage stuff by domain name, I'd suggest adding a column to the table. Either load the domain from the email address, or make it a calculated column that pulls the domain from the email address. Then, you can just go with an equals operation and put an index on that column to help things out.
Otherwise, you're kind of stuck as Steve says.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning