For each unique string, need to find matching strings using substrings without putting string automatically

[Charanko]

Quite a complicated question for Excel, I think, but okay...

There are 10 thousand lines. For each unique string, need to find matching strings using substrings.
That is: 1) yellow apple, ..., 9999) golden apple - input values. 1)Yellow apple and 9999)golden apple are output values that need to be placed in another column.

And what is most important is that I do not enter one desired substring, but the program itself searches for many lines that match the substring.

example...

Book1
	A	B	C
1	input		output
2
3
4	red apple		red apple
5			apple yellow
6			golden apple
7			apple green
8	apple yellow
9
10
11
12
13	golden apple
14
15
16
17
18	apple green
Sheet1

 

[bebo021999]

What is actual data?
Apple (main word) combine with color (adjective) may different from actual data.

 

[Charanko]

What is actual data?
Apple (main word) combine with color (adjective) may different f

Is different. Yes. But it doesn't matter if it's an apple or wine, because the search goes by substrings. I know that you can't do it through functions - only through code. But the question is - via VBA? Maybe there are some add-ons for him to simplify working with him? ..