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

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

100 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
mounts	8	41	1507	(None)
amounts	9	3	704	1	amounts
counts	8	46	1827	1	counts
founts	9	43	1338	1	founts
moults	8	47	1370	1	moults
mounds	9	39	1513	1	mounds
mount	7	41	2806	1	mount_
amount	8	4	1448	2	amount_
aunts	5	52	2763	2	_aunts
blunts	8	45	1289	2	blunts
bounds	9	44	1580	2	bounds
bounty	11	34	1107	2	bounty
bouts	7	51	3131	2	bou_ts
brunts	8	52	1545	2	brunts
bunts	7	57	2980	2	_bunts
count	7	49	3205	2	count_
county	11	43	1332	2	county
courts	8	42	1616	2	courts
cunts	7	61	2512	2	_cunts
daunts	7	50	1408	2	daunts
demounts	11	3	547	2	demounts
donuts	7	4	1058	2	donuts
doubts	9	6	873	2	doubts
dunts	6	58	2841	2	_dunts
fonts	8	61	2475	2	fo_nts
founds	10	48	1419	2	founds
fount	8	47	2703	2	fount_
gouts	6	48	2617	2	gou_ts
grunts	7	55	1185	2	grunts
haunts	9	56	1439	2	haunts
hounds	10	44	1313	2	hounds
hunts	8	68	2617	2	_hunts
jaunts	13	75	1188	2	jaunts
joints	13	38	1145	2	joints
jousts	13	50	1127	2	jousts
louts	5	63	3027	2	lou_ts
lunts	5	58	2690	2	_lunts
maunds	9	51	965	2	maunds
mauts	7	59	2719	2	mau_ts
mints	7	68	3404	2	m_ints
moans	7	46	2436	2	moan_s
moats	7	58	2764	2	mo_ats
molts	7	60	3209	2	mo_lts
moments	11	31	1312	2	moments
monas	7	47	3215	2	mo_nas
monks	11	61	2339	2	mo_nks
monos	7	59	3086	2	mo_nos
mons	6	81	5225	2	mo_n_s
monte	7	58	2977	2	mo_nte
montes	8	42	2693	2	mo_ntes
month	10	48	1842	2	mo_nth
months	11	38	1293	2	mo_nths
moons	7	53	3100	2	moon_s
moots	7	58	3166	2	mo_ots
morns	7	55	2744	2	morn_s
morts	7	55	3356	2	mo_rts
mosts	7	60	2854	2	mo_sts
motets	8	42	1619	2	motets
mots	6	68	5316	2	mo__ts
motts	7	65	2700	2	mo_tts
moues	7	57	3284	2	mou_es
moulds	9	49	1099	2	moulds
moult	7	47	2872	2	moult_
mound	8	39	1831	2	moun_d
mounted	10	36	1153	2	mounted
mounter	9	37	1317	2	mounter
mounters	10	37	1249	2	mounters
mourns	8	41	1101	2	mourns
mouses	8	55	3142	2	mouses
mouth	10	54	2029	2	mou_th
mouths	11	52	1453	2	mouths
munis	7	50	2200	2	m_unis
muns	6	55	3591	2	m_un_s
muons	7	58	1617	2	muon_s
musts	7	55	2744	2	m_usts
muts	6	48	3998	2	m_u_ts
mutts	7	51	2025	2	m_utts
nouns	5	67	1731	2	noun_s
ousts	5	52	2570	2	_ousts
outs	4	57	4696	2	_ou_ts
points	8	56	1853	2	points
poults	8	46	1348	2	poults
pounds	9	37	1438	2	pounds
pouts	7	55	3032	2	pou_ts
punts	7	58	2800	2	_punts
remounts	10	3	637	2	remounts
rounds	7	36	1561	2	rounds
rousts	6	170	1672	2	rousts
routs	5	71	3341	2	rou_ts
runts	5	59	2763	2	_runts
shunts	9	57	1201	2	shunts
sounds	7	46	1618	2	sounds
stunts	6	56	1525	2	stunts
taunts	6	57	1566	2	taunts
touts	5	48	3039	2	tou_ts
vaunts	9	52	1262	2	vaunts
wonts	8	76	2154	2	wo_nts
wounds	10	38	1163	2	wounds
youngs	10	3	538	2	youngs
zounds	16	43	1017	2	zounds

Search took 6 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.220	812231.8
2	DLD Change Limit	82551	100	5.330	15488.0
3	Display Results	100	100	0.046	2173.9
	(SQL Overall)	178691	100	5.596	31931.9