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

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

452 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
mile	6	63	5257	(None)
bile	6	61	4718	1	bile
file	7	54	4664	1	file
maile	7	52	3222	1	maile
male	6	60	5230	1	male
mice	8	74	4223	1	mice
mike	10	55	3529	1	mike
mil	5	57	5211	1	mil_
mild	7	53	3085	1	mild
miler	7	57	3306	1	miler
miles	7	46	4507	1	miles
milk	10	50	2847	1	milk
mill	6	65	4148	1	mill
mille	7	50	2913	1	mille
milo	6	55	3610	1	milo
mils	6	60	4533	1	mils
milt	6	54	5581	1	milt
mime	8	57	3640	1	mime
mine	6	72	5617	1	mine
mire	6	67	4823	1	mire
mise	6	60	4358	1	mise
mite	6	62	4941	1	mite
mole	6	62	5183	1	mole
mule	6	52	3697	1	mule
pile	6	56	4969	1	pile
rile	4	56	5053	1	rile
smile	7	48	2392	1	smile
tile	4	54	5144	1	tile
vile	7	61	3980	1	vile
wile	7	59	4437	1	wile
able	6	63	4053	2	able
agile	6	51	2226	2	agile
aide	5	60	4500	2	aide
ail	3	71	7104	2	ail_
ailed	6	62	4028	2	ailed
ails	4	56	5471	2	ails
aisle	5	52	2319	2	aisle
ale	3	65	7234	2	_ale
amble	9	59	2464	2	amble
amice	9	61	2287	2	amice
amide	8	61	2848	2	amide
amie	6	63	3985	2	ami_e
amine	7	58	3538	2	amine
amole	7	57	2459	2	amole
ample	9	47	2030	2	ample
anile	5	46	3446	2	anile
axile	12	60	2051	2	axile
axle	11	64	2460	2	axle
bale	6	63	5384	2	bale
bible	9	51	1942	2	bible
bice	8	62	3556	2	bice
bide	7	60	4150	2	bide
bike	10	65	3260	2	bike
biles	7	55	4214	2	biles
bilge	8	76	1891	2	bilge
bilk	10	58	2442	2	bilk
bill	6	72	3994	2	bill
bine	6	66	5086	2	bine
birle	7	50	2363	2	birle
bise	6	64	3710	2	bise
bite	6	65	4700	2	bite
bize	15	59	2629	2	bize
bole	6	64	4869	2	bole
chile	10	56	2689	2	chile
cine	6	62	4294	2	cine
cire	6	58	3637	2	cire
cite	6	56	4034	2	cite
cole	6	69	5611	2	cole
dale	5	56	4398	2	dale
dele	5	68	4308	2	dele
dice	7	58	4189	2	dice
die	4	67	5965	2	di_e
diel	5	90	3460	2	diel
dike	9	59	3576	2	dike
dill	5	52	3997	2	dill
dime	7	62	3764	2	dime
dine	5	55	5533	2	dine
dire	5	66	4414	2	dire
dite	5	55	4755	2	dite
dive	8	56	3477	2	dive
dole	5	65	5000	2	dole
edile	6	48	1949	2	edile
eide	5	58	3224	2	eide
exile	12	61	1765	2	exile
fice	9	57	3711	2	fice
fie	6	71	5244	2	fi_e
fife	10	60	2770	2	fife
fil	6	54	4714	2	fil_
fila	7	47	2913	2	fila
filed	9	53	3190	2	filed
filer	8	54	3300	2	filer
files	8	54	4127	2	files
filet	8	55	4016	2	filet
fill	7	55	4019	2	fill
fille	8	43	2740	2	fille
film	9	48	2817	2	film
filo	7	60	3428	2	filo
fils	7	58	3869	2	fils
fine	7	51	4795	2	fine
fire	7	62	4559	2	fire
five	10	76	2974	2	five
gale	5	63	4732	2	gale
gibe	7	59	2778	2	gibe
gie	4	71	4954	2	gi_e
gild	6	55	2651	2	gild
gill	5	63	3618	2	gill
gilt	5	63	4854	2	gilt
gite	5	54	3861	2	gite
give	8	58	2935	2	give
guile	6	45	2113	2	guile
hale	7	60	5283	2	hale
hide	8	51	3464	2	hide
hie	6	76	5270	2	hi_e
hike	11	68	3039	2	hike
hila	7	62	2835	2	hila
hili	7	56	2663	2	hili
hill	7	64	3949	2	hill
hilt	7	58	5071	2	hilt
hire	7	55	3896	2	hire
hive	10	60	2967	2	hive
hole	7	75	5339	2	hole
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
imide	8	57	1689	2	imide
imine	7	58	2106	2	imine
ire	3	69	4317	2	_ire
isle	4	51	2170	2	isle
jibe	13	63	2339	2	jibe
jill	11	64	3026	2	jill
jilt	11	58	3942	2	jilt
jive	14	61	2359	2	jive
jole	11	72	3382	2	jole
kale	8	65	3375	2	kale
kibe	10	65	2345	2	kibe
kike	7	65	2479	2	kike
kill	8	55	3318	2	kill
kiln	8	56	2098	2	kiln
kilo	8	60	2867	2	kilo
kilt	8	61	4442	2	kilt
kine	8	56	4343	2	kine
kite	8	53	3824	2	kite
lice	6	60	4506	2	lice
lie	3	82	6452	2	li_e
life	7	54	3373	2	life
like	8	60	4084	2	like
lilo	4	67	3156	2	lilo
lilt	4	63	4994	2	lilt
lily	7	67	3018	2	lily
lime	6	62	4493	2	lime
line	4	69	6557	2	line
lipe	6	68	3973	2	lipe
lire	4	78	4529	2	lire
lisle	5	39	1672	2	lisle
lite	4	70	5454	2	lite
live	7	65	4099	2	live
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
mail	6	55	4345	2	mail_
mailed	9	53	2675	2	mailed
mailer	8	47	2418	2	mailer
mailes	8	43	2911	2	mailes
maill	7	44	2079	2	maill
mails	7	60	3778	2	mails
maize	16	46	1856	2	maize
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
meikle	12	3	665	2	meikle
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
mi	4	82	4905	2	mi__
mib	7	69	4612	2	mi_b
mibs	8	53	3048	2	mibs
mic	7	76	4764	2	mi_c
mica	8	64	2825	2	mica
miche	12	62	1924	2	miche
mick	12	63	3343	2	mick
mickle	14	37	1513	2	mickle
mics	8	74	3515	2	mics
mid	6	73	5447	2	mi_d
middle	10	34	1498	2	middle
midge	9	50	1655	2	midge
midi	7	56	2848	2	midi
midleg	10	3	855	2	midleg
mids	7	65	4179	2	mids
mien	6	50	2836	2	mien
miff	12	56	2506	2	miff
mig	6	56	4608	2	mi_g
migg	8	57	1680	2	migg
miggle	10	40	1211	2	miggle
migs	7	69	3532	2	migs
miked	12	50	2045	2	miked
mikes	11	51	2989	2	mikes
milage	9	34	1412	2	milage
milch	12	44	1337	2	milch
milded	10	44	1615	2	milded
milden	9	41	1315	2	milden
milder	9	38	1845	2	milder
mildew	12	31	904	2	mildew
milds	8	64	2205	2	milds
milers	8	46	2516	2	milers
milia	7	27	1957	2	milia
milieu	8	3	1411	2	milieu
milked	13	46	1257	2	milked
milker	12	48	1432	2	milker
milks	11	50	2058	2	milks
milky	14	40	1444	2	milky
milled	9	43	2617	2	milled
miller	8	46	2541	2	miller
milles	8	45	2656	2	milles
millet	8	40	3074	2	millet
mills	7	54	3505	2	mills
milneb	10	9	595	2	milneb
milos	7	54	2801	2	milos
milpa	9	21	1140	2	milpa
milted	9	39	1994	2	milted
milter	8	49	2123	2	milter
milts	7	54	3071	2	milts
milty	10	47	2007	2	milty
mim	7	60	4842	2	mi_m
mimed	10	56	2273	2	mimed
mimeo	9	60	1868	2	mimeo
mimer	9	48	2576	2	mimer
mimes	9	57	3202	2	mimes
mina	6	51	3692	2	mina
minae	7	56	2772	2	minae
mince	9	53	2523	2	mince
mind	7	54	3438	2	mind
mined	8	53	3335	2	mined
miner	7	69	3354	2	miner
mines	7	56	5195	2	mines
mingle	9	35	1878	2	mingle
mini	6	56	3456	2	mini
mink	10	66	3653	2	mink
minke	11	54	2176	2	minke
mint	6	67	5806	2	mint
minx	13	77	2335	2	minx
mips	8	55	3408	2	mips
mir	5	70	4677	2	mi_r
mired	8	57	2922	2	mired
mires	7	56	4088	2	mires
mirex	14	68	1662	2	mirex
miri	6	67	3037	2	miri
mirk	10	67	2950	2	mirk
mirs	6	69	4057	2	mirs
miry	9	63	2675	2	miry
mis	5	81	6262	2	mi_s
miser	7	54	3040	2	miser
mises	7	47	4056	2	mises
misled	9	47	1931	2	misled
mislie	8	32	1915	2	mislie
miso	6	72	2990	2	miso
miss	6	53	3942	2	miss
mist	6	61	5453	2	mist
miter	7	57	3479	2	miter
mites	7	51	4180	2	mites
mitre	7	55	2242	2	mitre
mitt	6	61	4549	2	mitt
mity	9	55	2821	2	mity
mix	12	61	3818	2	mi_x
mixed	15	57	1725	2	mixed
mixer	14	50	1764	2	mixer
mixes	14	72	2440	2	mixes
mixt	13	68	3192	2	mixt
mizen	16	48	1527	2	mizen
mizzle	16	27	999	2	mizzle
mobile	10	36	1354	2	mobile
mode	7	58	4030	2	mode
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
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
motile	8	38	1834	2	motile
moue	6	58	3557	2	moue
move	9	66	3072	2	move
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
nice	6	55	3471	2	nice
nide	5	55	3579	2	nide
nil	3	61	4419	2	nil_
nill	4	56	3430	2	nill
nils	4	61	3245	2	nils
nine	4	58	4217	2	nine
nite	4	59	4358	2	nite
nixe	11	57	2202	2	nixe
ogle	5	63	2505	2	ogle
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
ole	3	71	5521	2	_ole
orle	4	56	3046	2	orle
pale	6	60	5501	2	pale
pele	6	55	3955	2	pele
pice	8	46	4109	2	pice
pie	5	54	5740	2	pi_e
pike	10	63	3521	2	pike
pilea	7	51	2395	2	pilea
piled	8	52	3299	2	piled
pilei	7	40	2178	2	pilei
piles	7	47	4261	2	piles
pili	6	61	3035	2	pili
pill	6	53	3946	2	pill
pily	9	61	3273	2	pily
pine	6	77	5571	2	pine
pipe	8	64	3443	2	pipe
plie	6	51	2739	2	plie
pole	6	59	5130	2	pole
pule	6	50	4095	2	pule
rale	4	50	5056	2	rale
rice	6	49	4291	2	rice
ride	5	59	4513	2	ride
riel	4	64	3238	2	riel
rife	7	46	3232	2	rife
rifle	8	55	1833	2	rifle
riled	6	58	3325	2	riled
riles	5	53	4364	2	riles
riley	8	44	2058	2	riley
rill	4	51	4090	2	rill
rille	5	57	2873	2	rille
rime	6	51	3888	2	rime
ripe	6	60	3892	2	ripe
rise	4	59	4523	2	rise
rite	4	58	4945	2	rite
rive	7	55	3772	2	rive
role	4	58	5182	2	role
rule	4	99	3842	2	rule
sale	4	49	5970	2	sale
sice	6	55	4559	2	sice
side	5	54	4449	2	side
sidle	6	51	2403	2	sidle
sike	8	71	3878	2	sike
sild	5	50	3058	2	sild
silex	12	34	1741	2	silex
silk	8	55	2932	2	silk
sill	4	55	4515	2	sill
silo	4	60	3791	2	silo
silt	4	65	5819	2	silt
simile	8	31	1563	2	simile
sine	4	65	6062	2	sine
sipe	6	73	4104	2	sipe
sire	4	61	5041	2	sire
site	4	70	5241	2	site
size	13	56	3096	2	size
smiled	9	37	1643	2	smiled
smiler	8	39	1668	2	smiler
smiles	8	45	2229	2	smiles
smiley	11	40	1230	2	smiley
smite	7	52	2487	2	smite
sole	4	60	5367	2	sole
spile	7	52	3008	2	spile
stile	5	49	3157	2	stile
tale	4	61	5416	2	tale
tele	4	50	4087	2	tele
tide	5	52	3738	2	tide
tie	3	65	5753	2	ti_e
tike	8	55	3448	2	tike
til	3	63	5026	2	til_
tilde	6	50	1734	2	tilde
tiled	6	48	3294	2	tiled
tiler	5	61	3102	2	tiler
tiles	5	55	4210	2	tiles
till	4	59	4120	2	till
tils	4	57	3961	2	tils
tilt	4	62	5242	2	tilt
time	6	62	3501	2	time
tine	4	58	5513	2	tine
tire	4	61	4335	2	tire
title	5	47	2107	2	title
toile	5	46	2649	2	toile
tole	4	60	5290	2	tole
tule	4	57	3587	2	tule
utile	5	47	1893	2	utile
vale	7	49	3734	2	vale
vibe	9	51	2450	2	vibe
vice	9	57	3285	2	vice
vide	8	54	3276	2	vide
vie	6	54	4763	2	vi_e
viler	8	63	2416	2	viler
vill	7	52	3507	2	vill
vine	7	56	4368	2	vine
vise	7	56	3267	2	vise
vive	10	54	2662	2	vive
voile	8	47	1972	2	voile
vole	7	52	3698	2	vole
wale	7	45	4643	2	wale
while	11	54	1869	2	while
wide	8	52	3541	2	wide
wife	10	52	2802	2	wife
wild	8	51	2651	2	wild
wiled	9	52	3155	2	wiled
wiles	8	54	3787	2	wiles
will	7	57	3751	2	will
wilt	7	62	4629	2	wilt
wily	10	64	2881	2	wily
wine	7	49	5342	2	wine
wipe	9	48	3028	2	wipe
wire	7	58	3981	2	wire
wise	7	57	3734	2	wise
wite	7	54	4327	2	wite
wive	10	59	3175	2	wive
wyle	10	55	1938	2	wyle
yill	7	56	2897	2	yill
yipe	9	67	2218	2	yipe
yule	7	57	2514	2	yule
zill	13	57	2761	2	zill
zine	13	70	3615	2	zine

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	29872	0.280	638182.1
2	DLD Change Limit	29872	452	0.906	32971.3
3	Display Results	452	452	0.110	4109.1
	(SQL Overall)	178691	452	1.296	137878.9