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

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

363 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
sum	5	63	4601	(None)
bum	7	53	4269	1	bum
cum	7	64	4016	1	cum
gum	6	74	3953	1	gum
hum	8	55	4293	1	hum
lum	5	55	4293	1	lum
mum	7	66	4361	1	mum
rum	5	66	4464	1	rum
scum	8	59	2452	1	scum
sim	5	65	5314	1	sim
slum	6	54	3051	1	slum
som	5	91	5381	1	som
stum	6	55	2602	1	stum
sub	5	54	4555	1	sub
sue	3	56	5146	1	sue
suk	7	56	3297	1	suk
sumo	6	73	2631	1	sumo
sump	8	63	3153	1	sump
sums	6	58	3758	1	sums
sun	3	71	4903	1	sun
sup	5	70	4194	1	sup
suq	12	62	2899	1	suq
swum	9	64	1682	1	swum
um	4	73	3883	1	_um
vum	8	54	2865	1	vum
yum	8	61	3282	1	yum
aim	5	78	5821	2	aim
alum	6	52	2761	2	alum
am	4	118	7556	2	_am
amu	5	82	3732	2	amu
arm	5	84	4962	2	arm
arum	6	61	2903	2	arum
auk	7	62	3414	2	auk
bam	7	85	6014	2	bam
bub	7	63	4398	2	bub
bud	6	70	4127	2	bud
bug	6	53	4074	2	bug
bumf	11	61	2651	2	bumf
bump	10	62	2824	2	bump
bums	8	59	3459	2	bums
bun	5	63	4814	2	bun
bur	5	57	4469	2	bur
bus	5	69	5097	2	bus
but	5	59	6302	2	but
buy	8	64	3654	2	buy
cam	7	80	5898	2	cam
chum	11	63	1800	2	chum
cub	7	69	4094	2	cub
cud	6	79	3745	2	cud
cue	5	75	4418	2	cue
culm	8	58	2238	2	culm
cup	7	67	3824	2	cup
cur	5	68	4198	2	cur
cut	5	79	5766	2	cut
cwm	10	68	1508	2	cwm
dam	6	74	5704	2	dam
dim	6	81	4649	2	dim
dom	6	97	5244	2	dom
doum	7	62	2667	2	doum
drum	7	65	2159	2	drum
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
duma	7	55	2445	2	duma
dumb	9	71	2410	2	dumb
dump	9	59	2709	2	dump
dun	4	65	4558	2	dun
duo	4	85	3614	2	duo
dup	6	76	3788	2	dup
elm	5	75	3174	2	elm
em	4	94	4515	2	_em
emu	5	59	2998	2	emu
fem	8	60	4073	2	fem
fub	8	63	3739	2	fub
fud	7	63	3515	2	fud
fug	7	62	3451	2	fug
fume	9	67	2763	2	fume
fumy	12	71	1858	2	fumy
fun	6	68	4114	2	fun
fur	6	66	3732	2	fur
gam	6	70	6006	2	gam
gaum	7	57	2642	2	gaum
gem	6	68	4022	2	gem
geum	7	54	2455	2	geum
glum	7	58	2510	2	glum
grum	7	56	2508	2	grum
gul	4	58	3279	2	gul
gums	7	50	3094	2	gums
gun	4	72	4080	2	gun
gut	4	67	5385	2	gut
guv	7	45	2317	2	guv
guy	7	57	2894	2	guy
gym	9	57	1906	2	gym
ham	8	63	6328	2	ham
hem	8	61	4873	2	hem
him	8	62	4766	2	him
hm	7	81	2673	2	_hm
hmm	10	62	1899	2	hmm
hub	8	64	3748	2	hub
hue	6	66	4230	2	hue
hug	7	60	3736	2	hug
huh	9	64	3201	2	huh
hump	11	62	2872	2	hump
hums	9	68	3142	2	hums
hun	6	58	4471	2	hun
hup	8	64	3781	2	hup
hut	6	64	5729	2	hut
ism	5	63	2238	2	ism
jam	12	69	4252	2	jam
jug	11	55	2954	2	jug
jump	15	66	2172	2	jump
jun	10	59	3206	2	jun
jus	10	69	3022	2	jus
jut	10	59	4401	2	jut
kue	7	66	3186	2	kue
lam	5	76	6671	2	lam
lug	4	61	3806	2	lug
luma	6	55	2752	2	luma
lump	8	65	3170	2	lump
lums	6	57	3424	2	lums
luv	6	71	2577	2	luv
lux	10	65	2877	2	lux
mem	7	79	4347	2	mem
mim	7	60	4842	2	mim
mm	6	78	2681	2	_mm
mom	7	88	5316	2	mom
mu	4	67	3748	2	mu_
mud	6	73	3686	2	mud
mug	6	58	3769	2	mug
mumm	7	57	1886	2	mumm
mump	10	54	2572	2	mump
mums	8	57	3277	2	mums
mumu	8	60	2206	2	mumu
mun	5	61	4386	2	mun
mus	5	59	4675	2	mus
mut	5	83	5718	2	mut
nam	5	59	5339	2	nam
neum	6	67	2308	2	neum
nim	5	71	4295	2	nim
nom	5	104	5064	2	nom
nu	2	63	3195	2	nu_
nub	5	64	3914	2	nub
numb	8	55	2061	2	numb
nun	3	55	3774	2	nun
nus	3	79	3939	2	nus
nut	3	66	5196	2	nut
ohm	8	65	2301	2	ohm
om	4	85	5300	2	_om
oud	4	74	3907	2	oud
our	3	60	4289	2	our
out	3	80	7215	2	out
ovum	9	23	1017	2	ovum
pam	7	78	5839	2	pam
plum	8	51	2210	2	plum
pom	7	82	4991	2	pom
pub	7	60	3769	2	pub
pud	6	58	3665	2	pud
pug	6	53	3718	2	pug
pul	5	61	3806	2	pul
puma	8	54	2412	2	puma
pump	10	57	2685	2	pump
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
ram	5	68	6727	2	ram
rem	5	61	5004	2	rem
rim	5	60	5227	2	rim
rom	5	98	5563	2	rom
rub	5	63	4282	2	rub
rue	3	55	4926	2	rue
rug	4	60	3915	2	rug
rump	8	67	2908	2	rump
rums	6	48	3347	2	rums
run	3	62	4498	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
sagum	8	5	1287	2	sagum
sal	3	64	6288	2	sal
same	6	52	4564	2	same
samp	8	57	3359	2	samp
sap	5	64	6323	2	sap
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
scam	8	59	3235	2	scam
scrum	9	54	1820	2	scrum
scud	7	62	2128	2	scud
scums	9	50	1742	2	scums
scup	8	48	2238	2	scup
scut	6	58	3554	2	scut
sea	3	61	6129	2	sea
seam	6	66	4597	2	seam
sebum	9	38	1455	2	sebum
sec	5	59	4532	2	sec
sedum	8	41	1557	2	sedum
see	3	57	7226	2	see
seem	6	54	3856	2	seem
seg	4	55	4488	2	seg
sei	3	60	4893	2	sei
sel	3	82	5332	2	sel
seme	6	58	3665	2	seme
semi	6	51	2722	2	semi
sen	3	60	5852	2	sen
ser	3	67	5240	2	ser
serum	7	52	2347	2	serum
set	3	66	8125	2	set
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
sham	9	64	3636	2	sham
she	6	68	3769	2	she
shh	9	71	2107	2	shh
shim	9	58	2786	2	shim
shmo	9	53	1810	2	shmo
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
sima	6	47	3078	2	sima
simp	8	52	2877	2	simp
sims	6	57	3717	2	sims
sin	3	62	6589	2	sin
sip	5	76	5601	2	sip
sir	3	57	4667	2	sir
sis	3	73	6054	2	sis
sit	3	58	7775	2	sit
six	10	53	3974	2	six
ska	7	69	2586	2	ska
ski	7	49	2569	2	ski
skim	10	53	2251	2	skim
skua	8	61	1315	2	skua
sky	10	64	2099	2	sky
slam	6	77	3797	2	slam
slim	6	66	3196	2	slim
slub	6	54	2803	2	slub
slue	4	53	3219	2	slue
slug	5	51	2464	2	slug
slump	9	48	1663	2	slump
slums	7	46	2343	2	slums
slur	4	55	2515	2	slur
slut	4	50	4059	2	slut
sly	6	62	2856	2	sly
smug	7	58	1526	2	smug
smut	6	66	2978	2	smut
snub	6	53	2076	2	snub
snug	5	52	1869	2	snug
so	2	88	5544	2	s_o
sob	5	78	5794	2	sob
sod	4	60	5370	2	sod
sol	3	72	5662	2	sol
solum	7	47	1761	2	solum
soma	6	56	3529	2	soma
some	6	60	4038	2	some
soms	6	62	3937	2	soms
son	3	77	6195	2	son
sop	5	75	5786	2	sop
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
soup	6	62	3291	2	soup
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
spam	8	59	3004	2	spam
spud	7	58	1849	2	spud
spue	6	60	2552	2	spue
spume	9	58	1731	2	spume
spumy	12	46	1036	2	spumy
spun	6	62	2146	2	spun
spur	6	53	2119	2	spur
spy	8	60	2374	2	spy
sri	3	56	3400	2	sri
stem	6	106	2825	2	stem
strum	7	56	1945	2	strum
stub	6	62	2184	2	stub
stud	5	62	2009	2	stud
stump	9	46	1646	2	stump
stums	7	53	2008	2	stums
stun	4	56	2345	2	stun
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
sumac	9	95	1488	2	sumac
summa	9	47	1331	2	summa
sumos	7	57	2009	2	sumos
sumps	9	50	2343	2	sumps
sung	5	58	3217	2	sung
sunk	8	50	3181	2	sunk
sunn	4	54	2359	2	sunn
suns	4	58	4190	2	suns
supe	6	59	3276	2	supe
sups	6	48	3443	2	sups
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
swam	9	63	2998	2	swam
swim	9	62	2140	2	swim
syn	6	70	2412	2	syn
tam	5	86	6342	2	tam
tom	5	143	5805	2	tom
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
tup	5	60	3754	2	tup
tut	3	67	5809	2	tut
tux	10	54	2657	2	tux
uh	5	74	2985	2	_uh
umm	7	119	2126	2	umm
ump	7	61	3044	2	_ump
un	2	83	4113	2	_un
up	4	78	3282	2	_up
us	2	69	3743	2	_us
use	3	68	3516	2	use
ut	2	86	4703	2	_ut
vim	8	74	3702	2	vim
vug	7	61	2741	2	vug
wud	7	62	2715	2	wud
xu	9	60	1883	2	xu_
yam	8	74	4899	2	yam
yom	8	80	4344	2	yom
yuk	10	67	2560	2	yuk
yup	8	60	3170	2	yup
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	363	0.390	36112.8
3	Display Results	363	363	0.063	5761.9
	(SQL Overall)	178691	363	0.703	254183.5