As stated in the other thread, download and install the following function in your DB
CREATE_FUNCTION_dbo_DelimitedSplit8K_LEAD.sql
Then use it as follows
WITH cteTwoWords AS (
SELECT TwoWords = ss.Item + ' ' + LEAD(ss.Item) OVER (PARTITION BY td.[title] ORDER BY ss.ItemNumber)
FROM [title_one_space] AS td
CROSS APPLY dbo.DelimitedSplit8K_LEAD(td.[title], ' ') AS ss
)
SELECT TwoWord_group = cte.TwoWords
, TwoWord_count = COUNT(*)
FROM cteTwoWords AS cte
WHERE TwoWords IS NOT NULL
GROUP BY TwoWords
ORDER BY COUNT(*) DESC;