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

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

437 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
roles	5	67	4798	(None)
boles	7	54	4860	1	boles
coles	7	60	5506	1	coles
doles	6	78	4375	1	doles
holes	8	47	4865	1	holes
joles	12	52	3083	1	joles
moles	7	47	4792	1	moles
oles	4	64	5347	1	_oles
orles	5	53	2621	1	orles
poles	7	53	5100	1	poles
proles	8	46	2720	1	proles
rales	5	49	4749	1	rales
riles	5	53	4364	1	riles
robes	7	51	3330	1	robes
robles	8	53	2169	1	robles
rodes	6	140	3908	1	rodes
roes	4	59	5414	1	ro_es
role	4	58	5182	1	role_
rolfs	8	48	1712	1	rolfs
rolls	5	53	2623	1	rolls
ropes	7	59	4006	1	ropes
roses	5	64	4577	1	roses
rotes	5	61	4390	1	rotes
roues	5	60	3935	1	roues
roves	8	48	3448	1	roves
rules	5	52	3425	1	rules
soles	5	55	4792	1	soles
toles	5	51	4713	1	toles
voles	8	62	3404	1	voles
ables	7	59	3554	2	ables
ales	4	70	6710	2	_ales
aloes	5	49	3367	2	aloes
amoles	8	41	2219	2	amoles
anoles	6	48	2743	2	anoles
areoles	7	10	1695	2	areoles
argles	7	52	1848	2	argles
arles	5	67	3574	2	arles
axles	12	52	1947	2	axles
azoles	15	46	1461	2	azoles
bales	7	62	5008	2	bales
biles	7	55	4214	2	biles
bodes	8	49	3510	2	bodes
bogles	9	50	2083	2	bogles
bolas	7	47	3376	2	bolas
bolds	8	58	2528	2	bolds
bole	6	64	4869	2	bole_
bolls	7	55	3131	2	bolls
bolos	7	55	3137	2	bolos
bolts	7	62	3211	2	bolts
bolus	7	91	2554	2	bolus
bones	7	64	4653	2	bones
bores	7	64	4825	2	bores
boules	8	49	2597	2	boules
boxes	14	56	2507	2	boxes
bromes	10	47	1976	2	bromes
broses	8	65	2440	2	broses
cobles	10	46	2288	2	cobles
codes	8	62	4729	2	codes
cokes	11	55	3719	2	cokes
colas	7	54	3677	2	colas
colds	8	57	2697	2	colds
cole	6	69	5611	2	cole_
coled	8	55	4076	2	coled
coleus	8	68	1827	2	coleus
colies	8	48	3705	2	colies
cols	6	65	5308	2	col_s
colts	7	66	3329	2	colts
comes	9	72	4699	2	comes
cones	7	64	5742	2	cones
copes	9	77	4710	2	copes
cores	7	63	6185	2	cores
coses	7	69	4949	2	coses
cotes	7	63	4784	2	cotes
coves	10	55	3917	2	coves
coxes	14	54	3086	2	coxes
cozes	16	60	3324	2	cozes
creoles	9	9	1332	2	creoles
crones	8	47	2924	2	crones
crores	8	61	2116	2	crores
crozes	17	44	1766	2	crozes
dales	6	64	3974	2	dales
deles	6	51	3925	2	deles
dholes	10	49	1479	2	dholes
does	5	65	5447	2	do_es
doges	7	56	3016	2	doges
dole	5	65	5000	2	dole_
doled	7	54	3091	2	doled
dolls	6	61	2692	2	dolls
dols	5	69	4305	2	dol_s
dolts	6	56	2631	2	dolts
domes	8	57	3556	2	domes
dopes	8	49	3504	2	dopes
doses	6	59	3850	2	doses
dotes	6	58	3669	2	dotes
doves	9	47	2815	2	doves
dozes	15	52	2630	2	dozes
drolls	7	53	1239	2	drolls
drones	7	50	2343	2	drones
droves	10	51	1667	2	droves
erodes	7	48	1988	2	erodes
eroses	6	53	2706	2	eroses
files	8	54	4127	2	files
floes	8	55	2814	2	floes
foes	7	65	4344	2	fo_es
folds	9	52	2169	2	folds
foley	11	52	2230	2	foley
foleys	12	38	1046	2	foleys
folks	12	60	1712	2	folks
folles	9	38	2047	2	folles
fores	8	58	4710	2	fores
foxes	15	63	2109	2	foxes
froes	8	61	2669	2	fro_es
gales	6	54	4248	2	gales
goes	5	56	4409	2	go_es
golds	7	54	2131	2	golds
golem	8	4	1611	2	golem
golems	9	3	932	2	golems
golfs	9	56	1610	2	golfs
gores	6	57	4037	2	gores
goxes	13	50	1826	2	goxes
gropes	9	52	2040	2	gropes
groves	10	43	1810	2	groves
gules	6	48	3104	2	gules
hales	8	54	4984	2	hales
haoles	9	49	1980	2	haoles
hoes	7	57	5573	2	ho_es
hokes	12	62	3164	2	hokes
holds	9	46	2324	2	holds
hole	7	75	5339	2	hole_
holed	9	56	3413	2	holed
holey	11	56	2690	2	holey
holies	9	46	3003	2	holies
holks	12	47	2056	2	holks
holms	10	51	1780	2	holms
hols	7	69	4629	2	hol_s
holts	8	56	2791	2	holts
homes	10	69	3882	2	homes
hones	8	81	4449	2	hones
hopes	10	58	3564	2	hopes
hoses	8	54	4318	2	hoses
howes	11	47	3026	2	howes
hoyles	12	3	1501	2	hoyles
idles	6	67	2012	2	idles
irones	6	47	2401	2	irones
isles	5	42	2056	2	isles
joes	11	66	3589	2	jo_es
jokes	16	54	2333	2	jokes
jole	11	72	3382	2	jole_
jolts	12	50	1888	2	jolts
jones	12	50	2818	2	jones
joules	13	41	1682	2	joules
kales	9	57	3098	2	kales
koels	9	46	1390	2	koels
kolas	9	48	2223	2	kolas
kolos	9	49	2121	2	kolos
les	3	56	6307	2	__les
lobes	7	53	3100	2	lobes
lodes	6	64	3691	2	lodes
loges	6	65	3420	2	loges
lolls	5	121	2173	2	lolls
lopes	7	64	3734	2	lopes
lores	5	50	4540	2	lores
loses	5	67	4201	2	loses
loves	8	53	3201	2	loves
lowes	8	57	3246	2	lowes
loxes	12	52	2747	2	loxes
males	7	50	4979	2	males
miles	7	46	4507	2	miles
modes	8	55	3741	2	modes
mokes	11	46	3103	2	mokes
molas	7	51	3209	2	molas
molds	8	53	2483	2	molds
mole	6	62	5183	2	mole_
molest	8	50	2274	2	molest
molies	8	44	2951	2	molies
molls	7	51	2978	2	molls
mols	6	59	4857	2	mol_s
molts	7	60	3209	2	molts
momes	9	51	3447	2	momes
mopes	9	51	3498	2	mopes
mores	7	62	4964	2	mores
motes	7	59	4400	2	motes
moues	7	57	3284	2	moues
moves	10	61	2842	2	moves
mules	7	50	3429	2	mules
nobles	8	33	1972	2	nobles
nodes	6	46	3349	2	nodes
noels	5	64	1870	2	noels
noes	4	58	4539	2	no_es
nolos	5	44	2335	2	nolos
nomes	7	49	3312	2	nomes
nones	5	56	3913	2	nones
noses	5	54	3564	2	noses
notes	5	50	3458	2	notes
obes	6	60	3683	2	_obes
oboles	8	38	1583	2	oboles
odes	5	72	4324	2	_odes
oes	3	58	6619	2	_o_es
ogles	6	52	2318	2	ogles
okes	8	49	3634	2	_okes
olds	5	59	2658	2	_olds
ole	3	71	5521	2	_ole_
olea	4	65	3272	2	_olea
oleo	4	66	3048	2	_oleo
oleos	5	54	1968	2	_oleos
ones	4	61	4653	2	_ones
oodles	7	35	1718	2	oodles
oozes	14	54	1871	2	oozes
opes	6	59	4261	2	_opes
ores	4	60	5668	2	_ores
orioles	7	4	1299	2	orioles
orle	4	56	3046	2	orle_
oses	4	66	4151	2	_oses
owes	7	51	3710	2	_owes
oxes	11	65	3072	2	_oxes
oyes	7	49	4013	2	_oyes
pales	7	57	5380	2	pales
paroles	9	50	2589	2	paroles
peles	7	57	3808	2	peles
piles	7	47	4261	2	piles
pokes	11	61	3301	2	pokes
pole	6	59	5130	2	pole_
poled	8	49	3484	2	poled
poleis	8	60	1835	2	poleis
poler	7	44	3179	2	poler
polers	8	42	2564	2	polers
polies	8	40	3458	2	polies
polis	7	47	3116	2	polis
polls	7	46	2772	2	polls
polos	7	61	2991	2	polos
pols	6	60	4456	2	pol_s
polys	10	57	1876	2	polys
pomes	9	48	3393	2	pomes
pones	7	45	4704	2	pones
popes	9	59	3381	2	popes
pores	7	58	4903	2	pores
poses	7	46	4276	2	poses
poxes	14	53	2572	2	poxes
probes	10	41	1945	2	probes
prole	7	45	2779	2	prole_
proleg	9	46	1211	2	proleg
prolegs	10	37	999	2	prolegs
proses	8	47	3347	2	proses
proves	11	43	2225	2	proves
pules	7	45	3881	2	pules
races	7	49	4324	2	races
rages	6	45	3944	2	rages
rajes	12	50	2278	2	rajes
rakes	9	44	4035	2	rakes
rale	4	50	5056	2	rale_
rapes	7	57	4072	2	rapes
rares	5	52	4744	2	rares
rases	5	54	4721	2	rases
rates	5	53	5201	2	rates
raves	8	54	4197	2	raves
raxes	12	47	2939	2	raxes
razes	14	50	3270	2	razes
reales	6	49	3412	2	reales
redes	6	51	3913	2	redes
reels	5	53	3326	2	reels
rees	4	53	6419	2	r_ees
reges	6	56	2879	2	reges
relet	5	47	4982	2	relet
relets	6	40	2567	2	relets
relies	6	50	3642	2	relies
res	3	55	6504	2	r__es
resoles	7	38	2365	2	resoles
rexes	12	45	2695	2	rexes
ribes	7	55	3017	2	ribes
rices	7	55	3615	2	rices
rides	6	61	4082	2	rides
riels	5	51	2133	2	riels
rifles	9	42	1771	2	rifles
rile	4	56	5054	2	rile_
riled	6	58	3325	2	riled
riley	8	44	2058	2	riley
rilles	6	47	2550	2	rilles
rills	5	50	3271	2	rills
rimes	7	56	3454	2	rimes
ripes	7	54	3577	2	ripes
rises	5	52	4404	2	rises
rites	5	44	4255	2	rites
rives	8	53	3600	2	rives
roads	6	65	2362	2	roads
roams	7	49	1961	2	roams
roans	5	49	2644	2	roans
roars	5	56	2224	2	roars
robe	6	53	3564	2	robe_
robed	8	53	2373	2	robed
roble	7	52	2302	2	roble_
robs	6	58	3787	2	ro_bs
rocks	11	46	2641	2	rocks
rocs	6	55	3366	2	ro_cs
rode	5	58	4431	2	rode_
rodeo	6	59	2109	2	rodeo
rodeos	7	53	1450	2	rodeos
rodless	8	3	1007	2	rodless
rods	5	64	4207	2	ro_ds
roe	3	68	6108	2	ro_e_
roger	6	45	2141	2	roger
rogers	7	45	1791	2	rogers
rogues	7	46	1767	2	rogues
roiled	7	43	2005	2	roiled
roils	5	48	2679	2	roils
rolf	7	51	3487	2	rol_f
rolfed	10	45	1052	2	rolfed
rolfer	9	44	1227	2	rolfer
rolfers	10	40	1181	2	rolfers
roll	4	63	3165	2	rol_l
rolled	7	42	2024	2	rolled
roller	6	39	1979	2	roller
rollers	7	31	1747	2	rollers
romeo	7	37	1970	2	romeo
romeos	8	40	1317	2	romeos
romps	9	46	1754	2	romps
roms	6	70	3896	2	ro_ms
roods	6	51	2528	2	roods
roofs	8	53	2115	2	roofs
rooks	9	53	2504	2	rooks
rooms	7	53	2468	2	rooms
roose	5	61	2709	2	roose
rooses	6	55	2624	2	rooses
rootles	7	32	1563	2	rootles
roots	5	59	3367	2	roots
rope	6	55	4291	2	rope_
roped	8	46	3081	2	roped
roper	7	54	3191	2	roper
ropers	8	43	2590	2	ropers
ropey	10	60	2187	2	ropey
roques	15	49	1256	2	roques
rose	4	61	4890	2	rose_
rosed	6	59	3035	2	rosed
roset	5	59	4524	2	roset
rosets	6	58	1995	2	rosets
rotas	5	48	2772	2	rotas
rote	4	62	4902	2	rote_
rotis	5	63	2706	2	rotis
rotls	5	56	2016	2	rotls
rotos	5	60	2788	2	rotos
rots	4	64	5409	2	ro_ts
rottes	6	45	2483	2	rottes
roubles	9	34	1351	2	roubles
roue	4	59	4174	2	roue_
rouen	5	49	2090	2	rouen
rouens	6	48	1444	2	rouens
rouges	7	60	2238	2	rouges
roups	7	51	1890	2	roups
rouse	5	66	3470	2	rouse
rouses	6	54	3628	2	rouses
routes	6	61	2931	2	routes
routs	5	71	3341	2	routs
rove	7	51	3698	2	rove_
roved	9	53	2355	2	roved
roven	8	55	2197	2	roven
rover	8	55	2737	2	rover
rovers	9	54	2352	2	rovers
rowed	9	40	3432	2	rowed
rowel	8	47	2141	2	rowel
rowels	9	45	1545	2	rowels
rowen	8	49	2115	2	rowen
rowens	9	45	1530	2	rowens
rower	8	54	3049	2	rower
rowers	9	49	2457	2	rowers
rows	7	59	4175	2	ro_ws
rubes	7	49	2841	2	rubes
rubles	8	39	2170	2	rubles
rues	4	60	4448	2	r_ues
rule	4	99	3842	2	rule_
ruled	6	58	2252	2	ruled
ruler	5	49	2334	2	ruler
rulers	6	43	1709	2	rulers
runes	5	55	3022	2	runes
ruses	5	61	3658	2	ruses
ryes	7	55	2935	2	r_yes
rykes	12	55	1303	2	rykes
sales	5	60	5559	2	sales
sloes	5	47	2887	2	sloes
socles	8	4	1845	2	socles
sokes	9	50	3142	2	sokes
sole	4	60	5367	2	sole_
soled	6	58	3517	2	soled
solei	5	56	2434	2	solei
soleus	6	46	1561	2	soleus
solos	5	48	3079	2	solos
sols	4	54	4816	2	sol_s
solus	5	47	2698	2	solus
solves	9	50	1822	2	solves
sones	5	54	4414	2	sones
sores	5	54	5428	2	sores
stoles	6	39	2767	2	stoles
tales	5	54	5137	2	tales
teles	5	45	3600	2	teles
tholes	9	49	1978	2	tholes
tiles	5	55	4210	2	tiles
toes	4	69	5644	2	to_es
toiles	6	39	2351	2	toiles
tokes	9	52	3497	2	tokes
tolas	5	45	3277	2	tolas
tole	4	60	5290	2	tole_
toled	6	59	3492	2	toled
tolls	5	47	2843	2	tolls
tolus	5	50	2448	2	tolus
tomes	7	60	3738	2	tomes
tones	5	60	4866	2	tones
topes	7	69	4176	2	topes
tores	5	53	5267	2	tores
totes	5	51	3968	2	totes
trokes	10	40	1926	2	trokes
trolls	6	46	1394	2	trolls
trones	6	56	2928	2	trones
tropes	8	48	2435	2	tropes
troves	9	47	1911	2	troves
tules	5	45	3279	2	tules
vales	8	54	3426	2	vales
voces	10	59	1805	2	voces
voes	7	54	3282	2	vo_es
voiles	9	46	1644	2	voiles
vole	7	52	3698	2	vole_
voled	9	53	2372	2	voled
voltes	9	49	1558	2	voltes
volts	8	54	2129	2	volts
votes	8	46	2708	2	votes
wales	8	61	4284	2	wales
wholes	12	46	1677	2	wholes
wiles	8	54	3787	2	wiles
woes	7	64	4066	2	wo_es
wolds	9	54	2018	2	wolds
wolfs	11	62	1416	2	wolfs
wolves	12	45	1085	2	wolves
wyles	11	46	1532	2	wyles
yodles	10	37	1433	2	yodles
yokes	12	52	2302	2	yokes
yolks	12	54	1277	2	yolks
yores	8	50	3132	2	yores
yowes	11	49	2637	2	yowes
yules	8	45	2158	2	yules
zones	14	55	2804	2	zones

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	53800	0.313	570897.8
2	DLD Change Limit	53800	437	1.466	36698.5
3	Display Results	437	437	0.126	3468.3
	(SQL Overall)	178691	437	1.905	93801.0