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

Here are the results of your fuzzy-string dictionary search for “aether” 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.

81 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
aether	9	42	1367	(None)
aethers	10	36	1494	1	aethers
anther	9	37	1506	1	anther
ether	8	45	1877	1	_ether
nether	9	40	1416	1	nether
tether	9	37	1610	1	tether
wether	12	33	1539	1	wether
abetter	9	5	832	2	abetter
aerier	6	48	2315	2	aerier
aetheric	13	4	1016	2	aetheric
after	8	57	1979	2	aft_er
alter	5	48	2850	2	alt_er
althea	9	3	819	2	althea
another	10	28	915	2	another
anthem	11	34	1034	2	anthem
anthers	10	37	1520	2	anthers
antler	6	46	1555	2	antler
apter	7	61	2020	2	apt_er
archer	11	50	1624	2	archer
artier	6	34	1973	2	artier
aster	5	54	3489	2	ast_er
author	9	3	976	2	author
aweather	14	3	426	2	aweather
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
eater	5	46	3984	2	eat_er
either	9	45	1742	2	either
etcher	11	39	1294	2	_etcher
ethers	9	45	1841	2	_ethers
farther	13	4	834	2	farther
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
panther	12	6	1144	2	panther
peter	7	44	2759	2	pet_er
petter	8	39	2477	2	petter
pother	11	38	1885	2	pother
rather	9	43	1973	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
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 4 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.123	1452772.4
2	DLD Change Limit	82551	81	2.940	28078.6
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	3.093	57772.7