下面的不就行了吗？

WHERE (YourColumn LIKE '%lorem%' AND YourColumn LIKE '%ipsum%')
OR YourColumn LIKE '%asdf%'

您可以使用如下所示的存储过程：

ALTER PROCEDURE proc_MatchWordCombinations
    @input NVARCHAR(MAX)
AS
BEGIN
    DECLARE searchRows CURSOR
    FOR SELECT * FROM WordCombinations;

    DECLARE @searchRow NVARCHAR(MAX)

    DECLARE @searchParts TABLE(RowID int not null primary key identity(1,1), searchPart NVARCHAR(MAX), processed BIT NOT NULL DEFAULT 0)
    DECLARE @searchPart NVARCHAR(MAX)
    DECLARE @searchPartID INT

    DECLARE @partsToProcess INT
    DECLARE @index INT
    DECLARE @match BIT

    OPEN searchRows

    FETCH NEXT FROM searchRows INTO @searchRow

    WHILE @@FETCH_STATUS = 0
    BEGIN
        PRINT 'Search row: ' + @searchRow

        DELETE FROM @searchParts

        INSERT INTO @searchParts (searchPart)
        SELECT value
        FROM STRING_SPLIT(@searchRow, '%');
        DELETE FROM @searchParts WHERE searchPart = ''

        SELECT @partsToProcess = COUNT(1) FROM @searchParts
        SET @index = 0
        SET @match = 1
        WHILE @index < @partsToProcess
        BEGIN
            SET @index = @index + 1
            PRINT @index

            SELECT TOP 1 @searchPart = searchPart, @searchPartID = RowID FROM @searchParts WHERE processed = 0
            UPDATE @searchParts SET processed = 1 WHERE RowID = @searchPartID
            PRINT 'Search part: ' + @searchPart

            IF CHARINDEX(@searchPart, @input) = 0
            BEGIN
                SET @match = 0
                PRINT 'No match: ' + @searchPart
            END
            ELSE
            BEGIN
                PRINT 'Match: ' + @searchPart
            END
        END

        IF @match = 1
        BEGIN
            -- The input matches the search row
            PRINT 'Match on: ' + @searchRow
        END

        FETCH NEXT FROM searchRows INTO @searchRow
    END

    CLOSE searchRows
    DEALLOCATE searchRows
END

并这样称呼它：

EXEC proc_MatchWordCombinations @input = 'ipsum1234lorem'