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