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

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

308 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
dup	6	76	3788	(None)
cup	7	67	3824	1	cup
dap	6	66	5245	1	dap
dip	6	78	4898	1	dip
dub	6	66	4220	1	dub
dud	5	67	3759	1	dud
due	4	52	4986	1	due
dug	5	81	3869	1	dug
duh	7	79	3038	1	duh
dui	4	64	3338	1	dui
dump	9	59	2709	1	dump
dun	4	65	4558	1	dun
duo	4	85	3614	1	duo
dupe	7	66	3060	1	dupe
dups	7	59	2951	1	dups
hup	8	64	3781	1	hup
pup	7	63	3988	1	pup
sup	5	70	4194	1	sup
tup	5	60	3754	1	tup
up	4	78	3282	1	_up
yup	8	60	3170	1	yup
alp	5	66	4113	2	alp
amp	7	75	4102	2	amp
app	7	68	2760	2	app
asp	5	72	3534	2	asp
auk	7	62	3414	2	auk
bap	7	64	5584	2	bap
bop	7	75	4948	2	bop
bub	7	63	4398	2	bub
bud	6	70	4127	2	bud
bug	6	53	4074	2	bug
bum	7	53	4269	2	bum
bump	10	62	2824	2	bump
bun	5	63	4814	2	bun
bur	5	57	4469	2	bur
burp	8	50	2888	2	burp
bus	5	69	5097	2	bus
but	5	59	6302	2	but
buy	8	64	3654	2	buy
cap	7	67	5898	2	cap
cep	7	57	3633	2	cep
cop	7	111	6237	2	cop
coup	8	67	2979	2	coup
cub	7	69	4094	2	cub
cud	6	79	3745	2	cud
cue	5	75	4418	2	cue
cum	7	64	4016	2	cum
cups	8	54	3082	2	cups
cur	5	68	4198	2	cur
cusp	8	60	2106	2	cusp
cut	5	79	5766	2	cut
dab	6	74	5556	2	dab
dad	5	84	5616	2	dad
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
damp	9	62	2884	2	damp
dan	4	68	5967	2	dan
daps	7	72	3916	2	daps
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
deep	7	60	3188	2	deep
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
did	5	68	5051	2	did
die	4	67	5965	2	die
dif	7	68	4690	2	dif
dig	5	75	4447	2	dig
dim	6	81	4649	2	dim
din	4	64	5946	2	din
dips	7	55	3691	2	dips
dipt	7	73	3932	2	dipt
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
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
dopa	7	72	2090	2	dopa
dope	7	60	3889	2	dope
dopy	10	62	2415	2	dopy
dor	4	72	5392	2	dor
dorp	7	60	2805	2	dorp
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
drip	7	62	2395	2	drip
drop	7	53	2440	2	drop
drub	7	59	2013	2	drub
drug	6	57	1813	2	drug
drum	7	65	2159	2	drum
drupe	8	50	1299	2	drupe
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
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
dumps	10	52	2010	2	dumps
dumpy	13	54	1475	2	dumpy
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
duped	9	51	1832	2	duped
duper	8	55	1900	2	duper
dupes	8	64	2593	2	dupes
duple	8	53	1586	2	duple
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
duty	8	53	2145	2	duty
dye	7	53	3484	2	dye
fop	8	67	4370	2	fop
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
gap	6	70	5561	2	gap
gip	6	76	4536	2	gip
gul	4	58	3279	2	gul
gulp	7	55	2136	2	gulp
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
gyp	9	83	1901	2	gyp
hap	8	73	6005	2	hap
hep	8	66	4414	2	hep
hip	8	67	5043	2	hip
hop	8	75	5459	2	hop
hub	8	64	3748	2	hub
hue	6	66	4230	2	hue
hug	7	60	3736	2	hug
huh	9	64	3201	2	huh
hum	8	55	4293	2	hum
hump	11	62	2872	2	hump
hun	6	58	4471	2	hun
hut	6	64	5729	2	hut
hyp	11	78	2246	2	hyp
imp	7	66	2697	2	imp
jaup	13	53	1642	2	jaup
jug	11	55	2954	2	jug
jump	15	66	2172	2	jump
jun	10	59	3206	2	jun
jupe	13	49	2100	2	jupe
jus	10	69	3022	2	jus
jut	10	59	4401	2	jut
kep	9	64	3720	2	kep
kip	9	70	4213	2	kip
kop	9	74	4020	2	kop
kue	7	66	3186	2	kue
lap	5	85	6527	2	lap
lip	5	147	5580	2	lip
lop	5	82	5531	2	lop
loup	6	60	2843	2	loup
lug	4	61	3806	2	lug
lum	5	55	4293	2	lum
lump	8	65	3170	2	lump
luv	6	71	2577	2	luv
lux	10	65	2877	2	lux
map	7	72	5512	2	map
mop	7	69	5082	2	mop
mu	4	67	3748	2	mu_
mud	6	73	3686	2	mud
mug	6	58	3769	2	mug
mum	7	66	4361	2	mum
mump	10	54	2572	2	mump
mun	5	61	4386	2	mun
mus	5	59	4675	2	mus
mut	5	83	5718	2	mut
nap	5	67	5320	2	nap
nip	5	69	4598	2	nip
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
op	4	58	5016	2	_op
oud	4	74	3907	2	oud
ouph	9	56	1837	2	ouph
our	3	60	4289	2	our
out	3	80	7215	2	out
pap	7	67	5840	2	pap
pep	7	64	4708	2	pep
pip	7	80	5104	2	pip
pop	7	62	5225	2	pop
pub	7	60	3769	2	pub
pud	6	58	3665	2	pud
pug	6	53	3718	2	pug
pul	5	61	3806	2	pul
pulp	8	48	2535	2	pulp
pump	10	57	2685	2	pump
pun	5	88	4651	2	pun
pupa	8	54	2281	2	pupa
pups	8	60	3223	2	pups
pupu	8	76	2071	2	pupu
pur	5	68	4055	2	pur
pus	5	55	4784	2	pus
put	5	57	5907	2	put
qua	12	48	2197	2	qua
quip	15	48	1862	2	quip
rap	5	62	6196	2	rap
rep	5	58	4780	2	rep
rip	5	68	5130	2	rip
roup	6	66	2769	2	roup
rub	5	63	4282	2	rub
rue	3	55	4926	2	rue
rug	4	60	3915	2	rug
rum	5	66	4464	2	rum
rump	8	67	2908	2	rump
run	3	62	4498	2	run
rut	3	55	6052	2	rut
sap	5	64	6323	2	sap
scup	8	48	2238	2	scup
sip	5	76	5601	2	sip
sop	5	75	5786	2	sop
soup	6	62	3291	2	soup
sub	5	54	4555	2	sub
sue	3	56	5146	2	sue
suk	7	56	3297	2	suk
sum	5	63	4601	2	sum
sump	8	63	3153	2	sump
sun	3	71	4903	2	sun
supe	6	59	3276	2	supe
sups	6	48	3443	2	sups
suq	12	62	2899	2	suq
tap	5	76	6387	2	tap
tip	5	65	5122	2	tip
top	5	105	6068	2	top
tub	5	56	4003	2	tub
tug	4	59	3740	2	tug
tui	3	70	3402	2	tui
tump	8	59	2703	2	tump
tun	3	58	4519	2	tun
tups	6	56	2876	2	tups
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
ump	7	61	3044	2	ump
un	2	83	4113	2	_un
upo	5	89	2586	2	_upo
ups	5	56	2905	2	_ups
urp	5	64	2639	2	urp
us	2	69	3743	2	_us
ut	2	86	4703	2	_ut
vug	7	61	2741	2	vug
vum	8	54	2865	2	vum
wap	8	65	5337	2	wap
whup	12	57	1416	2	whup
wop	8	71	4513	2	wop
wud	7	62	2715	2	wud
xu	9	60	1883	2	xu_
yap	8	59	4982	2	yap
yaup	9	66	1848	2	yaup
yep	8	66	3896	2	yep
yip	8	72	4118	2	yip
yuk	10	67	2560	2	yuk
yum	8	61	3282	2	yum
yups	9	61	2160	2	yups
zap	14	58	4069	2	zap
zep	14	71	2914	2	zep
zip	14	66	3622	2	zip
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.266	671770.7
2	DLD Change Limit	14084	308	0.343	41061.2
3	Display Results	308	308	0.063	4888.9
	(SQL Overall)	178691	308	0.672	265909.2