how to do this partial match? Thanks in advance!

Hi, could anybody give me some insight of how to do partial match? my situation is as below: I have thousands row of column b, and column d is the things I will be deleting: instead of searching e...