Excel find partial match in column

I am trying to write a formula which will return a positive value to a cell G3 if the content of D3 is a partial match to anything found in the same column excluding itself. I.e.

Red - No Match Blue - Partial Match Light Blue - No Match

No match because "Red" is not a partial match with any of the other results, Partial match because "Blue" IS a partial match for "Light Blue".

I am using the current formula, but it returns false when I expect it to return true

=IF(ISNUMBER(SEARCH(D3,$D$1:D2,D4:$D$10000)),"Yes","No")