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

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

112 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
numb	8	55	2061	(None)
dumb	9	71	2410	1	dumb
nub	5	64	3914	1	nu_b
numbs	9	49	1309	1	numbs
benumb	12	3	577	2	benumb
bomb	10	69	2742	2	bomb
bub	7	63	4397	2	bu_b
bulb	8	56	2669	2	bulb
bum	7	53	4269	2	bum_
bumf	11	61	2650	2	bumf
bump	10	62	2824	2	bump
bums	8	59	3459	2	bums
burb	8	53	3467	2	burb
comb	10	66	3211	2	comb
crumb	11	43	1359	2	crumb
cub	7	69	4094	2	cu_b
cum	7	64	4016	2	cum_
curb	8	67	3222	2	curb
dub	6	66	4220	2	du_b
duma	7	55	2445	2	duma
dumbo	10	56	1406	2	dumbo
dumbs	10	59	1575	2	dumbs
dump	9	59	2709	2	dump
fub	8	63	3739	2	fu_b
fume	9	67	2763	2	fume
fumy	12	71	1858	2	fumy
gamb	9	63	3184	2	gamb
gum	6	74	3953	2	gum_
gumbo	10	44	1358	2	gumbo
gums	7	50	3094	2	gums
hub	8	64	3748	2	hu_b
hum	8	55	4293	2	hum_
hump	11	62	2872	2	hump
hums	9	68	3142	2	hums
iamb	8	66	2372	2	iamb
jamb	15	55	2385	2	jamb
jumbo	16	43	1107	2	jumbo
jump	15	66	2172	2	jump
lamb	8	68	3214	2	lamb
limb	8	54	2937	2	limb
lum	5	55	4293	2	lum_
luma	6	55	2752	2	luma
lump	8	65	3170	2	lump
lums	6	57	3424	2	lums
mum	7	66	4361	2	mum_
mumm	7	57	1886	2	mumm
mump	10	54	2572	2	mump
mums	8	57	3277	2	mums
mumu	8	60	2206	2	mumu
nab	5	69	5492	2	n_ab
nam	5	59	5339	2	nam_
name	6	56	3741	2	name
neb	5	72	3862	2	n_eb
nema	6	55	2252	2	nema
neum	6	67	2308	2	neum_
neume	7	44	1440	2	neume
neums	7	54	1425	2	neums
nib	5	67	4518	2	n_ib
nim	5	71	4295	2	nim_
nimbi	9	49	1029	2	nimbi
nims	6	62	2688	2	nims
nob	5	89	5442	2	n_ob
nom	5	104	5064	2	nom_
noma	6	75	2946	2	noma
nome	6	60	3842	2	nome
noms	6	56	3640	2	noms
nu	2	63	3195	2	nu__
nubby	12	50	1102	2	nubby
nubs	6	59	2714	2	nubs
nude	5	66	2627	2	nude
nuke	8	59	2075	2	nuke
null	4	51	2531	2	null
numbat	10	3	1208	2	numbat
numbed	11	41	1144	2	numbed
number	10	39	1322	2	number
numbly	13	44	1066	2	numbly
numen	7	42	1679	2	numen
nun	3	55	3774	2	nu_n
nuns	4	52	2823	2	nuns
nurd	5	62	2434	2	nurd
nurl	4	53	2724	2	nurl
nus	3	79	3939	2	nu_s
nut	3	66	5196	2	nu_t
nuts	4	50	3267	2	nuts
plumb	11	45	1407	2	plumb
pub	7	60	3769	2	pu_b
puma	8	54	2412	2	puma
pump	10	57	2685	2	pump
rhumb	12	43	865	2	rhumb
rub	5	63	4282	2	ru_b
rum	5	66	4464	2	rum_
rumba	9	36	1251	2	rumba
rump	8	67	2908	2	rump
rums	6	48	3347	2	rums
snub	6	53	2076	2	snu_b
sub	5	54	4555	2	su_b
sum	5	63	4601	2	sum_
sumo	6	73	2631	2	sumo
sump	8	63	3153	2	sump
sums	6	58	3758	2	sums
thumb	12	45	1128	2	thumb
tomb	8	90	2965	2	tomb
tub	5	56	4003	2	tu_b
tump	8	59	2703	2	tump
um	4	73	3883	2	_um_
umbo	8	55	1665	2	_umbo
umm	7	119	2126	2	_umm
ump	7	61	3044	2	_ump
urb	5	57	3110	2	_urb
vum	8	54	2865	2	vum_
womb	11	70	2223	2	womb
yum	8	61	3282	2	yum_

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	29872	0.093	1921408.6
2	DLD Change Limit	29872	112	0.953	31345.2
3	Display Results	112	112	0.030	3733.3
	(SQL Overall)	178691	112	1.076	166069.7