Advanced Filter with Array formula wildcard

[pto160]

I have a formula that looks for a certain word within a text string in multiple columns.
small(if(not(iserror(search("house", B2:E50))),row(B2:E50)),rows($A1:A1)).
This gives me the row number.
It does not work with advanced filter.
The intent is to filter on rows that may be contained in multiple columns for the word house. I'll have to use some sort of wildcard.

 

[pto160]

I should've been more clear about the question I have.
Can I use this array formula with advanced filter or do I need another formula?