SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [Table]
( id INT IDENTITY(101,1) PRIMARY KEY,
  name NVARCHAR(100) NOT NULL
);
INSERT INTO [Table] (name) VALUES
('a munchkin'),
('never ever sever mah lever'),
('saintess'),
('them mammaries');
4 rows affected

DECLARE @value NVARCHAR(1000);
SET @value ='  m  n  ';

DECLARE @values TABLE (
 value NVARCHAR(42)
);
DECLARE @words NVARCHAR(1000);
DECLARE @word NVARCHAR(42);

SET @words = RTRIM(LTRIM(@value))+' ';

WHILE CHARINDEX(' ', @words) > 0
BEGIN
 SET @word = SUBSTRING(@words,0,CHARINDEX(' ',@words))
 SET @words = LTRIM(SUBSTRING(@words,CHARINDEX(' ',@words)+1,LEN(@words)))
 IF @word != '' INSERT INTO @values (value) VALUES (@word);
END;

DECLARE @TotalValues INT;
SET @TotalValues = (select count(distinct value) from @values);

--
-- use the table variable to query the table
--
SELECT * 
FROM [Table] t
WHERE EXISTS
(
   SELECT 1
   FROM @values v
   WHERE t.name LIKE '%'+v.value+'%'
   HAVING COUNT(DISTINCT v.value) = @TotalValues
);


id
name


101
a munchkin

102
never ever sever mah lever