Split into words and search in SQL Server column

Here I have created script that searches based on search condition like if you will search with key "Da" then it will return records contain "Da", also it full-fills your requirement as well.

SCRIPT

CREATE TABLE #temp(ID INT,FullName VARCHAR(100))
 
INSERT INTO #temp VALUES(1,'David James Morkel')
INSERT INTO #temp VALUES(2,'Bijay kumar kush')
INSERT INTO #temp VALUES(3,'Jhon Kevin Moorey')
 
DECLARE @SearchName VARCHAR(200) = NULL
 
SET @SearchName = 'Bijay kush'
DECLARE @Count INT;
DECLARE @i  INT = 0
DECLARE @j INT = 1
WHILE (@i) < LEN(@SearchName)
BEGIN		
	SELECT @Count = COUNT(*) FROM #temp
	WHERE (FullName LIKE '%' + SUBSTRING(@SearchName,@j,LEN(@SearchName))  + '%') OR @SearchName IS NULL

	IF @Count > 0
	BEGIN
		SELECT * FROM #temp
		WHERE (FullName LIKE '%' + SUBSTRING(@SearchName,@j,LEN(@SearchName))  + '%') OR @SearchName IS NULL
		BREAK;
	END
	SET @i = @i + 1
	SET @j = @j + 1
END
DROP TABLE #temp

Screenshot

Here I have created script that searches based on search condition like if you will search with key "Da" then it will return records contain "Da", also it full-fills your requirement as well.

SCRIPT

CREATE TABLE #temp(ID INT,FullName VARCHAR(100))
 
INSERT INTO #temp VALUES(1,'David James Morkel')
INSERT INTO #temp VALUES(2,'Bijay kumar kush')
INSERT INTO #temp VALUES(3,'Jhon Kevin Moorey')
 
DECLARE @SearchName VARCHAR(200) = NULL
 
SET @SearchName = 'Bijay kush'
DECLARE @Count INT;
DECLARE @i  INT = 0
DECLARE @j INT = 1
WHILE (@i) < LEN(@SearchName)
BEGIN		
	SELECT @Count = COUNT(*) FROM #temp
	WHERE (FullName LIKE '%' + SUBSTRING(@SearchName,@j,LEN(@SearchName))  + '%') OR @SearchName IS NULL

	IF @Count > 0
	BEGIN
		SELECT * FROM #temp
		WHERE (FullName LIKE '%' + SUBSTRING(@SearchName,@j,LEN(@SearchName))  + '%') OR @SearchName IS NULL
		BREAK;
	END
	SET @i = @i + 1
	SET @j = @j + 1
END
DROP TABLE #temp

Screenshot