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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

88 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
nether	9	40	1416	(None)
aether	9	42	1367	1	aether
ether	8	45	1877	1	_ether
neither	10	3	757	1	neither
netter	6	37	2202	1	netter
nother	9	38	1596	1	nother
tether	9	37	1610	1	tether
wether	12	33	1539	1	wether
aethers	10	36	1494	2	aethers
another	10	28	915	2	another
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
enter	5	47	2638	2	ent_er
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
natter	6	44	2074	2	natter
nearer	6	46	1889	2	nearer
neater	6	44	2431	2	neater
neatherd	12	10	719	2	neatherd
necker	12	40	1279	2	necker
needer	7	36	1495	2	needer
nephew	14	3	411	2	nephew
nester	6	41	2418	2	nester
nestler	7	35	1044	2	nestler
netted	7	41	1871	2	netted
netters	7	36	1858	2	netters
nettier	7	42	1181	2	nettier
nettler	7	34	950	2	nettler
neuter	6	37	1379	2	neuter
never	8	62	1864	2	ne_ver
newer	8	57	1746	2	ne_wer
nigher	10	36	1275	2	nigher
niter	5	50	2897	2	nit_er
norther	10	3	973	2	norther
nosher	9	46	1636	2	nosher
notcher	12	36	1093	2	notcher
noter	5	50	2564	2	not_er
nutter	6	39	1805	2	nutter
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
teether	10	34	969	2	teether
tethers	10	38	1531	2	tethers
tetter	6	43	2245	2	tetter
tither	9	49	2028	2	tither
tother	9	41	1714	2	tother
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.373	479064.3
2	DLD Change Limit	82551	88	2.503	32980.8
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	2.906	61490.4