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

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

104 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
bumfs	12	54	1405	(None)
buffs	13	55	1951	1	buffs
bumf	11	61	2651	1	bumf_
bumps	11	59	2114	1	bumps
bums	8	59	3459	1	bum_s
baffs	13	47	1805	2	baffs
bams	8	70	4445	2	bam_s
barfs	10	48	2600	2	barfs
beefs	10	56	1856	2	beefs
bemas	9	64	2428	2	bemas
biffs	13	48	1441	2	biffs
bimas	9	55	2174	2	bimas
bluffs	14	38	837	2	bluffs
blumes	10	59	1779	2	blumes
boffs	13	49	1550	2	boffs
bombs	11	58	1882	2	bombs
brumes	10	64	1707	2	brumes
bubs	8	62	3550	2	bu_bs
bubus	9	51	1545	2	bubus
bucks	13	48	2429	2	bucks
buds	7	52	3517	2	bu_ds
buff	12	52	2986	2	bu_ff
buffi	13	61	1220	2	buffi
buffo	13	51	1218	2	buffo
buffos	14	44	785	2	buffos
buffy	16	50	1337	2	buffy
bugs	7	60	3591	2	bu_gs
buhls	10	51	1180	2	buhls
buhrs	10	48	1124	2	buhrs
bulbs	9	60	1693	2	bulbs
bulks	11	59	2061	2	bulks
bulls	7	56	2957	2	bulls
bum	7	53	4269	2	bum__
bump	10	62	2824	2	bum_p
bumph	14	49	1198	2	bumph
bumphs	15	46	710	2	bumphs
bumpy	14	47	1505	2	bumpy
bunas	7	51	2657	2	bunas
bunds	8	55	2354	2	bunds
bungs	8	53	2386	2	bungs
bunks	11	51	2508	2	bunks
bunns	7	47	1829	2	bunns
buns	6	62	4372	2	bu_ns
bunts	7	57	2980	2	bunts
buoys	10	48	1063	2	buoys
buras	7	47	3630	2	buras
burbs	9	54	2349	2	burbs
burds	8	46	2606	2	burds
burgs	8	49	2409	2	burgs
burls	7	42	2885	2	burls
burns	7	49	2678	2	burns
burps	9	42	2017	2	burps
burrs	7	49	2565	2	burrs
burs	6	58	4742	2	bu_rs
bus	5	69	5097	2	bu__s
buses	7	59	3601	2	buses
busks	11	55	2137	2	busks
buss	6	51	3491	2	bu_ss
busts	7	52	2769	2	busts
butes	7	145	3587	2	butes
buts	6	72	4769	2	bu_ts
butts	7	58	2425	2	butts
buys	9	57	2679	2	bu_ys
cuffs	13	50	1749	2	cuffs
cuifs	10	48	1469	2	cuifs
curfs	10	51	2214	2	curfs
duffs	12	52	1662	2	duffs
dumas	8	54	2043	2	dumas
dumbs	10	59	1575	2	dumbs
dumps	10	52	2010	2	dumps
fumes	10	52	2470	2	fumes
guffs	12	44	1482	2	guffs
gulfs	9	49	1530	2	gulfs
gums	7	50	3094	2	gum_s
huffs	14	45	1474	2	huffs
humps	12	63	2280	2	humps
hums	9	68	3142	2	hum_s
humus	10	62	1507	2	humus
jumps	16	51	1649	2	jumps
kumys	14	3	593	2	kumys
luffs	11	45	1628	2	luffs
lumas	7	56	2291	2	lumas
lumps	9	56	2498	2	lumps
lums	6	57	3424	2	lum_s
muffs	13	41	1421	2	muffs
mumms	8	55	1315	2	mumms
mumps	11	56	1910	2	mumps
mums	8	57	3277	2	mum_s
mumus	9	55	1728	2	mumus
numbs	9	49	1309	2	numbs
puffs	13	41	1493	2	puffs
pumas	9	51	2156	2	pumas
pumps	11	55	2060	2	pumps
ruffs	11	45	1674	2	ruffs
rumps	9	59	2229	2	rumps
rums	6	48	3347	2	rum_s
sumos	7	57	2009	2	sumos
sumps	9	50	2343	2	sumps
sums	6	58	3758	2	sum_s
surfs	8	50	2254	2	surfs
tuffs	11	51	1826	2	tuffs
tumps	9	54	2079	2	tumps
turfs	8	46	2044	2	turfs
umps	8	57	2194	2	_umps

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	53800	0.373	479064.3
2	DLD Change Limit	53800	104	2.766	19450.5
3	Display Results	104	104	0.016	6500.0
	(SQL Overall)	178691	104	3.155	56637.4