What about something along the lines of
For misfire and variants, try mis.*fire
Simplistic (and not on my computer to check), but should find all variations of both words.
The challenge that I’ve had with regex_match is that the contents of the entire field have to match the code. Regex count matches finds how many matches to a code are within a field.
Please let me know if that helps.