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

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

107 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
muffs	13	41	1421	(None)
buffs	13	55	1951	1	buffs
cuffs	13	50	1749	1	cuffs
duffs	12	52	1662	1	duffs
guffs	12	44	1482	1	guffs
huffs	14	45	1474	1	huffs
luffs	11	45	1628	1	luffs
miffs	13	45	1288	1	miffs
muff	12	47	2386	1	muff_
puffs	13	41	1493	1	puffs
ruffs	11	45	1674	1	ruffs
tuffs	11	51	1826	1	tuffs
baffs	13	47	1805	2	baffs
biffs	13	48	1441	2	biffs
bluffs	14	38	837	2	bluffs
boffs	13	49	1550	2	boffs
buff	12	52	2986	2	buff_
buffi	13	61	1220	2	buffi
buffo	13	51	1218	2	buffo
buffos	14	44	785	2	buffos
buffy	16	50	1337	2	buffy
bumfs	12	54	1405	2	bumfs
caffs	13	54	1737	2	caffs
chuffs	17	42	778	2	chuffs
coffs	13	49	1630	2	coffs
cuff	12	53	2799	2	cuff_
cuifs	10	48	1469	2	cuifs
curfs	10	51	2214	2	curfs
daffs	12	51	1642	2	daffs
diffs	12	63	1548	2	diffs
doffs	12	56	1433	2	doffs
duff	11	43	2664	2	duff_
dufus	9	40	1081	2	dufus
effs	10	51	1403	2	_effs
fluffs	11	34	778	2	fluffs
gaffs	12	49	1465	2	gaffs
gruffs	13	33	745	2	gruffs
guff	11	46	2493	2	guff_
gulfs	9	49	1530	2	gulfs
huff	13	56	2384	2	huff_
huffy	17	48	1023	2	huffy
jiffs	18	57	1031	2	jiffs
kufis	12	4	925	2	kufis
luff	10	44	2670	2	luff_
luffa	11	40	902	2	luffa
luffas	12	33	748	2	luffas
miff	12	56	2506	2	miff_
miffy	16	39	1020	2	miffy
mucks	13	46	2264	2	mucks
mucus	9	40	1574	2	mucus
muds	7	55	3065	2	mu_ds
muffed	15	42	1059	2	muffed
muffin	14	29	887	2	muffin
muffins	15	30	834	2	muffins
muffle	14	33	964	2	muffle
muffles	15	39	1045	2	muffles
mufti	10	6	1054	2	mufti
muftis	11	5	805	2	muftis
muggs	9	49	1232	2	muggs
mugs	7	62	3204	2	mu_gs
mules	7	50	3429	2	mules
mulls	7	51	2415	2	mulls
mumms	8	55	1315	2	mumms
mumps	11	56	1910	2	mumps
mums	8	57	3277	2	mu_ms
mumus	9	55	1728	2	mumus
munis	7	50	2200	2	munis
muns	6	55	3592	2	mu_ns
muons	7	58	1617	2	muons
muras	7	53	2958	2	muras
mures	7	59	3722	2	mures
murks	11	48	2173	2	murks
murrs	7	55	2130	2	murrs
mus	5	59	4675	2	mu__s
muses	7	51	3430	2	muses
musks	11	61	1964	2	musks
muss	6	49	3376	2	mu_ss
musts	7	55	2744	2	musts
mutes	7	50	3378	2	mutes
muts	6	48	3998	2	mu_ts
mutts	7	51	2025	2	mutts
naffs	11	62	1396	2	naffs
offs	10	71	1701	2	_offs
pouffs	14	41	812	2	pouffs
puff	12	55	2543	2	puff_
puffy	16	44	1075	2	puffy
quaffs	21	12	569	2	quaffs
quiffs	21	13	543	2	quiffs
raffs	11	50	1752	2	raffs
riffs	11	51	1461	2	riffs
ruff	10	51	2765	2	ruff_
ruffe	11	47	1381	2	ruffe
ruffes	12	41	1242	2	ruffes
scuffs	14	41	905	2	scuffs
sluffs	12	34	958	2	sluffs
snuffs	12	35	853	2	snuffs
stuffs	12	38	1022	2	stuffs
surfs	8	50	2254	2	surfs
teffs	11	51	1173	2	teffs
tiffs	11	44	1488	2	tiffs
toffs	11	60	1672	2	toffs
tufas	8	53	1438	2	tufas
tuff	10	45	2852	2	tuff_
tufts	8	57	1327	2	tufts
turfs	8	46	2044	2	turfs
waffs	14	63	1547	2	waffs
yaffs	14	53	1112	2	yaffs

Search took 2 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	53800	0.310	576422.6
2	DLD Change Limit	53800	107	1.470	36598.6
3	Display Results	107	107	0.030	3566.7
	(SQL Overall)	178691	107	1.810	98724.3