Example made just for fun:
DECLARE @tmp TABLE(aField NVARCHAR(500))
INSERT INTO @tmp (aField)
VALUES('Sony Bla bla bla'), ('Son Of The Music'), ('Paranoya Player')
DECLARE @inputText NVARCHAR(300) = 'Sony Music Player'
;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),'%')
Result:
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