Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “tether” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

112 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
tether	9	37	1610	(None)
aether	9	42	1367	1	aether
ether	8	45	1877	1	_ether
nether	9	40	1416	1	nether
teether	10	34	969	1	teether
tethers	10	38	1531	1	tethers
tetter	6	43	2245	1	tetter
tither	9	49	2028	1	tither
tother	9	41	1714	1	tother
wether	12	33	1539	1	wether
aethers	10	36	1494	2	aethers
anther	9	37	1506	2	anther
bather	11	53	2251	2	bather
bethel	11	6	964	2	bethel
better	8	47	2370	2	better
blether	12	45	991	2	blether
bother	11	52	1806	2	bother
cither	11	46	1668	2	cither
deter	6	50	2804	2	det_er
diether	11	4	744	2	diether
dither	10	44	1768	2	dither
either	9	45	1742	2	either
etcher	11	39	1294	2	etcher
ethers	9	45	1841	2	_ethers
father	12	51	1671	2	father
feather	13	36	1350	2	feather
fetcher	15	35	1039	2	fetcher
fetter	9	41	2038	2	fetter
gather	10	41	1585	2	gather
getter	7	41	1761	2	getter
heather	13	39	1485	2	heather
hither	12	44	1725	2	hither
ither	8	46	1760	2	_ither
lather	9	51	2435	2	lather
leather	10	38	1578	2	leather
lecher	11	34	1585	2	lecher
lethe	8	57	1730	2	lethe_
lethes	9	48	1808	2	lethes
letter	6	37	2258	2	letter
lither	9	45	2095	2	lither
meter	7	51	3032	2	met_er
metier	8	35	1769	2	metier
mither	11	42	1856	2	mither
mother	11	37	1864	2	mother
neither	10	3	757	2	neither
netter	6	37	2202	2	netter
nother	9	38	1596	2	nother
other	8	42	1910	2	_other
peter	7	44	2759	2	pet_er
petter	8	39	2477	2	petter
pother	11	38	1885	2	pother
rather	9	43	1974	2	rather
setter	6	40	2372	2	setter
tater	5	41	3861	2	tat_er
tatter	6	40	2457	2	tatter
teacher	12	37	1483	2	teacher
tearer	6	48	2290	2	tearer
teaser	6	54	2152	2	teaser
teched	12	40	1443	2	teched
techier	12	6	924	2	techier
tedder	8	33	1215	2	tedder
teemer	8	55	1574	2	teemer
teener	6	47	1750	2	teener
teeter	6	54	2031	2	teeter
teethe	9	45	1131	2	teethe_
teethed	11	31	862	2	teethed
teethers	11	32	871	2	teethers
teethes	10	36	1165	2	teethes
telfer	9	37	989	2	telfer
teller	6	35	1981	2	teller
telpher	12	3	556	2	telpher
temper	10	39	1409	2	temper
tender	7	41	2184	2	tender
tenner	6	41	1710	2	tenner
tenser	6	49	1943	2	tenser
tenter	6	46	2393	2	tenter
tentier	7	38	1592	2	tentier
termer	8	57	1725	2	termer
terser	6	73	1782	2	terser
tester	6	42	2715	2	tester
testier	7	40	1564	2	testier
tetched	13	30	1077	2	tetched
tetchier	13	3	645	2	tetchier
teth	7	63	2789	2	teth__
tethered	12	3	849	2	tethered
teths	8	54	1851	2	teth_s
tetters	7	43	2047	2	tetters
thither	13	32	810	2	thither
titer	5	54	3061	2	tit_er
titfer	9	40	952	2	titfer
tithe	8	53	1970	2	tithe_
tithed	10	41	1559	2	tithed
tithers	10	42	1673	2	tithers
tithes	9	47	2021	2	tithes
titter	6	34	2116	2	titter
tocher	11	40	1491	2	tocher
together	12	4	374	2	together
toter	5	59	3213	2	tot_er
totter	6	50	2146	2	totter
tythe	11	52	1045	2	tythe_
tythed	13	45	750	2	tythed
tythes	12	41	970	2	tythes
untether	11	4	516	2	untether
vetoer	9	34	1006	2	vetoer
vetter	9	34	1764	2	vetter
weather	13	35	1322	2	weather
wethers	13	52	1469	2	wethers
wetter	9	39	1944	2	wetter
whether	16	34	662	2	whether
wither	12	43	2135	2	wither
wuther	12	45	1161	2	wuther
zither	18	38	1308	2	zither

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	82551	0.106	1685764.2
2	DLD Change Limit	82551	112	2.643	31233.8
3	Display Results	112	112	0.030	3733.3
	(SQL Overall)	178691	112	2.779	64300.5