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

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

542 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
ole	3	71	5521	(None)
ale	3	65	7234	1	ale
bole	6	64	4869	1	bole
cole	6	69	5611	1	cole
dole	5	65	5000	1	dole
hole	7	75	5339	1	hole
jole	11	72	3382	1	jole
mole	6	62	5183	1	mole
obe	5	66	3864	1	obe
ode	4	74	4658	1	ode
oe	2	84	7306	1	o_e
ogle	5	63	2505	1	ogle
oke	7	58	3948	1	oke
old	4	70	3346	1	old
olea	4	65	3272	1	olea
oleo	4	66	3048	1	oleo
oles	4	64	5347	1	oles
one	3	70	5091	1	one
ope	5	68	4524	1	ope
ore	3	66	6183	1	ore
orle	4	56	3046	1	orle
ose	3	81	4734	1	ose
owe	6	70	4103	1	owe
pole	6	59	5130	1	pole
role	4	58	5182	1	role
sole	4	60	5367	1	sole
tole	4	60	5290	1	tole
vole	7	52	3698	1	vole
able	6	63	4053	2	able
ace	5	96	5683	2	ace
ae	2	125	9029	2	_ae
age	4	71	5433	2	age
al	2	106	7404	2	al_
ala	3	124	6360	2	ala
alae	4	56	4375	2	alae
alb	5	73	4265	2	alb
alec	6	64	3006	2	alec
alee	4	66	5232	2	alee
alef	7	63	4069	2	alef
ales	4	70	6710	2	ales
all	3	61	4823	2	all
alme	6	58	3216	2	alme
aloe	4	55	4019	2	aloe
alp	5	66	4113	2	alp
als	3	66	6302	2	als
alt	3	64	6796	2	alt
amole	7	57	2459	2	amole
ane	3	78	6694	2	ane
anole	5	53	3037	2	anole
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
axle	11	64	2460	2	axle
aye	6	71	5176	2	aye
azole	14	51	1803	2	azole
bale	6	63	5384	2	bale
be	4	79	4894	2	_be
bee	5	62	6240	2	bee
bel	5	71	4846	2	bel
bile	6	61	4718	2	bile
blae	6	61	3464	2	blae
bleb	8	54	2522	2	bleb
bled	7	57	2931	2	bled
blet	6	62	4767	2	blet
blew	9	47	2243	2	blew
blue	6	53	2846	2	blue
bode	7	58	3875	2	bode
bogle	8	58	2168	2	bogle
bola	6	60	3556	2	bola
bold	7	54	3281	2	bold
boles	7	54	4860	2	boles
boll	6	56	3475	2	boll
bolo	6	55	3595	2	bolo
bolt	6	62	5417	2	bolt
bone	6	59	4932	2	bone
bore	6	60	5133	2	bore
boule	7	48	2804	2	boule
bye	8	61	3459	2	bye
cee	5	59	5270	2	cee
cel	5	60	4055	2	cel
clef	9	70	2818	2	clef
clew	9	55	2057	2	clew
clue	6	53	2453	2	clue
coble	9	48	2317	2	coble
code	7	73	4773	2	code
coke	10	70	3838	2	coke
col	5	93	6035	2	col_
cola	6	65	4139	2	cola
cold	7	73	3877	2	cold
coled	8	55	4075	2	coled
coles	7	60	5506	2	coles
cols	6	65	5308	2	cols
colt	6	71	5824	2	colt
coly	9	69	4053	2	coly
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
cove	9	58	3707	2	cove
cue	5	75	4418	2	cue
dale	5	56	4398	2	dale
de	3	70	4954	2	_de
dee	4	76	6582	2	dee
del	4	67	5275	2	del
dele	5	68	4308	2	dele
dhole	9	52	1536	2	dhole
die	4	67	5965	2	die
doe	4	73	6195	2	doe
doge	6	62	3380	2	doge
dol	4	71	5065	2	dol_
dolce	8	58	1668	2	dolce
doled	7	54	3091	2	doled
doles	6	78	4375	2	doles
doll	5	66	3249	2	doll
dols	5	69	4305	2	dols
dolt	5	66	4942	2	dolt
dome	7	72	4073	2	dome
done	5	57	4791	2	done
dope	7	60	3889	2	dope
dore	5	63	5330	2	dore
dose	5	64	4243	2	dose
dote	5	54	4288	2	dote
dove	8	51	3156	2	dove
doze	14	58	2908	2	doze
due	4	52	4986	2	due
dye	7	53	3484	2	dye
eel	3	79	4684	2	eel
eke	7	56	3009	2	eke
el	2	67	4529	2	el_
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
else	4	59	2308	2	else
eme	5	58	3718	2	eme
ere	3	63	5277	2	ere
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
eye	6	55	3977	2	eye
fe	5	79	4474	2	_fe
fee	6	68	6201	2	fee
fie	6	71	5244	2	fie
file	7	54	4664	2	file
flea	7	56	2849	2	flea
fled	8	54	2977	2	fled
flee	7	62	3879	2	flee
flew	10	58	2425	2	flew
flex	14	61	2347	2	flex
fley	10	66	2685	2	fley
floe	7	61	2977	2	floe
flu	6	65	3021	2	flu
flue	7	53	2985	2	flue
fly	9	71	2495	2	fly
foe	6	63	5081	2	foe
fold	8	65	2894	2	fold
foley	11	52	2230	2	foley
folk	11	60	2154	2	folk
fore	7	83	5147	2	fore
gae	4	64	5770	2	gae
gale	5	63	4732	2	gale
gee	4	53	5920	2	gee
gel	4	56	4243	2	gel
gie	4	71	4954	2	gie
gled	6	56	3114	2	gled
glee	5	52	3906	2	glee
gleg	6	62	1980	2	gleg
glen	5	60	2720	2	glen
gley	8	57	2465	2	gley
glue	5	56	2849	2	glue
gold	6	54	3016	2	gold
golem	8	4	1611	2	golem
golf	8	57	3118	2	golf
gone	5	56	3904	2	gone
gore	5	57	4496	2	gore
hae	6	73	6400	2	hae
hale	7	60	5283	2	hale
haole	8	48	2008	2	haole
he	5	81	5195	2	_he
hie	6	76	5270	2	hie
hoe	6	75	6272	2	hoe
hoke	11	59	3593	2	hoke
hold	8	62	3506	2	hold
holed	9	56	3413	2	holed
holes	8	47	4865	2	holes
holey	11	56	2690	2	holey
holk	11	60	2794	2	holk
holm	9	56	2810	2	holm
holp	9	57	2755	2	holp
hols	7	69	4629	2	hols
holt	7	78	5258	2	holt
holy	10	63	3343	2	holy
home	9	80	4244	2	home
hone	7	75	4932	2	hone
hope	9	66	3967	2	hope
hose	7	65	4724	2	hose
hove	10	71	3222	2	hove
howe	10	67	3410	2	howe
hoyle	11	3	1441	2	hoyle
hue	6	66	4230	2	hue
ice	5	67	3724	2	ice
idle	5	54	2376	2	idle
ilea	4	59	3146	2	ilea
ilex	11	58	2203	2	ilex
ilk	7	83	2530	2	ilk
ill	3	74	3709	2	ill
ire	3	69	4317	2	ire
isle	4	51	2170	2	isle
jee	10	66	4864	2	jee
joe	10	66	4235	2	joe
joke	15	59	2616	2	joke
joles	12	52	3083	2	joles
jolt	11	66	3912	2	jolt
joule	12	49	1820	2	joule
kae	7	67	4454	2	kae
kale	8	65	3375	2	kale
koel	8	45	1994	2	koel
kola	8	51	2496	2	kola
kolo	8	70	2622	2	kolo
kore	8	58	3416	2	kore
kue	7	66	3186	2	kue
kye	10	73	2727	2	kye
la	2	192	6163	2	_la
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
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	_li
lie	3	82	6452	2	lie
lo	2	80	5344	2	_lo
lob	5	71	5446	2	lob
lobe	6	55	3536	2	lobe
lode	5	62	4011	2	lode
log	4	62	5268	2	log
loge	5	68	3719	2	loge
loll	4	61	2838	2	loll
lone	4	58	4913	2	lone
loo	3	83	5982	2	loo
lop	5	82	5531	2	lop
lope	6	59	4192	2	lope
lore	4	58	5035	2	lore
lose	4	51	4458	2	lose
lot	3	81	7926	2	lot
love	7	52	3476	2	love
low	6	60	5187	2	low
lowe	7	54	3531	2	lowe
lox	10	82	4096	2	lox
lye	6	65	3341	2	lye
mae	5	76	5910	2	mae
male	6	60	5229	2	male
me	4	77	4833	2	_me
mel	5	60	4748	2	mel
mile	6	63	5257	2	mile
mode	7	58	4030	2	mode
moke	10	62	3422	2	moke
mol	5	66	5459	2	mol_
mola	6	60	3563	2	mola
mold	7	60	3433	2	mold
moles	7	47	4792	2	moles
moll	6	67	3570	2	moll
mols	6	59	4857	2	mols
molt	6	63	5616	2	molt
moly	9	60	3191	2	moly
mome	8	52	3935	2	mome
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
mule	6	52	3697	2	mule
nae	3	59	5274	2	nae
ne	2	70	4510	2	_ne
nee	3	66	5778	2	nee
noble	7	44	2099	2	noble
node	5	130	3688	2	node
noel	4	52	2655	2	noel
nolo	4	62	2931	2	nolo
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
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
obole	7	59	1714	2	obole
oca	5	67	3173	2	oca
od	3	92	5524	2	o_d
oda	4	81	3304	2	oda
odd	5	77	2545	2	odd
odea	5	62	2457	2	odea
odes	5	72	4324	2	odes
ods	4	75	4621	2	ods
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
ogled	7	59	1596	2	ogled
ogler	6	59	1744	2	ogler
ogles	6	52	2318	2	ogles
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
oiled	6	44	2947	2	oiled
oiler	5	46	2828	2	oiler
oils	4	63	3797	2	oils
oily	7	79	3225	2	oily
oka	7	69	2680	2	oka
okeh	11	46	1532	2	okeh
okes	8	49	3634	2	okes
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
oleic	7	3	1333	2	oleic
olein	5	3	1600	2	olein
oleos	5	54	1968	2	oleos
oleum	7	36	1332	2	oleum
olio	4	68	2967	2	olio
olive	8	48	1715	2	olive
olla	4	48	2117	2	olla
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
only	7	53	1972	2	only
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
ores	4	60	5668	2	ores
orles	5	53	2621	2	orles
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
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
ovule	8	3	949	2	ovule
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
owlet	8	33	2446	2	owlet
owls	7	60	2293	2	owls
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
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
pale	6	60	5501	2	pale
pe	4	76	4903	2	_pe
pee	5	60	6651	2	pee
pele	6	55	3955	2	pele
pie	5	54	5740	2	pie
pile	6	56	4969	2	pile
plea	6	68	3060	2	plea
pleb	8	61	2381	2	pleb
pled	7	52	3143	2	pled
plew	9	72	2281	2	plew
plex	13	73	2137	2	plex
plie	6	51	2739	2	plie
ply	8	63	2355	2	ply
poke	10	53	3536	2	poke
pol	5	64	4938	2	pol_
poled	8	49	3484	2	poled
poler	7	44	3179	2	poler
poles	7	53	5100	2	poles
poll	6	63	3213	2	poll
polo	6	62	3663	2	polo
pols	6	60	4456	2	pols
poly	9	62	3515	2	poly
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
prole	7	45	2779	2	prole
pule	6	50	4095	2	pule
pye	8	64	3250	2	pye
rale	4	50	5056	2	rale
re	2	61	5374	2	_re
ree	3	79	7407	2	ree
rile	4	56	5053	2	rile
robe	6	53	3564	2	robe
roble	7	52	2302	2	roble
rode	5	58	4430	2	rode
roe	3	68	6107	2	roe
roles	5	67	4798	2	roles
rolf	7	51	3487	2	rolf
roll	4	63	3165	2	roll
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
rue	3	55	4926	2	rue
rule	4	99	3842	2	rule
rye	6	60	3254	2	rye
sae	3	83	6518	2	sae
sale	4	49	5970	2	sale
see	3	57	7226	2	see
sel	3	82	5332	2	sel
she	6	68	3769	2	she
sled	5	53	3437	2	sled
slew	7	62	2823	2	slew
sloe	4	55	3495	2	sloe
slue	4	53	3219	2	slue
sly	6	62	2856	2	sly
socle	7	4	1957	2	socle
soke	8	54	3626	2	soke
sol	3	72	5662	2	sol_
sola	4	55	4186	2	sola
sold	5	48	3741	2	sold
soled	6	58	3517	2	soled
solei	5	56	2433	2	solei
soles	5	55	4792	2	soles
soli	4	66	3700	2	soli
solo	4	55	3894	2	solo
sols	4	54	4816	2	sols
solve	8	56	1894	2	solve
some	6	60	4038	2	some
sone	4	66	4998	2	sone
sore	4	70	5953	2	sore
stole	5	49	2881	2	stole
sue	3	56	5146	2	sue
tae	3	82	6705	2	tae
tale	4	61	5416	2	tale
tee	3	83	6687	2	tee
tel	3	56	4790	2	tel
tele	4	50	4087	2	tele
the	6	74	3605	2	the
thole	8	56	2084	2	thole
tie	3	65	5753	2	tie
tile	4	54	5144	2	tile
toe	3	101	6685	2	toe
toile	5	46	2649	2	toile
toke	8	67	3849	2	toke
tola	4	52	3633	2	tola
told	5	61	3220	2	told
toled	6	59	3492	2	toled
toles	5	51	4713	2	toles
toll	4	55	3526	2	toll
tolu	4	55	2915	2	tolu
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
tule	4	57	3587	2	tule
tye	6	58	3744	2	tye
uke	7	57	2729	2	uke
ulu	3	60	2870	2	ulu
use	3	68	3516	2	use
ute	3	53	3588	2	ute
vale	7	49	3734	2	vale
vee	6	57	5018	2	vee
vie	6	54	4763	2	vie
vile	7	61	3980	2	vile
voe	6	77	3905	2	voe
voile	8	47	1972	2	voile
voled	9	53	2372	2	voled
voles	8	62	3404	2	voles
volt	7	64	3953	2	volt
volte	8	53	2130	2	volte
vote	7	47	2862	2	vote
wae	6	75	5695	2	wae
wale	7	45	4643	2	wale
we	5	70	4345	2	_we
wee	6	67	6081	2	wee
whole	11	44	1809	2	whole
wile	7	59	4437	2	wile
woe	6	66	5124	2	woe
woke	11	55	2796	2	woke
wold	8	54	2907	2	wold
wolf	10	57	2956	2	wolf
wore	7	71	4467	2	wore
wove	10	56	2431	2	wove
wye	9	63	3197	2	wye
wyle	10	55	1938	2	wyle
ye	5	76	5006	2	_ye
ylem	9	2	1789	2	ylem
yodle	9	45	1504	2	yodle
yoke	11	56	2639	2	yoke
yolk	11	62	1899	2	yolk
yore	7	63	3594	2	yore
yowe	10	67	2874	2	yowe
yule	7	57	2514	2	yule
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.060	2978183.3
2	DLD Change Limit	14084	542	0.486	28979.4
3	Display Results	542	542	0.106	5113.2
	(SQL Overall)	178691	542	0.652	274066.0