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

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

322 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
dud	5	67	3759	(None)
bud	6	70	4127	1	bud
cud	6	79	3745	1	cud
dad	5	84	5616	1	dad
did	5	68	5051	1	did
duad	6	65	2141	1	duad
dub	6	66	4220	1	dub
dude	6	56	2966	1	dude
duds	6	55	3014	1	duds
due	4	52	4986	1	due
dug	5	81	3869	1	dug
duh	7	79	3038	1	duh
dui	4	64	3338	1	dui
dun	4	65	4558	1	dun
duo	4	85	3614	1	duo
dup	6	76	3788	1	dup
fud	7	63	3515	1	fud
mud	6	73	3686	1	mud
oud	4	74	3907	1	oud
pud	6	58	3665	1	pud
wud	7	62	2715	1	wud
ad	3	119	7503	2	_ad
add	5	101	3236	2	add
aid	4	92	6907	2	aid
and	4	72	4417	2	and
auk	7	62	3414	2	auk
auld	5	41	2536	2	auld
bad	6	77	6315	2	bad
baud	7	49	2842	2	baud
bed	6	79	5062	2	bed
bid	6	77	5179	2	bid
bod	6	70	5554	2	bod
bub	7	63	4398	2	bub
buds	7	52	3517	2	buds
bug	6	53	4074	2	bug
bum	7	53	4269	2	bum
bun	5	63	4814	2	bun
bund	7	55	3066	2	bund
bur	5	57	4469	2	bur
burd	7	55	3426	2	burd
bus	5	69	5097	2	bus
but	5	59	6302	2	but
buy	8	64	3654	2	buy
cad	6	74	5636	2	cad
cod	6	96	6012	2	cod
crud	7	52	1961	2	crud
cub	7	69	4094	2	cub
cuds	7	67	3047	2	cuds
cue	5	75	4418	2	cue
cued	7	63	2956	2	cued
cum	7	64	4016	2	cum
cup	7	67	3824	2	cup
cur	5	68	4198	2	cur
curd	7	76	3498	2	curd
cut	5	79	5766	2	cut
dab	6	74	5556	2	dab
dada	6	64	2244	2	dada
dado	6	71	2633	2	dado
dads	6	74	4277	2	dads
dag	5	77	5301	2	dag
dah	7	81	4898	2	dah
dak	8	63	4069	2	dak
dal	4	75	5495	2	dal
dam	6	74	5704	2	dam
dan	4	68	5967	2	dan
dap	6	66	5245	2	dap
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
dead	6	54	3424	2	dead
deb	6	63	4269	2	deb
dee	4	76	6582	2	dee
deed	6	53	4090	2	deed
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	4694	2	dib
dido	6	65	2819	2	dido
didy	9	91	2150	2	didy
die	4	67	5965	2	die
died	6	61	3785	2	died
dif	7	68	4690	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
dit	4	70	7133	2	dit
do	3	101	5525	2	d_o
doc	6	68	4151	2	doc
dodo	6	60	2491	2	dodo
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
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
druid	7	41	1132	2	druid
drum	7	65	2159	2	drum
dry	7	65	2603	2	dry
duads	7	65	1534	2	duads
dual	5	59	2817	2	dual
dubs	7	84	3219	2	dubs
duce	7	69	3350	2	duce
duci	7	64	2262	2	duci
duck	11	59	2917	2	duck
duct	7	57	3546	2	duct
duddy	11	49	1103	2	duddy
duded	8	44	1713	2	duded
dudes	7	54	2437	2	dudes
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
duked	11	52	1846	2	duked
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
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
duped	9	51	1832	2	duped
dups	7	59	2951	2	dups
dura	5	52	3211	2	dura
dure	5	63	4181	2	dure
dured	7	50	2540	2	dured
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
duty	8	53	2145	2	duty
dyad	9	64	1545	2	dyad
dye	7	53	3484	2	dye
dyed	9	67	2076	2	dyed
ed	3	86	4518	2	_ed
eld	4	67	3379	2	eld
end	4	68	3435	2	end
fad	7	74	5241	2	fad
fed	7	65	4835	2	fed
feud	8	65	2302	2	feud
fid	7	68	4768	2	fid
fub	8	63	3739	2	fub
fuds	8	65	2856	2	fuds
fug	7	62	3451	2	fug
fun	6	68	4114	2	fun
fund	8	56	2498	2	fund
fur	6	66	3732	2	fur
gad	5	75	5665	2	gad
gaud	6	70	2543	2	gaud
ged	5	70	4453	2	ged
gid	5	70	4726	2	gid
god	5	74	4979	2	god
gude	6	54	2333	2	gude
guid	6	60	2282	2	guid
gul	4	58	3279	2	gul
gum	6	74	3953	2	gum
gun	4	72	4080	2	gun
gut	4	67	5385	2	gut
guv	7	45	2317	2	guv
guy	7	57	2894	2	guy
had	7	76	5876	2	had
hid	7	62	4837	2	hid
hod	7	68	5246	2	hod
hub	8	64	3748	2	hub
hue	6	66	4230	2	hue
hued	8	69	2585	2	hued
hug	7	60	3736	2	hug
huh	9	64	3201	2	huh
hum	8	55	4293	2	hum
hun	6	58	4471	2	hun
hup	8	64	3781	2	hup
hut	6	64	5729	2	hut
id	3	89	4183	2	_id
judo	12	53	1530	2	judo
jug	11	55	2954	2	jug
jun	10	59	3206	2	jun
jus	10	69	3022	2	jus
jut	10	59	4401	2	jut
kid	8	65	4061	2	kid
kudo	9	61	1510	2	kudo
kudu	9	58	1542	2	kudu
kue	7	66	3186	2	kue
lad	4	81	6570	2	lad
laud	5	65	2772	2	laud
led	4	62	5455	2	led
leud	5	72	2342	2	leud
lid	4	74	5351	2	lid
loud	5	52	2804	2	loud
lude	5	53	3164	2	lude
lug	4	61	3806	2	lug
lum	5	55	4293	2	lum
luv	6	71	2577	2	luv
lux	10	65	2877	2	lux
mad	6	89	5871	2	mad
maud	7	53	2540	2	maud
med	6	61	4674	2	med
mid	6	73	5446	2	mid
mod	6	90	5440	2	mod
mu	4	67	3748	2	mu_
muds	7	55	3065	2	muds
mug	6	58	3769	2	mug
mum	7	66	4361	2	mum
mun	5	61	4386	2	mun
mus	5	59	4675	2	mus
mut	5	83	5718	2	mut
nod	4	75	4956	2	nod
nu	2	63	3195	2	nu_
nub	5	64	3914	2	nub
nude	5	66	2627	2	nude
nun	3	55	3774	2	nun
nurd	5	62	2434	2	nurd
nus	3	79	3939	2	nus
nut	3	66	5196	2	nut
od	3	92	5524	2	_od
odd	5	77	2545	2	odd
old	4	70	3346	2	old
ouds	5	64	3010	2	ouds
our	3	60	4289	2	our
out	3	80	7215	2	out
pad	6	80	5732	2	pad
ped	6	67	5152	2	ped
pod	6	63	5148	2	pod
pub	7	60	3769	2	pub
puds	7	56	3051	2	puds
pug	6	53	3718	2	pug
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
put	5	57	5907	2	put
qua	12	48	2197	2	qua
quad	14	46	1870	2	quad
quid	14	49	2235	2	quid
quod	14	54	1362	2	quod
rad	4	76	6200	2	rad
red	4	67	5580	2	red
rid	4	67	5462	2	rid
rod	4	79	5389	2	rod
rub	5	63	4282	2	rub
rudd	6	59	1747	2	rudd
rude	5	56	3278	2	rude
rue	3	55	4926	2	rue
rued	5	57	2979	2	rued
rug	4	60	3915	2	rug
rum	5	66	4464	2	rum
run	3	62	4498	2	run
rut	3	55	6052	2	rut
sad	4	74	5920	2	sad
scud	7	62	2128	2	scud
sod	4	60	5370	2	sod
spud	7	58	1849	2	spud
stud	5	62	2009	2	stud
sub	5	54	4555	2	sub
sudd	6	47	1977	2	sudd
suds	5	61	3529	2	suds
sue	3	56	5146	2	sue
sued	5	65	3793	2	sued
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
surd	5	64	3381	2	surd
tad	4	79	5982	2	tad
ted	4	64	4656	2	ted
thud	8	56	1391	2	thud
tod	4	94	5707	2	tod
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
turd	5	60	2762	2	turd
tut	3	67	5809	2	tut
tux	10	54	2657	2	tux
udo	4	90	2730	2	udo
uh	5	74	2985	2	_uh
um	4	73	3883	2	_um
un	2	83	4113	2	_un
up	4	78	3282	2	_up
urd	4	64	2704	2	urd
us	2	69	3743	2	_us
ut	2	86	4703	2	_ut
vid	7	72	4180	2	vid
vug	7	61	2741	2	vug
vum	8	54	2865	2	vum
wad	7	70	5389	2	wad
wed	7	58	4362	2	wed
xu	9	60	1883	2	xu_
yaud	8	70	2008	2	yaud
yid	7	66	4082	2	yid
yod	7	75	4550	2	yod
yuk	10	67	2560	2	yuk
yum	8	61	3282	2	yum
yup	8	60	3170	2	yup
zed	13	54	3117	2	zed
zuz	11	106	2203	2	zuz

Search took 1 second 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.063	2836365.1
2	DLD Change Limit	14084	322	0.390	36112.8
3	Display Results	322	322	0.063	5111.1
	(SQL Overall)	178691	322	0.516	346300.4