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

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

72 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
anther	9	37	1506	(None)
aether	9	42	1367	1	aether
another	10	28	915	1	another
anthem	11	34	1034	1	anthem
anthers	10	37	1520	1	anthers
antler	6	46	1555	1	antler
panther	12	6	1144	1	panther
aethers	10	36	1494	2	aethers
after	8	57	1979	2	aft_er
alter	5	48	2850	2	alt_er
althea	9	3	821	2	althea
anchor	11	39	1197	2	anchor
anger	6	62	2587	2	an_ger
angler	7	40	1786	2	angler
answer	9	3	689	2	answer
antae	5	68	2829	2	antae_
antbear	9	3	506	2	antbear
ante	4	65	3890	2	ant_e_
anted	6	63	2824	2	ant_ed
anteed	7	56	1611	2	anteed
antes	5	63	3432	2	ant_es
anthems	12	30	942	2	anthems
antheral	11	4	939	2	antheral
antherid	12	6	1109	2	antherid
antiar	6	3	1717	2	antiar
antihero	11	4	766	2	antihero
antlers	7	40	1474	2	antlers
antre	5	52	2452	2	antre_
antres	6	50	2100	2	antres
antsier	7	4	1077	2	antsier
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
banter	8	48	2533	2	bant_er
bather	11	53	2251	2	bather
bother	11	52	1806	2	bother
canter	8	52	3011	2	cant_er
cither	11	46	1668	2	cither
dither	10	44	1768	2	dither
either	9	45	1742	2	either
enter	5	47	2638	2	ent_er
ether	8	45	1877	2	_ether
farther	13	4	834	2	farther
father	12	51	1671	2	father
gather	10	41	1586	2	gather
hither	12	44	1725	2	hither
incher	11	41	1403	2	incher
inter	5	50	2849	2	int_er
ither	8	46	1760	2	_ither
lather	9	51	2436	2	lather
lither	9	45	2095	2	lither
mither	11	42	1856	2	mither
mother	11	37	1864	2	mother
natter	6	44	2074	2	natter
nether	9	40	1416	2	nether
nother	9	38	1596	2	nother
other	8	42	1910	2	_other
panthers	13	5	1078	2	panthers
pother	11	38	1885	2	pother
rancher	12	30	1363	2	rancher
ranter	6	38	2682	2	rant_er
rather	9	43	1974	2	rather
tether	9	37	1610	2	tether
tither	9	49	2028	2	tither
tother	9	41	1714	2	tother
wanter	9	44	2305	2	want_er
wether	12	33	1539	2	wether
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.343	520965.0
2	DLD Change Limit	82551	72	2.376	34743.7
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	2.749	65002.2