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

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

65 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
aethers	10	36	1494	(None)
aether	9	42	1367	1	aether_
anthers	10	37	1520	1	anthers
ethers	9	45	1841	1	_ethers
tethers	10	38	1531	1	tethers
wethers	13	52	1469	1	wethers
abetters	10	5	717	2	abetters
aetheric	13	4	1016	2	aetheric
afters	9	47	1707	2	aft_ers
alters	6	49	2422	2	alt_ers
altheas	10	3	822	2	altheas
anthems	12	30	942	2	anthems
anther	9	37	1506	2	anther_
antlers	7	40	1474	2	antlers
archers	12	44	1457	2	archers
asters	6	56	3160	2	ast_ers
authors	10	3	1185	2	authors
bathers	12	47	2036	2	bathers
bethels	12	3	853	2	bethels
betters	9	44	2209	2	betters
blethers	13	42	961	2	blethers
bothers	12	43	1775	2	bothers
cithers	12	43	1577	2	cithers
deters	7	47	2468	2	det_ers
diethers	12	5	745	2	diethers
dithers	11	40	1615	2	dithers
eaters	6	55	3595	2	eat_ers
etchers	12	34	1129	2	_etchers
ether	8	45	1877	2	_ether_
fathers	13	39	1650	2	fathers
feathers	14	35	1324	2	feathers
fetchers	16	32	886	2	fetchers
fetters	10	35	1790	2	fetters
gathers	11	43	1507	2	gathers
getters	8	42	1610	2	getters
heathers	14	39	1473	2	heathers
lathers	10	43	2188	2	lathers
leathers	11	42	1508	2	leathers
lechers	12	33	1396	2	lechers
lethes	9	48	1808	2	lethe_s
letters	7	38	1985	2	letters
meters	8	56	2583	2	met_ers
metiers	9	33	1284	2	metiers
mithers	12	35	1673	2	mithers
mothers	12	37	1762	2	mothers
nether	9	40	1416	2	nether_
netters	7	36	1858	2	netters
others	9	39	1800	2	_others
panthers	13	5	1078	2	panthers
peters	8	66	2459	2	pet_ers
petters	9	37	2236	2	petters
pothers	12	38	1862	2	pothers
setters	7	38	2206	2	setters
teethers	11	32	871	2	teethers
tether	9	37	1610	2	tether_
tetters	7	43	2047	2	tetters
tithers	10	42	1673	2	tithers
vetoers	10	35	947	2	vetoers
vetters	10	40	1632	2	vetters
weathers	14	34	1283	2	weathers
wether	12	33	1539	2	wether_
wetters	10	38	1775	2	wetters
withers	13	44	1775	2	withers
wuthers	13	37	1152	2	wuthers
zithers	19	39	1197	2	zithers

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	107671	0.360	496363.9
2	DLD Change Limit	107671	65	3.343	32207.9
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	3.719	48048.1