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

Here are the results of your fuzzy-string dictionary search for “ode” 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
ode	4	74	4658	(None)
bode	7	58	3875	1	bode
code	7	73	4773	1	code
de	3	70	4954	1	_de
doe	4	73	6195	1	doe
lode	5	62	4011	1	lode
mode	7	58	4030	1	mode
node	5	130	3688	1	node
obe	5	66	3864	1	obe
od	3	92	5524	1	od_
oda	4	81	3304	1	oda
odd	5	77	2545	1	odd
odea	5	62	2457	1	odea
odes	5	72	4324	1	odes
ods	4	75	4621	1	ods
oe	2	84	7306	1	o_e
oke	7	58	3948	1	oke
ole	3	71	5521	1	ole
one	3	70	5091	1	one
ope	5	68	4524	1	ope
ore	3	66	6183	1	ore
ose	3	81	4734	1	ose
owe	6	70	4103	1	owe
rode	5	58	4430	1	rode
abode	8	55	1881	2	abode
ace	5	96	5683	2	ace
ad	3	119	7503	2	ad_
add	5	101	3236	2	add
ado	4	91	4687	2	ado
ads	4	97	5573	2	ads
adz	13	123	3286	2	adz
adze	14	128	2057	2	adze
ae	2	125	9029	2	_ae
age	4	71	5433	2	age
aide	5	60	4499	2	aide
ale	3	65	7234	2	ale
ane	3	78	6695	2	ane
anode	6	50	2103	2	anode
ape	5	72	5118	2	ape
are	3	78	7457	2	are
ate	3	70	5924	2	ate
ave	6	77	4870	2	ave
awe	6	77	4662	2	awe
axe	10	82	3949	2	axe
aye	6	71	5176	2	aye
bade	7	51	4088	2	bade
be	4	79	4894	2	_be
bed	6	79	5062	2	bed
bee	5	62	6240	2	bee
bide	7	60	4148	2	bide
bod	6	70	5554	2	bod_
boded	9	51	2496	2	boded
bodes	8	49	3510	2	bodes
bods	7	62	4471	2	bods
body	10	74	2567	2	body
bole	6	64	4869	2	bole
bone	6	59	4932	2	bone
bore	6	60	5133	2	bore
bye	8	61	3459	2	bye
cade	7	64	4391	2	cade
cede	7	49	2876	2	cede
cee	5	59	5270	2	cee
cod	6	96	6012	2	cod_
coda	7	70	2934	2	coda
codec	10	71	2034	2	codec
coded	9	54	3318	2	coded
coden	8	61	2854	2	coden
coder	8	61	3422	2	coder
codes	8	62	4729	2	codes
codex	15	58	1758	2	codex
cods	7	68	4810	2	cods
coed	7	71	4054	2	coed
coke	10	70	3838	2	coke
cole	6	69	5611	2	cole
come	8	75	4770	2	come
cone	6	72	5696	2	cone
cope	8	68	4738	2	cope
core	6	72	6311	2	core
cote	6	66	4873	2	cote
coude	8	50	2263	2	coude
cove	9	58	3707	2	cove
cue	5	75	4418	2	cue
deb	6	63	4269	2	_deb
dee	4	76	6582	2	dee
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
die	4	67	5965	2	die
diode	7	47	1611	2	diode
do	3	101	5525	2	_do
doc	6	68	4151	2	doc
dodge	8	66	1812	2	dodge
dodo	6	60	2491	2	dodo
doer	5	77	3470	2	doer
does	5	65	5447	2	does
dog	5	74	4975	2	dog
doge	6	62	3380	2	doge
dol	4	71	5065	2	dol
dole	5	65	5000	2	dole
dom	6	97	5244	2	dom
dome	7	72	4073	2	dome
don	4	67	5765	2	don
done	5	57	4791	2	done
dope	7	60	3889	2	dope
dor	4	72	5392	2	dor
dore	5	63	5330	2	dore
dos	4	80	6231	2	dos
dose	5	64	4243	2	dose
dot	4	75	7318	2	dot
dote	5	54	4288	2	dote
dove	8	51	3156	2	dove
dow	7	67	4997	2	dow
doze	14	58	2908	2	doze
dude	6	56	2966	2	dude
due	4	52	4986	2	due
dye	7	53	3484	2	dye
ed	3	86	4518	2	ed_
edge	6	57	1966	2	edge
edh	7	69	2156	2	edh
eds	4	66	3892	2	eds
eide	5	58	3223	2	eide
eke	7	56	3009	2	eke
eme	5	58	3718	2	eme
epode	8	51	1409	2	epode
ere	3	63	5277	2	ere
erode	6	45	2099	2	erode
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
eye	6	55	3977	2	eye
fade	8	57	3634	2	fade
fe	5	79	4474	2	_fe
fed	7	65	4835	2	fed
fee	6	68	6201	2	fee
fie	6	71	5244	2	fie
foe	6	63	5081	2	foe
fore	7	83	5147	2	fore
gae	4	64	5770	2	gae
ged	5	70	4453	2	ged
gee	4	53	5920	2	gee
geode	7	4	1259	2	geode
gie	4	71	4954	2	gie
god	5	74	4979	2	god_
godet	7	5	3004	2	godet
gods	6	54	3804	2	gods
gone	5	56	3904	2	gone
gore	5	57	4496	2	gore
gude	6	54	2333	2	gude
hade	8	54	4019	2	hade
hae	6	73	6400	2	hae
he	5	81	5195	2	_he
hide	8	51	3463	2	hide
hie	6	76	5270	2	hie
hod	7	68	5246	2	hod_
hods	8	72	3986	2	hods
hoe	6	75	6272	2	hoe
hoed	8	78	3798	2	hoed
hoke	11	59	3593	2	hoke
hole	7	75	5339	2	hole
home	9	80	4244	2	home
hone	7	75	4932	2	hone
hope	9	66	3967	2	hope
horde	9	46	2305	2	horde
hose	7	65	4724	2	hose
hove	10	71	3222	2	hove
howe	10	67	3410	2	howe
hue	6	66	4230	2	hue
ice	5	67	3724	2	ice
id	3	89	4183	2	id_
idea	5	91	2277	2	idea
idem	7	61	2106	2	idem
ides	5	77	3423	2	ides
idle	5	54	2376	2	idle
ids	4	75	3546	2	ids
ire	3	69	4317	2	ire
jade	12	53	2544	2	jade
jee	10	66	4864	2	jee
joe	10	66	4235	2	joe
joke	15	59	2616	2	joke
jole	11	72	3382	2	jole
kae	7	67	4454	2	kae
kore	8	58	3416	2	kore
kue	7	66	3186	2	kue
kye	10	73	2727	2	kye
lade	5	63	4598	2	lade
led	4	62	5455	2	led
lee	3	60	6814	2	lee
lie	3	82	6452	2	lie
lobe	6	55	3536	2	lobe
loden	6	66	2114	2	loden
lodes	6	64	3691	2	lodes
lodge	7	65	2008	2	lodge
loge	5	68	3719	2	loge
lone	4	58	4913	2	lone
lope	6	59	4192	2	lope
lore	4	58	5035	2	lore
lose	4	51	4458	2	lose
love	7	52	3476	2	love
lowe	7	54	3531	2	lowe
lude	5	53	3164	2	lude
lye	6	65	3341	2	lye
made	7	54	4024	2	made
mae	5	76	5911	2	mae
me	4	77	4833	2	_me
med	6	61	4674	2	med
mod	6	90	5440	2	mod_
model	8	45	2169	2	model
modem	10	37	1714	2	modem
modes	8	55	3741	2	modes
modi	7	68	2631	2	modi
mods	7	79	4505	2	mods
moke	10	62	3422	2	moke
mole	6	62	5183	2	mole
mome	8	52	3935	2	mome
monde	8	57	2314	2	monde
mope	8	68	3804	2	mope
more	6	71	5452	2	more
mote	6	70	4808	2	mote
moue	6	58	3557	2	moue
move	9	66	3072	2	move
nae	3	59	5274	2	nae
ne	2	70	4510	2	_ne
nee	3	66	5778	2	nee
nide	5	55	3578	2	nide
nod	4	75	4956	2	nod_
nodes	6	46	3349	2	nodes
nodi	5	66	2674	2	nodi
nods	5	58	3822	2	nods
nome	6	60	3842	2	nome
none	4	57	4317	2	none
nope	6	59	3419	2	nope
nose	4	67	3936	2	nose
note	4	62	3996	2	note
nude	5	66	2627	2	nude
oaf	6	59	5288	2	oaf
oak	7	62	3865	2	oak
oar	3	70	5795	2	oar
oat	3	98	8826	2	oat
oba	5	75	3155	2	oba
obes	6	60	3683	2	obes
obey	9	65	2130	2	obey
obi	5	71	2773	2	obi
oboe	6	68	2294	2	oboe
oca	5	67	3173	2	oca
odah	8	70	1893	2	odah
odas	5	72	3026	2	odas
odder	7	45	1539	2	odder
odds	6	89	1992	2	odds
odeon	6	4	1148	2	odeon
odeum	8	46	1054	2	odeum
odic	7	49	2057	2	odic
odor	5	57	1809	2	odor
odyl	8	41	1146	2	odyl
odyle	9	34	959	2	odyle
oes	3	58	6619	2	oes
of	5	82	4777	2	o_f
off	9	63	3163	2	off
oft	6	77	4406	2	oft
ogee	5	76	2988	2	ogee
ogle	5	63	2505	2	ogle
ogre	5	63	2074	2	ogre
oh	5	74	4700	2	o_h
ohed	8	78	2518	2	ohed
ohm	8	65	2301	2	ohm
oho	6	65	3438	2	oho
ohs	6	62	3231	2	ohs
oi	2	90	6148	2	o_i
oil	3	74	5205	2	oil
oka	7	69	2680	2	oka
okeh	11	46	1532	2	okeh
okes	8	49	3634	2	okes
old	4	70	3346	2	old
olden	6	51	1485	2	olden
older	6	51	2117	2	older
oldie	6	4	1547	2	oldie
olds	5	59	2657	2	olds
oldy	8	53	1684	2	oldy
olea	4	65	3272	2	olea
oleo	4	66	3048	2	oleo
oles	4	64	5347	2	oles
om	4	85	5300	2	o_m
omen	6	68	2818	2	omen
omer	6	70	2839	2	omer
oms	5	63	3751	2	oms
on	2	80	5718	2	o_n
once	6	54	2308	2	once
ones	4	61	4653	2	ones
ono	3	68	3803	2	ono
ons	3	61	4851	2	ons
ooh	6	76	3709	2	ooh
oot	3	112	7469	2	oot
ooze	13	64	2060	2	ooze
op	4	58	5016	2	o_p
oped	7	62	3015	2	oped
open	6	64	2700	2	open
opes	6	59	4261	2	opes
ops	5	66	4125	2	ops
opt	5	75	4554	2	opt
or	2	73	5473	2	o_r
ora	3	72	5083	2	ora
orb	5	57	3686	2	orb
orc	5	70	3492	2	orc
order	6	50	1936	2	order
ordo	5	46	2235	2	ordo
ores	4	60	5668	2	ores
orle	4	56	3046	2	orle
ors	3	57	5011	2	ors
ort	3	94	6523	2	ort
os	2	113	5988	2	o_s
oses	4	66	4151	2	oses
oud	4	74	3907	2	oud
ouds	5	64	3010	2	ouds
our	3	60	4289	2	our
out	3	80	7215	2	out
ova	6	68	2379	2	ova
oven	7	66	2414	2	oven
over	7	72	2734	2	over
ow	5	89	5017	2	o_w
owed	8	68	3387	2	owed
owes	7	51	3710	2	owes
owl	6	62	2897	2	owl
own	6	64	2970	2	own
owse	7	63	2162	2	owse
ox	9	82	4238	2	o_x
oxen	11	62	1859	2	oxen
oxes	11	65	3072	2	oxes
oxide	13	12	1095	2	oxide
oxo	10	73	2296	2	oxo
oxy	13	63	2098	2	oxy
oy	5	89	5013	2	o_y
oyer	7	59	2765	2	oyer
oyes	7	49	4013	2	oyes
oyez	16	60	2035	2	oyez
pe	4	76	4903	2	_pe
ped	6	67	5152	2	ped
pee	5	60	6651	2	pee
pie	5	54	5740	2	pie
pod	6	63	5148	2	pod_
pods	7	65	4015	2	pods
poke	10	53	3536	2	poke
pole	6	59	5130	2	pole
pome	8	56	3669	2	pome
pone	6	57	4753	2	pone
pope	8	55	3561	2	pope
pore	6	64	5126	2	pore
pose	6	64	4173	2	pose
pye	8	64	3250	2	pye
re	2	61	5374	2	_re
red	4	67	5580	2	red
rede	5	50	3766	2	rede
ree	3	79	7407	2	ree
ride	5	59	4512	2	ride
robe	6	53	3564	2	robe
rod	4	79	5389	2	rod_
rodeo	6	59	2109	2	rodeo
rodes	6	140	3908	2	rodes
rods	5	64	4206	2	rods
roe	3	68	6108	2	roe
role	4	58	5182	2	role
rope	6	55	4291	2	rope
rose	4	61	4890	2	rose
rote	4	62	4902	2	rote
roue	4	59	4174	2	roue
rove	7	51	3698	2	rove
rude	5	56	3278	2	rude
rue	3	55	4926	2	rue
rye	6	60	3254	2	rye
sade	5	55	4447	2	sade
sae	3	83	6518	2	sae
see	3	57	7226	2	see
she	6	68	3769	2	she
side	5	54	4448	2	side
sod	4	60	5370	2	sod_
soda	5	63	2938	2	soda
sods	5	49	4021	2	sods
soke	8	54	3626	2	soke
sole	4	60	5367	2	sole
some	6	60	4038	2	some
sonde	6	46	2283	2	sonde
sone	4	66	4998	2	sone
sore	4	70	5953	2	sore
spode	8	46	1770	2	spode
sue	3	56	5146	2	sue
tae	3	82	6705	2	tae
ted	4	64	4656	2	ted
tee	3	83	6687	2	tee
the	6	74	3605	2	the
tide	5	52	3737	2	tide
tie	3	65	5753	2	tie
tod	4	94	5707	2	tod_
tods	5	61	4184	2	tods
tody	8	63	2721	2	tody
toe	3	101	6685	2	toe
toed	5	61	3704	2	toed
toke	8	67	3849	2	toke
tole	4	60	5290	2	tole
tome	6	75	4319	2	tome
tone	4	69	5374	2	tone
tope	6	59	4638	2	tope
tore	4	73	5932	2	tore
tote	4	66	4367	2	tote
trode	6	53	2285	2	trode
tye	6	58	3744	2	tye
udo	4	90	2730	2	udo
uke	7	57	2729	2	uke
unde	5	58	2548	2	unde
use	3	68	3516	2	use
ute	3	53	3588	2	ute
vee	6	57	5018	2	vee
vide	8	54	3275	2	vide
vie	6	54	4763	2	vie
voe	6	77	3905	2	voe
vole	7	52	3698	2	vole
vote	7	47	2862	2	vote
wade	8	52	3706	2	wade
wae	6	75	5695	2	wae
we	5	70	4345	2	_we
wed	7	58	4362	2	wed
wee	6	67	6081	2	wee
wide	8	52	3540	2	wide
wodge	10	72	1292	2	wodge
woe	6	66	5124	2	woe
woke	11	55	2796	2	woke
wore	7	71	4467	2	wore
wove	10	56	2431	2	wove
wye	9	63	3197	2	wye
ye	5	76	5006	2	_ye
yod	7	75	4550	2	yod_
yodel	9	47	1408	2	yodel
yodh	11	99	1610	2	yodh
yodle	9	45	1504	2	yodle
yods	8	65	3118	2	yods
yoke	11	56	2639	2	yoke
yore	7	63	3594	2	yore
yowe	10	67	2874	2	yowe
zed	13	54	3117	2	zed
zee	12	61	4323	2	zee
zone	13	52	3108	2	zone

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.063	2836365.1
2	DLD Change Limit	14084	441	0.390	36112.8
3	Display Results	441	441	0.096	4593.8
	(SQL Overall)	178691	441	0.549	325484.5