I have a table of words that looks like this?
CREATE TABLE [dbo].[WordForm] (
[Word1] VARCHAR (20) NOT NULL,
[Word2] VARCHAR (20) NOT NULL
For a more performant solution on large datasets try this:
SELECT w.Word1 as [Word 1 Not in Word 2] FROM WordForm w EXCEPT SELECT w.Word2 FROM WordForm w ; SELECT w.Word2 as [Word 2 Not in Word 1] FROM WordForm w EXCEPT SELECT w.Word1 FROM WordForm w ;