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

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

368 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
sup	5	70	4194	(None)
cup	7	67	3824	1	cup
dup	6	76	3788	1	dup
hup	8	64	3781	1	hup
pup	7	63	3988	1	pup
sap	5	64	6323	1	sap
scup	8	48	2238	1	scup
sip	5	76	5601	1	sip
sop	5	75	5786	1	sop
soup	6	62	3291	1	soup
sub	5	54	4555	1	sub
sue	3	56	5146	1	sue
suk	7	56	3297	1	suk
sum	5	63	4601	1	sum
sump	8	63	3153	1	sump
sun	3	71	4903	1	sun
supe	6	59	3276	1	supe
sups	6	48	3443	1	sups
suq	12	62	2899	1	suq
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
dap	6	66	5245	2	dap
dip	6	78	4898	2	dip
dub	6	66	4220	2	dub
dud	5	67	3759	2	dud
due	4	52	4986	2	due
dug	5	81	3869	2	dug
duh	7	79	3038	2	duh
dui	4	64	3338	2	dui
dump	9	59	2709	2	dump
dun	4	65	4558	2	dun
duo	4	85	3614	2	duo
dupe	7	66	3060	2	dupe
dups	7	59	2951	2	dups
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	4214	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	4499	2	run
rut	3	55	6052	2	rut
sab	5	65	6320	2	sab
sac	5	74	5286	2	sac
sad	4	74	5920	2	sad
sae	3	83	6518	2	sae
sag	4	61	6340	2	sag
sal	3	64	6288	2	sal
salp	6	45	3409	2	salp
samp	8	57	3359	2	samp
saps	6	53	4637	2	saps
sat	3	62	8848	2	sat
sau	3	63	5657	2	sau
saul	4	58	3652	2	saul
saw	6	82	5535	2	saw
sax	10	74	4764	2	sax
say	6	72	6476	2	say
scaup	9	55	1599	2	scaup
scop	8	59	2552	2	scop
scud	7	62	2128	2	scud
sculp	9	53	1484	2	sculp
scum	8	59	2452	2	scum
scups	9	53	1665	2	scups
scut	6	58	3554	2	scut
sea	3	61	6129	2	sea
sec	5	59	4532	2	sec
see	3	57	7226	2	see
seep	6	65	4034	2	seep
seg	4	55	4488	2	seg
sei	3	60	4893	2	sei
sel	3	82	5332	2	sel
sen	3	60	5852	2	sen
sept	6	58	4436	2	sept
ser	3	67	5240	2	ser
set	3	66	8125	2	set
setup	7	39	1582	2	setup
sew	6	62	4726	2	sew
sex	10	70	4322	2	sex
sh	5	68	2852	2	s_h
sha	6	98	3778	2	sha
she	6	68	3769	2	she
shh	9	71	2107	2	shh
ship	9	52	2824	2	ship
shop	9	56	2984	2	shop
shul	7	58	2315	2	shul
shun	7	51	2277	2	shun
shut	7	61	3759	2	shut
shy	9	67	2819	2	shy
si	2	91	4957	2	s_i
sib	5	68	5031	2	sib
sic	5	58	4787	2	sic
sim	5	65	5314	2	sim
simp	8	52	2877	2	simp
sin	3	62	6589	2	sin
sipe	6	73	4104	2	sipe
sips	6	57	4010	2	sips
sir	3	57	4667	2	sir
sirup	7	40	1491	2	sirup
sis	3	73	6054	2	sis
sit	3	58	7775	2	sit
situp	7	44	1406	2	situp
six	10	53	3974	2	six
ska	7	69	2586	2	ska
skep	10	52	1935	2	skep
ski	7	49	2569	2	ski
skip	10	54	2175	2	skip
skua	8	61	1315	2	skua
sky	10	64	2099	2	sky
slap	6	64	3404	2	slap
slip	6	70	3173	2	slip
slop	6	65	3387	2	slop
slub	6	54	2803	2	slub
slue	4	53	3219	2	slue
slug	5	51	2464	2	slug
slum	6	54	3051	2	slum
slump	9	48	1663	2	slump
slur	4	55	2515	2	slur
slurp	7	40	1498	2	slurp
slut	4	50	4059	2	slut
sly	6	62	2856	2	sly
smug	7	58	1526	2	smug
smut	6	66	2978	2	smut
snap	6	57	2703	2	snap
snip	6	64	2465	2	snip
snub	6	53	2076	2	snub
snug	5	52	1869	2	snug
so	2	88	5544	2	s_o
soap	6	58	3113	2	soap
sob	5	78	5794	2	sob
sod	4	60	5370	2	sod
sol	3	72	5662	2	sol
som	5	91	5381	2	som
son	3	77	6195	2	son
soph	9	70	2420	2	soph
sops	6	52	4456	2	sops
sos	3	77	6160	2	sos
sot	3	103	8430	2	sot
sou	3	78	5369	2	sou
souk	8	61	2717	2	souk
soul	4	64	3571	2	soul
soups	7	53	2294	2	soups
soupy	10	61	1540	2	soupy
sour	4	59	3589	2	sour
sous	4	69	4721	2	sous
sow	6	65	5476	2	sow
sox	10	64	4419	2	sox
soy	6	78	5145	2	soy
spa	5	57	3081	2	spa
spud	7	58	1849	2	spud
spue	6	60	2552	2	spue
spun	6	62	2146	2	spun
spur	6	53	2119	2	spur
spy	8	60	2374	2	spy
sri	3	56	3400	2	sri
step	6	71	2629	2	step
stop	6	65	3203	2	stop
stoup	7	55	1707	2	stoup
stub	6	62	2184	2	stub
stud	5	62	2009	2	stud
stum	6	55	2602	2	stum
stump	9	46	1646	2	stump
stun	4	56	2345	2	stun
stupa	7	41	1231	2	stupa
stupe	7	52	1775	2	stupe
sty	6	62	2731	2	sty
suba	6	49	2660	2	suba
subs	6	60	3712	2	subs
such	9	64	2481	2	such
suck	10	61	3173	2	suck
sudd	6	47	1977	2	sudd
suds	5	61	3529	2	suds
sued	5	65	3793	2	sued
suer	4	53	3403	2	suer
sues	4	62	4765	2	sues
suet	4	67	5482	2	suet
sugh	8	64	2344	2	sugh
suit	4	56	4987	2	suit
suks	8	59	2712	2	suks
sulk	8	53	2665	2	sulk
sulu	4	51	2842	2	sulu
sumo	6	73	2631	2	sumo
sumps	9	50	2343	2	sumps
sums	6	58	3758	2	sums
sung	5	58	3217	2	sung
sunk	8	50	3181	2	sunk
sunn	4	54	2359	2	sunn
suns	4	58	4190	2	suns
sunup	7	3	1305	2	sunup
super	7	49	2448	2	super
supes	7	56	2830	2	supes
supra	7	36	1425	2	supra
suqs	13	43	1965	2	suqs
sura	4	57	4029	2	sura
surd	5	64	3381	2	surd
sure	4	54	4741	2	sure
surf	7	60	3931	2	surf
suss	4	52	2930	2	suss
swap	9	59	2543	2	swap
swop	9	51	2050	2	swop
swum	9	64	1682	2	swum
syn	6	70	2412	2	syn
syph	12	54	1327	2	syph
syrup	10	30	1096	2	syrup
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
uh	5	74	2985	2	_uh
um	4	73	3883	2	_um
ump	7	61	3044	2	ump
un	2	83	4114	2	_un
upo	5	89	2586	2	_upo
ups	5	56	2905	2	_ups
urp	5	64	2640	2	urp
us	2	69	3743	2	_us
use	3	68	3516	2	use
usurp	7	10	690	2	usurp
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.250	714764.0
2	DLD Change Limit	14084	368	0.406	34689.7
3	Display Results	368	368	0.080	4600.0
	(SQL Overall)	178691	368	0.736	242786.7