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

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

441 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
tom	5	143	5805	(None)
atom	6	78	2452	1	atom
dom	6	97	5244	1	dom
mom	7	88	5316	1	mom
nom	5	104	5064	1	nom
om	4	85	5300	1	_om
pom	7	82	4991	1	pom
rom	5	98	5563	1	rom
som	5	91	5380	1	som
tam	5	86	6342	1	tam
to	2	188	5898	1	to_
tod	4	94	5707	1	tod
toe	3	101	6685	1	toe
tog	4	102	5504	1	tog
tomb	8	90	2965	1	tomb
tome	6	75	4319	1	tome
toms	6	83	4349	1	toms
ton	3	102	6510	1	ton
too	3	89	6542	1	too
toom	6	65	3293	1	toom
top	5	105	6068	1	top
tor	3	92	6168	1	tor
tot	3	88	8477	1	tot
tow	6	105	5736	1	tow
toy	6	96	5519	1	toy
yom	8	80	4344	1	yom
aim	5	78	5821	2	aim
am	4	118	7556	2	_am
arm	5	84	4962	2	arm
atoms	7	68	1756	2	atoms
atomy	10	74	1519	2	atomy
atop	6	61	2475	2	atop
bam	7	85	6014	2	bam
bo	4	109	5757	2	bo_
boa	5	69	5403	2	boa
bob	7	67	5566	2	bob
bod	6	70	5554	2	bod
bog	6	78	5241	2	bog
bomb	10	69	2742	2	bomb
boo	5	81	6366	2	boo
boom	8	74	3567	2	boom
bop	7	75	4948	2	bop
bos	5	79	6681	2	bos
bot	5	96	8040	2	bot
bow	8	70	5190	2	bow
box	12	101	4234	2	box
boy	8	77	5356	2	boy
bum	7	53	4269	2	bum
cam	7	80	5898	2	cam
cob	7	102	5875	2	cob
cod	6	96	6012	2	cod
cog	6	95	5290	2	cog
col	5	93	6035	2	col
coma	8	71	3485	2	coma
comb	10	66	3211	2	comb
come	8	75	4770	2	come
comp	10	67	3125	2	comp
con	5	102	6802	2	con
coo	5	95	6636	2	coo
cop	7	111	6237	2	cop
cor	5	99	6094	2	cor
corm	8	57	3537	2	corm
cos	5	102	7039	2	cos
cot	5	104	8322	2	cot
cow	8	98	5671	2	cow
cox	12	103	4678	2	cox
coy	8	105	5755	2	coy
coz	14	93	4536	2	coz
cum	7	64	4016	2	cum
cwm	10	68	1508	2	cwm
dam	6	74	5704	2	dam
dim	6	81	4649	2	dim
do	3	101	5525	2	do_
doc	6	68	4151	2	doc
doe	4	73	6195	2	doe
dog	5	74	4975	2	dog
dol	4	71	5065	2	dol
dome	7	72	4073	2	dome
doms	7	62	3957	2	doms
don	4	67	5765	2	don
doom	7	64	3007	2	doom
dor	4	72	5392	2	dor
dorm	7	68	3462	2	dorm
dos	4	80	6231	2	dos
dot	4	75	7318	2	dot
doum	7	62	2667	2	doum
dow	7	67	4997	2	dow
elm	5	75	3174	2	elm
em	4	94	4515	2	_em
eon	3	60	5208	2	eon
fem	8	60	4073	2	fem
foam	9	71	2717	2	foam
fob	8	67	4833	2	fob
foe	6	63	5081	2	foe
fog	7	69	4556	2	fog
foh	9	81	3589	2	foh
fon	6	63	5227	2	fon
fop	8	67	4370	2	fop
for	6	69	5207	2	for
form	9	58	3687	2	form
fou	6	67	4378	2	fou
fox	13	67	3786	2	fox
foy	9	60	4426	2	foy
from	9	69	2392	2	from
gam	6	70	6006	2	gam
gem	6	68	4022	2	gem
glom	7	54	2438	2	glom
go	3	87	4874	2	go_
goa	4	73	4380	2	goa
gob	6	89	5089	2	gob
god	5	74	4979	2	god
goo	4	77	5477	2	goo
gor	4	78	4826	2	gor
gorm	7	55	2939	2	gorm
gos	4	71	5513	2	gos
got	4	98	7044	2	got
gox	11	71	3718	2	gox
goy	7	78	4455	2	goy
gum	6	74	3953	2	gum
gym	9	57	1906	2	gym
ham	8	63	6328	2	ham
hem	8	61	4873	2	hem
him	8	62	4765	2	him
hm	7	81	2673	2	_hm
hmm	10	62	1899	2	hmm
ho	5	102	5827	2	ho_
hob	8	75	5092	2	hob
hod	7	68	5246	2	hod
hoe	6	75	6272	2	hoe
hog	7	80	4906	2	hog
holm	9	56	2810	2	holm
home	9	80	4244	2	home
homo	9	61	2647	2	homo
homy	12	66	2322	2	homy
hon	6	77	5938	2	hon
hop	8	75	5459	2	hop
hos	6	83	6419	2	hos
hot	6	77	7605	2	hot
how	9	72	5243	2	how
hoy	9	74	4791	2	hoy
hum	8	55	4293	2	hum
ion	3	60	5102	2	ion
ism	5	63	2238	2	ism
item	6	56	2038	2	item
jam	12	69	4252	2	jam
jo	9	95	3960	2	jo_
job	12	80	4177	2	job
joe	10	66	4235	2	joe
jog	11	74	3831	2	jog
jot	10	82	5902	2	jot
jow	13	76	3930	2	jow
joy	13	70	3636	2	joy
koa	7	67	3777	2	koa
kob	9	94	4238	2	kob
koi	7	75	3474	2	koi
kop	9	74	4020	2	kop
kor	7	65	3889	2	kor
kos	7	69	4482	2	kos
lam	5	76	6671	2	lam
lo	2	80	5344	2	lo_
loam	6	56	3048	2	loam
lob	5	71	5446	2	lob
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
low	6	60	5187	2	low
lox	10	82	4096	2	lox
lum	5	55	4293	2	lum
mem	7	79	4347	2	mem
mim	7	60	4841	2	mim
mm	6	78	2681	2	_mm
mo	4	91	5848	2	mo_
moa	5	72	4918	2	moa
mob	7	86	5191	2	mob
moc	7	78	4508	2	moc
mod	6	90	5440	2	mod
mog	6	69	4967	2	mog
mol	5	66	5459	2	mol
mome	8	52	3935	2	mome
momi	8	75	2448	2	momi
moms	8	65	3948	2	moms
mon	5	75	6157	2	mon
moo	5	84	6051	2	moo
mop	7	69	5082	2	mop
mor	5	68	5500	2	mor
mos	5	70	6712	2	mos
mot	5	72	7942	2	mot
mow	8	66	5035	2	mow
mum	7	66	4361	2	mum
nam	5	59	5339	2	nam
nim	5	71	4295	2	nim
no	2	93	5324	2	no_
nob	5	89	5442	2	nob
nod	4	75	4956	2	nod
nog	4	68	4731	2	nog
noh	6	66	4064	2	noh
noma	6	75	2946	2	noma
nome	6	60	3842	2	nome
noms	6	56	3640	2	noms
noo	3	71	5404	2	noo
nor	3	80	4882	2	nor
norm	6	64	2981	2	norm
nos	3	88	5932	2	nos
not	3	94	7466	2	not
now	6	59	5019	2	now
od	3	92	5524	2	_od
oe	2	84	7306	2	_oe
of	5	82	4777	2	_of
oh	5	74	4700	2	_oh
ohm	8	65	2301	2	ohm
oi	2	90	6148	2	_oi
oms	5	63	3751	2	_oms
on	2	80	5718	2	_on
ooh	6	76	3709	2	ooh
oot	3	112	7469	2	oot
op	4	58	5016	2	_op
or	2	73	5473	2	_or
os	2	113	5988	2	_os
ow	5	89	5017	2	_ow
ox	9	82	4238	2	_ox
oy	5	89	5013	2	_oy
pam	7	78	5839	2	pam
pod	6	63	5148	2	pod
poem	8	62	2577	2	poem
poh	8	67	4053	2	poh
poi	5	72	4466	2	poi
pol	5	64	4938	2	pol
pome	8	56	3669	2	pome
pomo	8	58	2845	2	pomo
pomp	10	62	2546	2	pomp
poms	8	70	3774	2	poms
poo	5	77	5711	2	poo
pop	7	62	5225	2	pop
pot	5	80	7843	2	pot
pow	8	71	4728	2	pow
pox	12	61	4069	2	pox
prom	8	76	3169	2	prom
ram	5	68	6727	2	ram
rem	5	61	5004	2	rem
rim	5	60	5227	2	rim
roam	6	71	3241	2	roam
rob	5	67	5430	2	rob
roc	5	202	4325	2	roc
rod	4	79	5389	2	rod
roe	3	68	6107	2	roe
romp	8	59	2657	2	romp
roms	6	70	3896	2	roms
room	6	62	3508	2	room
rot	3	72	8295	2	rot
row	6	74	5367	2	row
rum	5	66	4464	2	rum
sim	5	65	5313	2	sim
so	2	88	5544	2	so_
sob	5	78	5794	2	sob
sod	4	60	5370	2	sod
sol	3	72	5662	2	sol
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	8429	2	sot
sou	3	78	5369	2	sou
sow	6	65	5476	2	sow
sox	10	64	4419	2	sox
soy	6	78	5145	2	soy
stem	6	106	2824	2	stem
stoa	4	54	2591	2	stoa
stob	6	67	2461	2	stob
stoma	7	59	1827	2	stoma
stomp	9	56	1666	2	stomp
stop	6	65	3203	2	stop
storm	7	65	2037	2	storm
stot	4	63	4732	2	stot
stow	7	73	2574	2	stow
stum	6	55	2601	2	stum
sum	5	63	4601	2	sum
ta	2	116	6245	2	t_a
tab	5	74	6032	2	tab
tad	4	79	5982	2	tad
tae	3	82	6705	2	tae
tag	4	72	5949	2	tag
taj	10	64	4219	2	taj
tame	6	63	4366	2	tame
tamp	8	61	3300	2	tamp
tams	6	72	4793	2	tams
tan	3	71	6756	2	tan
tao	3	83	5895	2	tao
taos	4	55	4100	2	taos
tap	5	76	6387	2	tap
tar	3	75	7069	2	tar
tas	3	84	7710	2	tas
tat	3	76	9029	2	tat
tau	3	68	5690	2	tau
tav	6	60	4321	2	tav
taw	6	101	5545	2	taw
tax	10	94	4915	2	tax
tea	3	73	5332	2	tea
team	6	62	3865	2	team
ted	4	64	4656	2	ted
tee	3	83	6687	2	tee
teem	6	61	3260	2	teem
teg	4	57	4162	2	teg
tel	3	56	4790	2	tel
temp	8	53	2333	2	temp
ten	3	58	5611	2	ten
term	6	62	3315	2	term
tet	3	92	7498	2	tet
tew	6	66	4015	2	tew
the	6	74	3605	2	the
them	9	74	2704	2	them
tho	6	74	3396	2	tho
thou	7	67	2221	2	thou
thy	9	70	2291	2	thy
ti	2	84	4829	2	t_i
tic	5	63	4346	2	tic
tie	3	65	5753	2	tie
til	3	63	5026	2	til
time	6	62	3501	2	time
tin	3	63	6217	2	tin
tip	5	65	5122	2	tip
tis	3	70	5664	2	tis
tit	3	67	7104	2	tit
toad	5	58	3018	2	toad
toby	9	63	2229	2	toby
tods	5	61	4184	2	tods
tody	8	63	2721	2	tody
toea	4	67	3233	2	toea
toed	5	61	3704	2	toed
toes	4	69	5644	2	toes
toff	10	59	2990	2	toff
toft	7	74	4165	2	toft
tofu	7	69	2133	2	tofu
toga	5	70	2741	2	toga
togs	5	72	4243	2	togs
toil	4	65	3628	2	toil
toit	4	63	5306	2	toit
toke	8	67	3849	2	toke
tola	4	52	3633	2	tola
told	5	61	3220	2	told
tole	4	60	5290	2	tole
toll	4	55	3526	2	toll
tolu	4	55	2915	2	tolu
toman	7	57	2405	2	toman
tombs	9	78	1873	2	tombs
tomes	7	60	3738	2	tomes
tommy	12	47	1223	2	tommy
tone	4	69	5374	2	tone
tong	5	64	3435	2	tong
tons	4	65	5305	2	tons
tony	7	56	3515	2	tony
took	8	65	3107	2	took
tool	4	67	3568	2	tool
toon	4	77	4063	2	toon
toot	4	59	5888	2	toot
tope	6	59	4638	2	tope
toph	9	63	2687	2	toph
topi	6	78	3039	2	topi
topo	6	69	3240	2	topo
tops	6	62	4812	2	tops
tora	4	75	4599	2	tora
torc	6	63	3335	2	torc
tore	4	73	5932	2	tore
tori	4	75	4215	2	tori
torn	4	60	4425	2	torn
toro	4	80	4568	2	toro
torr	4	56	3090	2	torr
tors	4	61	5738	2	tors
tort	4	69	6746	2	tort
tory	7	58	4054	2	tory
tosh	7	48	2681	2	tosh
toss	4	56	3797	2	toss
tost	4	83	5192	2	tost
tote	4	66	4367	2	tote
totem	7	48	1936	2	totem
tots	4	66	5412	2	tots
tour	4	55	3037	2	tour
tout	4	67	5382	2	tout
town	7	69	2870	2	town
tows	7	85	4555	2	tows
towy	10	53	2547	2	towy
toyo	7	69	2545	2	toyo
toys	7	80	3634	2	toys
tram	6	70	3455	2	tram
trim	6	53	2951	2	trim
trod	5	76	2795	2	trod
trog	5	76	2821	2	trog
tromp	9	58	1580	2	tromp
trop	6	68	3330	2	trop
trot	4	63	5131	2	trot
trow	7	80	3142	2	trow
troy	7	74	2968	2	troy
try	6	65	2967	2	try
tsk	7	58	1473	2	tsk
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
twa	6	77	2164	2	twa
two	6	79	2583	2	two
twos	7	67	1802	2	twos
tye	6	58	3744	2	tye
um	4	73	3883	2	_um
umm	7	119	2126	2	umm
vim	8	74	3702	2	vim
voe	6	77	3905	2	voe
vow	9	61	3631	2	vow
vox	13	66	2815	2	vox
vum	8	54	2865	2	vum
whom	12	70	1817	2	whom
wo	5	104	4776	2	wo_
woe	6	66	5124	2	woe
wog	7	62	4273	2	wog
wok	10	63	3417	2	wok
womb	11	70	2223	2	womb
won	6	62	5206	2	won
woo	6	69	4980	2	woo
wop	8	71	4513	2	wop
worm	9	61	2948	2	worm
wos	6	69	5353	2	wos
wot	6	104	6748	2	wot
wow	9	66	4347	2	wow
yam	8	74	4899	2	yam
yo	5	97	4855	2	yo_
yob	8	79	4527	2	yob
yod	7	75	4550	2	yod
yok	10	73	3524	2	yok
yon	6	73	4895	2	yon
you	6	66	4182	2	you
yow	9	69	4529	2	yow
yum	8	61	3282	2	yum
zoa	12	85	2999	2	zoa
zoo	12	62	3891	2	zoo
zoom	15	67	2210	2	zoom

Search took 2 seconds 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.123	1452772.4
2	DLD Change Limit	14084	441	0.906	15545.3
3	Display Results	441	441	0.173	2549.1
	(SQL Overall)	178691	441	1.202	148661.4