Filter Extract a text from excel sheet having similar values

Question

I have data in the cell in this format saved in the A column in Excel.

[Amber,Maria,Marian,Mar]

[Maria]

[Marian,Amber,Maria]

[Maria,Marian]

I want a filter for Maria and Marian.

How can I use some regex formula filtering Maria and Marian separately?

Answer 1

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))

 shows TRUE if Maria is found and false if it would only be Marian, not Maria.