Hate to admit but Apple Mail is the only one I know that has fast (albeit simple) local search even for large mailboxes.