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

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

259 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
duh	7	79	3038	(None)
dah	7	81	4898	1	dah
dub	6	66	4220	1	dub
dud	5	67	3759	1	dud
due	4	52	4986	1	due
dug	5	81	3869	1	dug
dui	4	64	3338	1	dui
dun	4	65	4558	1	dun
duo	4	85	3614	1	duo
dup	6	76	3788	1	dup
huh	9	64	3201	1	huh
uh	5	74	2985	1	_uh
aah	6	162	5296	2	aah
ah	5	138	6879	2	_ah
ash	6	79	4460	2	ash
auk	7	62	3414	2	auk
bah	8	77	5535	2	bah
bub	7	63	4397	2	bub
bud	6	70	4127	2	bud
bug	6	53	4074	2	bug
buhl	9	55	1822	2	buhl
buhr	9	53	1538	2	buhr
bum	7	53	4269	2	bum
bun	5	63	4814	2	bun
bur	5	57	4469	2	bur
bus	5	69	5097	2	bus
bush	9	66	3071	2	bush
but	5	59	6302	2	but
buy	8	64	3654	2	buy
cub	7	69	4094	2	cub
cud	6	79	3745	2	cud
cue	5	75	4418	2	cue
cum	7	64	4016	2	cum
cup	7	67	3824	2	cup
cur	5	68	4198	2	cur
cut	5	79	5766	2	cut
dab	6	74	5556	2	dab
dad	5	84	5616	2	dad
dag	5	77	5300	2	dag
dahl	8	70	1922	2	dahl
dahs	8	82	3181	2	dahs
dak	8	63	4069	2	dak
dal	4	75	5495	2	dal
dam	6	74	5704	2	dam
dan	4	68	5966	2	dan
dap	6	66	5245	2	dap
dash	8	70	3163	2	dash
daub	7	74	2344	2	daub
daut	5	64	4356	2	daut
daw	7	71	4836	2	daw
day	7	62	5411	2	day
de	3	70	4954	2	d_e
deb	6	63	4269	2	deb
dee	4	76	6582	2	dee
def	7	65	4672	2	def
del	4	67	5275	2	del
den	4	75	5434	2	den
dev	7	60	3377	2	dev
dew	7	71	3992	2	dew
dex	11	69	3688	2	dex
dey	7	72	4337	2	dey
dib	6	57	4693	2	dib
did	5	68	5051	2	did
die	4	67	5965	2	die
dif	7	68	4689	2	dif
dig	5	75	4447	2	dig
dim	6	81	4649	2	dim
din	4	64	5946	2	din
dip	6	78	4898	2	dip
dis	4	64	5989	2	dis
dish	8	63	2833	2	dish
dit	4	70	7133	2	dit
do	3	101	5525	2	d_o
doc	6	68	4151	2	doc
doe	4	73	6195	2	doe
dog	5	74	4975	2	dog
dol	4	71	5065	2	dol
dom	6	97	5244	2	dom
don	4	67	5765	2	don
dor	4	72	5392	2	dor
dos	4	80	6231	2	dos
dot	4	75	7318	2	dot
doth	8	62	2571	2	doth
dough	10	52	1738	2	dough
doum	7	62	2667	2	doum
dour	5	63	3043	2	dour
doux	12	58	1798	2	doux
dow	7	67	4997	2	dow
drub	7	59	2013	2	drub
drug	6	57	1813	2	drug
drum	7	65	2159	2	drum
dry	7	65	2603	2	dry
duad	6	65	2141	2	duad
dual	5	59	2817	2	dual
dubs	7	84	3219	2	dubs
duce	7	69	3350	2	duce
duchy	14	43	1087	2	duchy
duci	7	64	2262	2	duci
duck	11	59	2917	2	duck
duct	7	57	3546	2	duct
dude	6	56	2966	2	dude
duds	6	55	3014	2	duds
duel	5	67	2970	2	duel
dues	5	60	4550	2	dues
duet	5	64	4626	2	duet
duff	11	43	2664	2	duff
dugs	6	148	3228	2	dugs
duit	5	62	4158	2	duit
duke	9	56	2810	2	duke
dull	5	64	3044	2	dull
duly	8	53	2303	2	duly
duma	7	55	2445	2	duma
dumb	9	71	2410	2	dumb
dump	9	59	2709	2	dump
dunch	11	53	1626	2	dunch
dune	5	61	3758	2	dune
dung	6	63	2843	2	dung
dunk	9	62	2857	2	dunk
duns	5	51	4043	2	duns
dunt	5	57	4687	2	dunt
duos	5	67	2813	2	duos
dupe	7	66	3060	2	dupe
dups	7	59	2951	2	dups
dura	5	52	3211	2	dura
dure	5	63	4181	2	dure
durn	5	61	2762	2	durn
duro	5	62	2802	2	duro
durr	5	56	2435	2	durr
dusk	9	57	2415	2	dusk
dust	5	71	4253	2	dust
dutch	11	47	1382	2	dutch
duty	8	53	2145	2	duty
dye	7	53	3484	2	dye
edh	7	69	2156	2	edh
eh	5	83	3996	2	_eh
eth	6	66	3098	2	eth
feh	9	61	3609	2	feh
foh	9	81	3589	2	foh
fub	8	63	3739	2	fub
fud	7	63	3515	2	fud
fug	7	62	3451	2	fug
fun	6	68	4114	2	fun
fur	6	66	3732	2	fur
gul	4	58	3279	2	gul
gum	6	74	3953	2	gum
gun	4	72	4080	2	gun
gush	8	54	2400	2	gush
gut	4	67	5385	2	gut
guv	7	45	2317	2	guv
guy	7	57	2894	2	guy
hah	9	106	5522	2	hah
heh	9	60	3962	2	heh
hub	8	64	3748	2	hub
hue	6	66	4230	2	hue
hug	7	60	3736	2	hug
hum	8	55	4293	2	hum
hun	6	58	4471	2	hun
hunh	10	63	2373	2	hunh
hup	8	64	3781	2	hup
hush	10	52	2411	2	hush
hut	6	64	5729	2	hut
ich	8	62	2774	2	ich
jug	11	55	2954	2	jug
jun	10	59	3206	2	jun
jus	10	69	3022	2	jus
jut	10	59	4401	2	jut
kue	7	66	3186	2	kue
lug	4	61	3806	2	lug
lum	5	55	4293	2	lum
lush	7	53	2769	2	lush
luv	6	71	2577	2	luv
lux	10	65	2877	2	lux
mu	4	67	3748	2	mu_
much	11	52	2403	2	much
mud	6	73	3686	2	mud
mug	6	58	3769	2	mug
mum	7	66	4361	2	mum
mun	5	61	4385	2	mun
mus	5	59	4675	2	mus
mush	9	49	2912	2	mush
mut	5	83	5718	2	mut
nah	6	98	4700	2	nah
noh	6	66	4064	2	noh
nth	6	63	2059	2	nth
nu	2	63	3195	2	nu_
nub	5	64	3914	2	nub
nun	3	55	3774	2	nun
nus	3	79	3939	2	nus
nut	3	66	5196	2	nut
odah	8	70	1893	2	odah
oh	5	74	4700	2	_oh
ooh	6	76	3709	2	ooh
ouch	9	57	2463	2	ouch
oud	4	74	3907	2	oud
ouph	9	56	1837	2	ouph
our	3	60	4289	2	our
out	3	80	7215	2	out
pah	8	88	5359	2	pah
peh	8	67	4096	2	peh
poh	8	67	4053	2	poh
pub	7	60	3769	2	pub
pud	6	58	3665	2	pud
pug	6	53	3718	2	pug
pugh	10	66	1923	2	pugh
pul	5	61	3806	2	pul
pun	5	88	4651	2	pun
pup	7	63	3988	2	pup
pur	5	68	4055	2	pur
pus	5	55	4784	2	pus
push	9	55	2662	2	push
put	5	57	5907	2	put
qua	12	48	2197	2	qua
rah	6	80	5240	2	rah
rub	5	63	4282	2	rub
rue	3	55	4926	2	rue
rug	4	60	3915	2	rug
rum	5	66	4464	2	rum
run	3	62	4498	2	run
rush	7	66	2818	2	rush
rut	3	55	6052	2	rut
ruth	7	68	2599	2	ruth
sh	5	68	2852	2	_sh
shh	9	71	2107	2	shh
sub	5	54	4555	2	sub
such	9	64	2481	2	such
sue	3	56	5146	2	sue
sugh	8	64	2344	2	sugh
suk	7	56	3297	2	suk
sum	5	63	4601	2	sum
sun	3	71	4903	2	sun
sup	5	70	4194	2	sup
suq	12	62	2899	2	suq
tub	5	56	4003	2	tub
tug	4	59	3740	2	tug
tui	3	70	3402	2	tui
tun	3	58	4519	2	tun
tup	5	60	3754	2	tup
tush	7	45	2390	2	tush
tut	3	67	5809	2	tut
tux	10	54	2657	2	tux
udo	4	90	2730	2	udo
ugh	7	65	2068	2	ugh
um	4	73	3883	2	_um
un	2	83	4113	2	_un
up	4	78	3282	2	_up
us	2	69	3743	2	_us
ut	2	86	4703	2	_ut
vug	7	61	2741	2	vug
vugh	11	71	1572	2	vugh
vum	8	54	2865	2	vum
wud	7	62	2715	2	wud
xu	9	60	1883	2	xu_
yah	9	90	4635	2	yah
yeh	9	71	3577	2	yeh
yuch	12	58	1853	2	yuch
yuk	10	67	2560	2	yuk
yum	8	61	3282	2	yum
yup	8	60	3170	2	yup
zuz	11	106	2203	2	zuz

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	14084	0.186	960704.3
2	DLD Change Limit	14084	259	0.970	14519.6
3	Display Results	259	259	0.140	1850.0
	(SQL Overall)	178691	259	1.296	137878.9