Getting names with letters, in no order, and anywhere in the word

Question

I have a list of names. I want to be able to pull names from the list that contain certain letters. I want to find all names that contain letter x, y, z, ... anywhere in the word, in any order. It does not matter if it is case-insensitive, or case-sensitive. It needs to be able to input anywhere from 1 - 9 letters. I haven't tried much because I do not have an extreme understanding of Google Sheets, or Excel, but I do not know how I would be able to put a formula that would be able to do that. Thanks for the help!

Prashanth K V · Accepted Answer

Hi, Atreyu Heller,
I've provided a different solution this time using non-array formulas.
B3 Formula (copied down):
=ArrayFormula(count(match(countifs(row(indirect("A1:A"&len(A3))),"<="&row(indirect("A1:A"&len(A3))),transpose(split(regexreplace(A3,".","$0,"),",)")),transpose(split(regexreplace(A3,".","$0,"),",)")))&transpose(split(regexreplace(A3,".","$0,"),",)")),countifs(row(indirect("A1:A"&len($D$1))),"<="&row(indirect("A1:A"&len($D$1))),transpose(split(regexreplace($D$1,".","$0,"),",)")),transpose(split(regexreplace($D$1,".","$0,"),",)")))&transpose(split(regexreplace($D$1,".","$0,"),",)")),0)))=len($D$1)
E2 Formula:
=filter(A3:A,B3:B)

Please check pkv_test2.
Best,
Prashanth KV