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

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

357 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
lum	5	55	4293	(None)
alum	6	52	2761	1	alum
bum	7	53	4269	1	bum
cum	7	64	4016	1	cum
glum	7	58	2510	1	glum
gum	6	74	3953	1	gum
hum	8	55	4293	1	hum
lam	5	76	6671	1	lam
lug	4	61	3806	1	lug
luma	6	55	2752	1	luma
lump	8	65	3170	1	lump
lums	6	57	3424	1	lums
luv	6	71	2577	1	luv
lux	10	65	2877	1	lux
mum	7	66	4361	1	mum
plum	8	51	2210	1	plum
rum	5	66	4464	1	rum
slum	6	54	3051	1	slum
sum	5	63	4601	1	sum
um	4	73	3883	1	_um
vum	8	54	2865	1	vum
yum	8	61	3282	1	yum
aim	5	78	5821	2	aim
album	9	23	1265	2	album
algum	8	27	1176	2	algum
alums	7	57	2060	2	alums
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
blam	8	61	3170	2	blam
blub	8	53	2487	2	blub
blue	6	53	2846	2	blue
blume	9	56	1989	2	blume
blur	6	60	2053	2	blur
bub	7	63	4397	2	bub
bud	6	70	4127	2	bud
bug	6	53	4074	2	bug
bumf	11	61	2650	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
clam	8	63	3229	2	clam
club	8	58	1947	2	club
clue	6	53	2453	2	clue
clump	11	55	1745	2	clump
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
filum	10	50	1543	2	filum
flam	9	63	3329	2	flam
flu	6	65	3021	2	flu_
flub	9	57	2188	2	flub
flue	7	53	2985	2	flue
flume	10	60	2117	2	flume
flump	12	46	1472	2	flump
flus	7	56	2654	2	flus
flux	14	56	1774	2	flux
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
glam	7	65	2934	2	glam
glim	7	60	2635	2	glim
glom	7	54	2438	2	glom
glue	5	56	2849	2	glue
glug	6	61	1801	2	glug
glume	8	51	2046	2	glume
glums	8	46	2142	2	glums
glut	5	63	3129	2	glut
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
hilum	10	55	1460	2	hilum
him	8	62	4765	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
ileum	7	45	1282	2	ileum
ilium	7	46	1417	2	ilium
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
la	2	192	6163	2	l_a
lab	5	88	6478	2	lab
lac	5	101	5582	2	lac
lad	4	81	6570	2	lad
lag	4	78	6212	2	lag
lama	6	66	3529	2	lama
lamb	8	68	3214	2	lamb
lame	6	68	4929	2	lame
lamp	8	62	3382	2	lamp
lams	6	65	5226	2	lams
lap	5	85	6527	2	lap
lar	3	79	6753	2	lar
larum	7	43	1797	2	larum
las	3	72	8147	2	las
lat	3	75	9340	2	lat
laud	5	65	2772	2	laud
lav	6	68	4734	2	lav
law	6	86	5664	2	law
lax	10	76	5152	2	lax
lay	6	88	6535	2	lay
lea	3	76	6018	2	lea
led	4	62	5455	2	led
lee	3	60	6814	2	lee
leg	4	64	4611	2	leg
lei	3	68	4638	2	lei
lek	7	56	4030	2	lek
les	3	56	6307	2	les
let	3	64	8147	2	let
leu	3	60	4740	2	leu
leud	5	72	2342	2	leud
lev	6	61	3942	2	lev
lex	10	79	4382	2	lex
ley	6	62	4681	2	ley
lez	12	55	4131	2	lez
li	2	99	4875	2	l_i
lib	5	77	5026	2	lib
lid	4	74	5351	2	lid
lie	3	82	6452	2	lie
lima	6	57	3413	2	lima
limb	8	54	2937	2	limb
lime	6	62	4493	2	lime
limn	6	65	2769	2	limn
limo	6	55	2973	2	limo
limp	8	84	3249	2	limp
limy	9	57	2771	2	limy
lin	3	79	6737	2	lin
linum	7	3	1382	2	linum
lip	5	147	5580	2	lip
lis	3	71	6227	2	lis
lit	3	93	7731	2	lit
lo	2	80	5344	2	l_o
loam	6	56	3048	2	loam
lob	5	71	5446	2	lob
locum	9	48	1217	2	locum
log	4	62	5268	2	log
loo	3	83	5982	2	loo
loom	6	70	3505	2	loom
lop	5	82	5531	2	lop
lot	3	81	7926	2	lot
loud	5	52	2804	2	loud
louma	7	62	1363	2	louma
loup	6	60	2843	2	loup
lour	4	54	3068	2	lour
lout	4	59	5214	2	lout
low	6	60	5187	2	low
lox	10	82	4096	2	lox
luau	4	48	2416	2	luau
lube	6	47	3156	2	lube
luce	6	51	3257	2	luce
luck	10	53	2982	2	luck
lude	5	53	3164	2	lude
lues	4	59	4355	2	lues
luff	10	44	2670	2	luff
luge	5	55	3164	2	luge
lugs	5	52	3352	2	lugs
lull	4	42	2576	2	lull
lulu	4	41	2288	2	lulu
lumas	7	56	2291	2	lumas
lumen	7	52	2090	2	lumen
lumps	9	56	2498	2	lumps
lumpy	12	66	1591	2	lumpy
luna	4	62	2985	2	luna
lune	4	71	4049	2	lune
lung	5	57	3249	2	lung
lunk	8	60	3072	2	lunk
lunt	4	61	4884	2	lunt
luny	7	73	2413	2	luny
lure	4	51	4246	2	lure
lurk	8	66	2416	2	lurk
lush	7	53	2769	2	lush
lust	4	74	4260	2	lust
lute	4	63	4101	2	lute
lutz	13	68	2632	2	lutz
luvs	7	58	1850	2	luvs
luxe	11	52	2269	2	luxe
lye	6	65	3341	2	lye
mem	7	79	4347	2	mem
mim	7	60	4841	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	4385	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
oleum	7	36	1332	2	oleum
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
plug	7	49	1599	2	plug
plumb	11	45	1407	2	plumb
plume	9	48	1946	2	plume
plump	11	53	1526	2	plump
plums	9	46	1995	2	plums
plumy	12	42	1323	2	plumy
plus	6	63	2483	2	plus
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
scum	8	59	2452	2	scum
sim	5	65	5313	2	sim
slam	6	77	3797	2	slam
slim	6	66	3195	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
solum	7	47	1760	2	solum
som	5	91	5380	2	som
stum	6	55	2601	2	stum
sub	5	54	4555	2	sub
sue	3	56	5146	2	sue
suk	7	56	3297	2	suk
sumo	6	73	2631	2	sumo
sump	8	63	3153	2	sump
sums	6	58	3758	2	sums
sun	3	71	4903	2	sun
sup	5	70	4194	2	sup
suq	12	62	2899	2	suq
swum	9	64	1682	2	swum
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
ulu	3	60	2870	2	ulu
ulus	4	56	2256	2	ulus
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
ut	2	86	4703	2	_ut
velum	10	7	1338	2	velum
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
ylem	9	2	1789	2	ylem
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.060	2978183.3
2	DLD Change Limit	14084	357	0.423	33295.5
3	Display Results	357	357	0.076	4697.4
	(SQL Overall)	178691	357	0.559	319661.9