Stored Procedure For Seach query

--temporary table
DECLARE @tmp TABLE(aField NVARCHAR(500))
--insert sample data
INSERT INTO @tmp (aField)
VALUES('Sony Bla bla bla'), ('Son Of The Music'), ('Paranoya Player')
--input text
DECLARE @inputText NVARCHAR(300) = 'Sony Music Player'
--split input text into words ;)
;WITH InputParts AS
(
    SELECT LEFT(@inputText, CHARINDEX(' ', @inputText) -1) AS Word, RIGHT(@inputText, LEN(@inputText) - CHARINDEX(' ', @inputText)) AS Remainder
    WHERE CHARINDEX(' ', @inputText)>0
    UNION ALL
    SELECT LEFT(Remainder, CHARINDEX(' ', Remainder) -1) AS Word, RIGHT(Remainder, LEN(Remainder) - CHARINDEX(' ', Remainder)) AS Remainder
    FROM InputParts
    WHERE CHARINDEX(' ', Remainder)>0
    UNION ALL
    SELECT Remainder AS Word, NULL AS Remainder
    FROM InputParts
    WHERE CHARINDEX(' ', Remainder)=0
)
SELECT t1.aField, @inputText AS SearchedText, t2.Word AS MatchedWord  
FROM @tmp AS t1 INNER JOIN InputParts AS t2 ON LOWER(t1.aField) LIKE CONCAT('%', LOWER(t2.Word),'%')

aField	            SearchedText        MatchedWord
Sony Bla bla bla	Sony Music Player	Sony
Son Of The Music	Sony Music Player	Music
Paranoya Player	    Sony Music Player	Player