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

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

131 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
afters	9	47	1707	(None)
after	8	57	1979	1	after_
alters	6	49	2422	1	alters
asters	6	56	3160	1	asters
hafters	13	46	1433	1	hafters
rafters	10	37	1563	1	rafters
wafters	13	41	1281	1	wafters
abaters	9	51	1520	2	abaters
actors	8	10	1677	2	actors
adders	8	43	1570	2	adders
aethers	10	36	1494	2	aethers
afars	8	57	1651	2	af_ars
agers	6	50	2785	2	a_gers
aggers	8	58	1779	2	aggers
aiders	7	45	2463	2	aiders
aimers	8	46	2191	2	aimers
airers	6	49	2231	2	airers
aivers	9	48	2232	2	aivers
alders	7	42	1842	2	alders
altars	6	45	1815	2	altars
alter	5	48	2850	2	alter_
ambers	10	45	1958	2	ambers
ameers	8	40	1557	2	ameers
angers	7	52	2254	2	angers
antes	5	63	3432	2	ante_s
anthers	10	37	1520	2	anthers
antlers	7	40	1474	2	antlers
antres	6	50	2100	2	antres
apers	7	66	2913	2	a_pers
apter	7	61	2020	2	apter_
armers	8	55	2027	2	armers
artels	6	62	1623	2	artels
artery	9	9	1145	2	artery
askers	10	59	1540	2	askers
aspers	8	62	2031	2	aspers
aster	5	54	3489	2	aster_
astern	6	48	1581	2	astern
ates	4	50	4792	2	a_te_s
attars	6	45	1531	2	attars
augers	7	38	1870	2	augers
auteurs	7	13	750	2	auteurs
avers	8	51	2731	2	a_vers
baiters	9	46	1930	2	baiters
banters	9	46	2311	2	banters
barters	9	42	2303	2	barters
basters	9	49	3030	2	basters
batters	9	46	2601	2	batters
biters	8	39	2524	2	biters
canters	9	48	2773	2	canters
carters	9	53	2725	2	carters
casters	9	47	2990	2	casters
caters	8	53	3650	2	caters
citers	8	50	2298	2	citers
crafters	13	41	995	2	crafters
dafter	10	48	1334	2	dafter_
darters	8	40	1760	2	darters
daters	7	48	2737	2	daters
deters	7	47	2468	2	deters
doters	7	44	2391	2	doters
drafters	12	33	853	2	drafters
easters	7	51	2568	2	easters
eaters	6	55	3595	2	eaters
enters	6	44	2564	2	enters
esters	6	46	2773	2	esters
facers	11	55	1944	2	facers
faders	10	51	1746	2	faders
fakers	13	42	1953	2	fakers
falters	10	39	1647	2	falters
farers	9	59	2405	2	farers
fates	8	51	3923	2	fate_s
fathers	13	39	1650	2	fathers
gaffers	14	42	871	2	gaffers
gaiters	8	35	1654	2	gaiters
garters	8	42	1823	2	garters
gasters	8	56	2429	2	gasters
gaters	7	47	2864	2	gaters
grafters	12	40	919	2	grafters
hafter	12	48	1588	2	hafter_
halters	10	46	1980	2	halters
haters	9	49	3040	2	haters
hatters	10	42	2152	2	hatters
hefters	13	43	1200	2	hefters
inters	6	43	2805	2	inters
kiters	10	52	1859	2	kiters
lasters	7	56	2769	2	lasters
lifters	10	43	1378	2	lifters
liters	6	54	2988	2	liters
lofters	10	39	1290	2	lofters
maftirs	12	3	604	2	maftirs
masters	9	46	2892	2	masters
maters	8	50	3239	2	maters
matters	9	44	2175	2	matters
meters	8	56	2583	2	meters
miters	8	43	2878	2	miters
natters	7	37	1806	2	natters
niters	6	46	2421	2	niters
noters	6	40	2100	2	noters
oaters	6	50	2979	2	oaters
offers	12	34	996	2	offers
ofter	8	41	1687	2	ofter_
otters	6	40	2151	2	otters
outers	6	42	3017	2	outers
oxters	13	48	1327	2	oxters
palters	9	40	2168	2	palters
pasters	9	45	3173	2	pasters
paters	8	49	3583	2	paters
patters	9	48	2519	2	patters
peters	8	66	2459	2	peters
rafter	9	45	1758	2	rafter_
ranters	7	33	2364	2	ranters
rasters	7	46	2902	2	rasters
raters	6	39	3658	2	raters
ratters	7	44	2247	2	ratters
salters	7	36	2225	2	salters
sifters	10	37	1479	2	sifters
tasters	7	42	2564	2	tasters
taters	6	49	3220	2	taters
tatters	7	45	2048	2	tatters
titers	6	45	2641	2	titers
toters	6	50	2636	2	toters
tufters	10	29	835	2	tufters
utters	6	38	1712	2	utters
voters	9	50	1744	2	voters
wafers	12	43	1614	2	waf_ers
wafter	12	41	1461	2	wafter_
waiters	10	42	1862	2	waiters
wanters	10	44	2009	2	wanters
wasters	10	40	2659	2	wasters
waters	9	50	3063	2	waters
yatters	10	39	1462	2	yatters
zaffers	22	38	677	2	zaffers

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.343	520965.0
2	DLD Change Limit	82551	131	2.706	30506.7
3	Display Results	131	131	0.046	2847.8
	(SQL Overall)	178691	131	3.095	57735.4