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

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

454 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
mole	6	62	5183	(None)
amole	7	57	2459	1	amole
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
male	6	60	5230	1	male
mile	6	63	5257	1	mile
mode	7	58	4030	1	mode
moke	10	62	3422	1	moke
mol	5	66	5459	1	mol_
mola	6	60	3563	1	mola
mold	7	60	3433	1	mold
moles	7	47	4792	1	moles
moll	6	67	3570	1	moll
mols	6	59	4857	1	mols
molt	6	63	5616	1	molt
moly	9	60	3191	1	moly
mome	8	52	3935	1	mome
mope	8	68	3804	1	mope
more	6	71	5452	1	more
mote	6	70	4808	1	mote
moue	6	58	3557	1	moue
move	9	66	3072	1	move
mule	6	52	3697	1	mule
ole	3	71	5521	1	_ole
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
ale	3	65	7234	2	_ale
aloe	4	55	4019	2	aloe
amble	9	59	2464	2	amble
amoles	8	41	2219	2	amoles
ample	9	47	2030	2	ample
anole	5	53	3038	2	anole
axle	11	64	2460	2	axle
azole	14	51	1803	2	azole
bale	6	63	5384	2	bale
bile	6	61	4718	2	bile
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
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	4076	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
dale	5	56	4398	2	dale
dele	5	68	4308	2	dele
dhole	9	52	1536	2	dhole
doe	4	73	6195	2	do_e
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
emote	7	54	2119	2	emote
file	7	54	4664	2	file
floe	7	61	2977	2	floe
foe	6	63	5081	2	fo_e
fold	8	65	2894	2	fold
foley	11	52	2230	2	foley
folk	11	60	2154	2	folk
fore	7	83	5147	2	fore
gale	5	63	4732	2	gale
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
hale	7	60	5283	2	hale
haole	8	48	2008	2	haole
hoe	6	75	6272	2	ho_e
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	2811	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
idle	5	54	2376	2	idle
isle	4	51	2170	2	isle
joe	10	66	4235	2	jo_e
joke	15	59	2616	2	joke
joles	12	52	3083	2	joles
jolt	11	66	3912	2	jolt
joule	12	49	1820	2	joule
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
lobe	6	55	3536	2	lobe
lode	5	62	4011	2	lode
loge	5	68	3719	2	loge
loll	4	61	2838	2	loll
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
mabe	8	57	3336	2	mabe
mace	8	73	4579	2	mace
macle	9	61	2700	2	macle
made	7	54	4024	2	made
mae	5	76	5911	2	m_ae
mage	7	57	3913	2	mage
maile	7	52	3222	2	maile
make	10	55	3789	2	make
males	7	50	4979	2	males
mall	6	46	3937	2	mall
malm	8	51	2998	2	malm
malt	6	62	5481	2	malt
mane	6	50	5203	2	mane
maple	9	55	2114	2	maple
mare	6	47	5933	2	mare
mate	6	51	5422	2	mate
maze	15	54	3498	2	maze
me	4	77	4833	2	m__e
mel	5	60	4748	2	mel_
meld	7	58	3047	2	meld
melee	7	37	2910	2	melee
mell	6	49	3561	2	mell
mels	6	59	4153	2	mels
melt	6	57	5289	2	melt
meme	8	53	3055	2	meme
mere	6	72	4444	2	mere
merle	7	58	2437	2	merle
mete	6	44	3813	2	mete
meze	15	44	2090	2	meze
mice	8	74	4223	2	mice
mike	10	55	3529	2	mike
mil	5	57	5211	2	mil_
mild	7	53	3085	2	mild
miler	7	57	3306	2	miler
miles	7	46	4507	2	miles
milk	10	50	2847	2	milk
mill	6	65	4148	2	mill
mille	7	50	2913	2	mille
milo	6	55	3610	2	milo
mils	6	60	4533	2	mils
milt	6	54	5581	2	milt
mime	8	57	3640	2	mime
mine	6	72	5617	2	mine
mire	6	67	4823	2	mire
mise	6	60	4358	2	mise
mite	6	62	4941	2	mite
mo	4	91	5848	2	mo__
moa	5	72	4918	2	mo_a
moan	6	58	3202	2	moan
moas	6	55	4534	2	moas
moat	6	63	5203	2	moat
mob	7	86	5192	2	mo_b
mobile	10	36	1354	2	mobile
mobled	11	32	1318	2	mobled
mobs	8	57	3737	2	mobs
moc	7	78	4508	2	mo_c
mock	12	64	2944	2	mock
mocs	8	58	3490	2	mocs
mod	6	90	5440	2	mo_d
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
module	9	30	1103	2	module
mog	6	69	4967	2	mo_g
mogs	7	54	3933	2	mogs
mohel	10	49	1483	2	mohel
moil	6	55	3409	2	moil
moiled	9	43	1886	2	moiled
moiler	8	40	1726	2	moiler
moils	7	61	2575	2	moils
moire	7	10	1732	2	moire
mojo	13	69	1722	2	mojo
mokes	11	46	3103	2	mokes
molal	7	51	2034	2	molal
molar	7	52	2309	2	molar
molas	7	51	3209	2	molas
molded	10	44	1408	2	molded
molder	9	38	1927	2	molder
molds	8	53	2483	2	molds
moldy	11	50	1465	2	moldy
molest	8	50	2274	2	molest
molies	8	44	2951	2	molies
moline	8	44	2203	2	moline
mollie	8	35	1710	2	mollie
molls	7	51	2978	2	molls
molly	10	52	2249	2	molly
molted	9	42	1747	2	molted
molten	8	33	1181	2	molten
molter	8	41	1942	2	molter
molto	7	56	1960	2	molto
molts	7	60	3209	2	molts
mom	7	88	5316	2	mo_m
momes	9	51	3447	2	momes
momi	8	75	2448	2	momi
moms	8	65	3948	2	moms
mon	5	75	6158	2	mo_n
monde	8	57	2314	2	monde
money	10	48	2684	2	money
monie	7	56	3165	2	monie
monk	10	59	2852	2	monk
mono	6	60	3672	2	mono
mons	6	81	5226	2	mons
monte	7	58	2977	2	monte
mony	9	68	3001	2	mony
moo	5	84	6051	2	mo_o
mood	7	63	3206	2	mood
mooed	8	51	2398	2	mooed
mool	6	75	3386	2	mool
moola	7	51	1703	2	moola
mooley	11	3	1163	2	mooley
mools	7	60	2717	2	mools
moon	6	71	4081	2	moon
moor	6	66	2855	2	moor
moos	6	60	5130	2	moos
moose	7	63	2719	2	moose
moot	6	76	5362	2	moot
mop	7	69	5082	2	mo_p
moped	10	54	2473	2	moped
moper	9	49	2592	2	moper
mopes	9	51	3498	2	mopes
mopey	12	48	2182	2	mopey
mops	8	59	4013	2	mops
mopy	11	57	2197	2	mopy
mor	5	68	5500	2	mo_r
mora	6	66	4127	2	mora
morae	7	58	3119	2	morae
morale	8	52	2055	2	morale
morel	7	57	2909	2	morel
mores	7	62	4964	2	mores
morn	6	62	3756	2	morn
mors	6	59	5006	2	mors
morse	7	60	3270	2	morse
mort	6	67	5883	2	mort
mos	5	70	6712	2	mo_s
mosey	10	59	2287	2	mosey
mosh	9	52	2760	2	mosh
mosk	10	56	2244	2	mosk
moss	6	76	4103	2	moss
most	6	65	5420	2	most
moste	7	59	2508	2	moste
mot	5	72	7942	2	mo_t
motel	7	66	2324	2	motel
motes	7	59	4400	2	motes
motet	7	56	4119	2	motet
motey	10	59	2295	2	motey
moth	9	67	3133	2	moth
motile	8	38	1834	2	motile
motley	11	3	938	2	motley
mots	6	68	5316	2	mots
mott	6	66	4844	2	mott
motte	7	55	2697	2	motte
mottle	8	41	1605	2	mottle
moues	7	57	3284	2	moues
mould	8	60	1575	2	mould
moult	7	47	2872	2	moult
mouse	7	71	3300	2	mouse
moved	11	42	1815	2	moved
mover	10	42	2086	2	mover
moves	10	61	2842	2	moves
movie	10	53	1913	2	movie
mow	8	66	5035	2	mo_w
mowed	11	36	2901	2	mowed
mower	10	45	2345	2	mower
mown	9	54	2444	2	mown
mows	9	63	4083	2	mows
moxa	13	69	1774	2	moxa
moxie	14	40	1812	2	moxie
mozo	15	77	1974	2	mozo
muled	8	58	2443	2	muled
mules	7	50	3429	2	mules
muley	10	48	1928	2	muley
mull	6	51	2880	2	mull
mure	6	59	4133	2	mure
muse	6	71	3603	2	muse
mute	6	51	3687	2	mute
myope	12	40	1097	2	myope
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
obe	5	66	3864	2	_obe
obole	7	59	1714	2	obole
ode	4	74	4658	2	_ode
oe	2	84	7306	2	_o_e
ogle	5	63	2505	2	ogle
oke	7	58	3948	2	_oke
old	4	70	3346	2	_old
olea	4	65	3272	2	_olea
oleo	4	66	3048	2	_oleo
oles	4	64	5347	2	_oles
one	3	70	5091	2	_one
ooze	13	64	2060	2	ooze
ope	5	68	4524	2	_ope
ore	3	66	6183	2	_ore
orle	4	56	3046	2	orle
ose	3	81	4734	2	_ose
osmole	8	12	851	2	osmole
owe	6	70	4103	2	_owe
pale	6	60	5501	2	pale
pele	6	55	3955	2	pele
pile	6	56	4969	2	pile
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
rale	4	50	5056	2	rale
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	6108	2	ro_e
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
rule	4	99	3842	2	rule
sale	4	49	5970	2	sale
sloe	4	55	3495	2	sloe
smile	7	48	2392	2	smile
smoke	11	50	1582	2	smoke
smolt	7	48	2416	2	smolt
smote	7	58	2028	2	smote
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	2434	2	solei
soles	5	55	4792	2	soles
soli	4	66	3701	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
tale	4	61	5416	2	tale
tele	4	50	4087	2	tele
thole	8	56	2084	2	thole
tile	4	54	5144	2	tile
toe	3	101	6685	2	to_e
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
vale	7	49	3734	2	vale
vile	7	61	3980	2	vile
voe	6	77	3905	2	vo_e
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
wale	7	45	4643	2	wale
whole	11	44	1809	2	whole
wile	7	59	4437	2	wile
woe	6	66	5124	2	wo_e
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
wyle	10	55	1938	2	wyle
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
zone	13	52	3108	2	zone

Search took 6 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	29872	1.186	150666.9
2	DLD Change Limit	29872	454	4.313	6926.0
3	Display Results	454	454	0.236	1923.7
	(SQL Overall)	178691	454	5.735	31158.0