CREATE TABLE Test
(
	Id INT IDENTITY(1, 1),
	Body XML,
	CONSTRAINT PK_Test PRIMARY KEY CLUSTERED (Id)
)

INSERT INTO	Test 
(Body)
VALUES 
('<Root><Value>Собака 
упала</Value></Root>')

CREATE FULLTEXT INDEX ON Test
(Body LANGUAGE 1033)
KEY INDEX PK_Test
ON ProductFTS
WITH STOPLIST = SYSTEM

SELECT * FROM Test
WHERE CONTAINS(Body, '"Собака упала"')

SELECT special_term, display_term
FROM sys.dm_fts_parser
  (@Search1, 1033, 0, 0)

-- функция для сплита строки
CREATE FUNCTION dbo.splitstring ( @stringToSplit VARCHAR(MAX) )
RETURNS
 @returnList TABLE ([Name] [nvarchar] (500))
AS
BEGIN

 DECLARE @name NVARCHAR(255)
 DECLARE @pos INT

 WHILE CHARINDEX(' ', @stringToSplit) > 0
 BEGIN
  SELECT @pos  = CHARINDEX(' ', @stringToSplit)  
  SELECT @name = SUBSTRING(@stringToSplit, 1, @pos-1)

  INSERT INTO @returnList 
  SELECT @name

  SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos)
 END

 INSERT INTO @returnList
 SELECT @stringToSplit

 RETURN
END

-- А тут уже пример 
DECLARE @Search1 NVARCHAR(512) = 'Собака' + CHAR(13) + CHAR(10) + 'упала в 12:26:16 123 - #'

DECLARE @SplitingString TABLE
(
	Word nvarchar(256)
)	
INSERT INTO @SplitingString
(
	Word
)
SELECT 
	* 
FROM splitstring(@Search1)

 
DECLARE @Result NVARCHAR(512); 
-- Здесь будет строка формата 'собака NEAR упала NEAR в NEAR 12:26:16 NEAR 123' 

SELECT
    @Result = CASE
        WHEN @Result IS NULL
        THEN T.display_term
        ELSE @Result + ' NEAR ' + T.display_term
    END
FROM
    (
    SELECT 
		* 
	FROM @SplitingString SS 
	INNER JOIN 
		(
			SELECT 
				display_term 
			FROM sys.dm_fts_parser('"' + @Search1 + '"', 1033, 0, 0)
		) as Q
		ON Q.display_term = SS.Word
    ) AS T

 
SELECT * FROM Test WHERE CONTAINS(Body, @Result)  

CREATE FULLTEXT CATALOG ProductFTS 

CREATE TABLE Test2
(
	Id INT IDENTITY(1, 1),
	Body VARCHAR(512),
	CONSTRAINT PK_Test2 PRIMARY KEY CLUSTERED (Id)
)

INSERT INTO	Test2 (Body)
VALUES 
('Собака 
упала')

INSERT INTO	Test2 (Body)
VALUES ('Ушел' + CHAR(13) + CHAR(10)  + 'паровоз')

CREATE FULLTEXT INDEX ON Test2
(
	Body LANGUAGE 1033
)
	KEY INDEX PK_Test2 ON ProductFTS 
	WITH STOPLIST = OFF

SELECT * FROM Test2 WHERE Contains(Body, '"Собака упала"')
-- Есть результат 

SELECT * FROM Test2 WHERE Contains(Body, '"Ушел паровоз"')
-- Есть результат

SELECT display_term, column_id, document_count
FROM sys.dm_fts_index_keywords
  (DB_ID('Put your db name'), OBJECT_ID('Test'))

SELECT display_term, column_id, document_count
FROM sys.dm_fts_index_keywords
  (DB_ID('Put your db name'), OBJECT_ID('Test2'))

CREATE TABLE Test3
(
	Id INT IDENTITY(1, 1),
	Body XML,
	CONSTRAINT PK_Test3 PRIMARY KEY CLUSTERED (Id)
)

INSERT INTO	Test3 (Body)
VALUES 
('Собака 
упала')

INSERT INTO	Test3 (Body)
VALUES ('Ушел' + CHAR(13) + CHAR(10)  + 'паровоз')

CREATE FULLTEXT INDEX ON Test3
(
	Body LANGUAGE 1033
)
	KEY INDEX PK_Test3 ON ProductFTS 
	WITH STOPLIST = OFF

SELECT * FROM Test3 WHERE Contains(Body, '"Собака упала"')
-- пусто 
SELECT * FROM Test3 WHERE Contains(Body, '"Ушел паровоз"')
-- пусто 

SELECT * FROM Test

SELECT * FROM Test
WHERE CONTAINS(Body, '"Собака" AND "упала"')

SELECT * FROM Test
WHERE CONTAINS(Body, '"Собака" AND "упала"')

CREATE TABLE Test3
(
	Id INT IDENTITY(1, 1),
	Body XML,
	CONSTRAINT PK_Test3 PRIMARY KEY CLUSTERED (Id),
	BodyText as cast(Body as nvarchar(max))
)

INSERT INTO	Test3 (Body)
VALUES 
('Собака 
упала')

INSERT INTO	Test3 (Body)
VALUES ('Ушел' + CHAR(13) + CHAR(10)  + 'паровоз')

CREATE FULLTEXT INDEX ON Test3
(
	BodyText LANGUAGE 1033
)
	KEY INDEX PK_Test3 ON ProductFTS 
	WITH STOPLIST = OFF

SELECT * FROM Test3 WHERE Contains(BodyText, '"Собака упала"')
-- пусто 
SELECT * FROM Test3 WHERE Contains(BodyText, '"Ушел паровоз"')
-- пусто 

<Root><Value>?????? 
?????</Value></Root>