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

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

425 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
file	7	54	4664	(None)
bile	6	61	4718	1	bile
fice	9	57	3711	1	fice
fie	6	71	5244	1	fi_e
fife	10	60	2770	1	fife
fil	6	54	4714	1	fil_
fila	7	47	2913	1	fila
filed	9	53	3190	1	filed
filer	8	54	3300	1	filer
files	8	54	4127	1	files
filet	8	55	4016	1	filet
fill	7	55	4019	1	fill
fille	8	43	2740	1	fille
film	9	48	2817	1	film
filo	7	60	3428	1	filo
fils	7	58	3869	1	fils
fine	7	51	4795	1	fine
fire	7	62	4559	1	fire
five	10	76	2974	1	five
mile	6	63	5257	1	mile
pile	6	56	4969	1	pile
rile	4	56	5053	1	rile
tile	4	54	5144	1	tile
vile	7	61	3980	1	vile
wile	7	59	4437	1	wile
able	6	63	4053	2	able
afire	8	62	1591	2	afire
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
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	4149	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
defile	10	52	1666	2	defile
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
fable	10	58	2475	2	fable
face	9	61	4012	2	face
facile	11	25	1488	2	facile
fade	8	57	3634	2	fade
fail	7	48	4024	2	fail_
failed	10	54	2160	2	failed
faille	9	34	1474	2	faille
fails	8	56	3148	2	fails
fake	11	55	3494	2	fake
fall	7	55	3531	2	fall
false	8	48	1812	2	false
falx	14	71	2078	2	falx
fame	9	56	3939	2	fame
fane	7	53	4357	2	fane
fare	7	63	5446	2	fare
farle	8	69	2924	2	farle
fate	7	54	4428	2	fate
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
fe	5	79	4474	2	f__e
fee	6	68	6201	2	f_ee
feel	7	52	3384	2	feel
fell	7	68	3307	2	fell
felt	7	51	4693	2	felt
feme	9	61	3054	2	feme
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
fiar	7	64	2733	2	fiar
fiat	7	66	4664	2	fiat
fib	8	63	4427	2	fi_b
fiber	10	49	2113	2	fiber
fibre	10	48	1284	2	fibre
fibs	9	63	2950	2	fibs
fices	10	60	3116	2	fices
fiche	13	46	1674	2	fiche
fickle	15	39	1297	2	fickle
fico	9	58	2459	2	fico
fid	7	68	4769	2	fi_d
fiddle	11	36	1338	2	fiddle
fidge	10	45	1606	2	fidge
fido	8	77	2640	2	fido
fids	8	70	3474	2	fids
fief	10	73	3136	2	fief
field	9	50	1532	2	field
fifed	12	51	1597	2	fifed
fifer	11	55	1997	2	fifer
fifes	11	48	2239	2	fifes
fig	7	62	4283	2	fi_g
figs	8	53	3264	2	figs
filar	8	48	1929	2	filar
filch	13	48	1332	2	filch
filers	9	46	2372	2	filers
filets	9	47	1895	2	filets
filled	10	49	2226	2	filled
filler	9	46	2362	2	filler
filles	9	42	2452	2	filles
fillet	9	50	2708	2	fillet
fillo	8	43	1978	2	fillo
fills	8	46	3237	2	fills
filly	11	44	2490	2	filly
filmed	12	46	1036	2	filmed
filmer	11	41	1240	2	filmer
filmi	10	59	1400	2	filmi
films	10	56	1796	2	films
filmy	13	61	1404	2	filmy
filos	8	61	2538	2	filos
filose	9	61	1250	2	filose
filter	9	45	1763	2	filter
filth	11	50	1582	2	filth
filum	10	50	1543	2	filum
fimble	13	36	1175	2	fimble
fin	6	64	5803	2	fi_n
finale	9	41	1676	2	finale
find	8	75	3260	2	find
fined	9	49	3050	2	fined
finer	8	54	3156	2	finer
fines	8	66	4426	2	fines
fink	11	75	3212	2	fink
fino	7	60	3469	2	fino
fins	7	58	4909	2	fins
fipple	13	32	906	2	fipple
fique	17	3	914	2	fique
fir	6	67	4489	2	fi_r
fired	9	48	2974	2	fired
firer	8	112	2925	2	firer
fires	8	57	4075	2	fires
firm	9	60	2645	2	firm
firn	7	69	2750	2	firn
firs	7	66	3771	2	firs
fisc	9	68	1975	2	fisc
fish	10	69	2627	2	fish
fist	7	62	4842	2	fist
fit	6	63	6545	2	fi_t
fitly	11	51	1497	2	fitly
fits	7	60	4346	2	fits
fiver	11	60	2494	2	fiver
fives	11	60	2736	2	fives
fix	13	62	3610	2	fi_x
fixed	16	54	1695	2	fixed
fixer	15	47	1783	2	fixer
fixes	15	47	2359	2	fixes
fixt	14	107	2971	2	fixt
fiz	15	62	3876	2	fi_z
fizz	15	75	1982	2	fizz
fizzle	17	36	971	2	fizzle
flea	7	56	2849	2	f_lea
fled	8	54	2977	2	f_led
flee	7	62	3879	2	flee
flew	10	58	2425	2	f_lew
flex	14	61	2347	2	f_lex
fley	10	66	2685	2	f_ley
flic	9	62	2373	2	flic
flied	9	65	1943	2	flied
flier	8	60	2340	2	flier
flies	8	56	3071	2	flies
flip	9	63	2426	2	flip
flir	7	64	2220	2	flir
flit	7	65	3927	2	flit
flite	8	54	2496	2	flite
floe	7	61	2977	2	floe
flu	6	65	3021	2	f_lu
flue	7	53	2985	2	flue
fly	9	71	2495	2	f_ly
foe	6	63	5081	2	f_oe
foible	11	4	1038	2	foible
foil	7	64	3391	2	foil_
foiled	10	46	1840	2	foiled
foils	8	50	2581	2	foils
fold	8	65	2894	2	fold
foley	11	52	2230	2	foley
folk	11	60	2154	2	folk
fore	7	83	5147	2	fore
frae	7	53	3047	2	frae
free	7	59	4018	2	free
frill	8	49	1756	2	frill
frise	8	53	2245	2	frise
froe	7	53	2999	2	froe
fuel	7	68	2473	2	fuel
fugle	9	49	1554	2	fugle
full	7	52	2915	2	full
fume	9	67	2763	2	fume
fuse	7	64	2999	2	fuse
fusile	9	43	1349	2	fusile
futile	9	39	1495	2	futile
fuze	16	64	2237	2	fuze
fyce	12	63	1683	2	fyce
fyke	14	59	1529	2	fyke
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
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
maile	7	52	3222	2	maile
male	6	60	5230	2	male
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
mole	6	62	5183	2	mole
mule	6	52	3697	2	mule
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
refile	9	51	2237	2	refile
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
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
smile	7	48	2392	2	smile
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.266	671770.7
2	DLD Change Limit	29872	425	0.843	35435.3
3	Display Results	425	425	0.093	4569.9
	(SQL Overall)	178691	425	1.202	148661.4