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

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

470 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
fils	7	58	3870	(None)
ails	4	56	5472	1	ails
fails	8	56	3148	1	fails
fibs	9	63	2951	1	fibs
fids	8	70	3475	1	fids
figs	8	53	3265	1	figs
fil	6	54	4715	1	fil_
fila	7	47	2914	1	fila
file	7	54	4665	1	file
files	8	54	4127	1	files
fill	7	55	4020	1	fill
fills	8	46	3237	1	fills
film	9	48	2818	1	film
films	10	56	1796	1	films
filo	7	60	3429	1	filo
filos	8	61	2538	1	filos
fins	7	58	4910	1	fins
firs	7	66	3772	1	firs
fits	7	60	4347	1	fits
foils	8	50	2581	1	foils
mils	6	60	4534	1	mils
nils	4	61	3246	1	nils
oils	4	63	3798	1	oils
tils	4	57	3962	1	tils
aals	4	99	4114	2	aals
aids	5	78	4637	2	aids
ail	3	71	7105	2	ail_
aims	6	77	3819	2	aims
ains	4	61	5889	2	ains
airs	4	64	4743	2	airs
ais	3	90	8358	2	ai_s
aits	4	63	5554	2	aits
alls	4	67	4092	2	alls
als	3	66	6302	2	_als
anils	5	63	2672	2	anils
arils	5	87	3220	2	arils
awls	7	59	2609	2	awls
axils	12	72	1750	2	axils
bails	7	59	3352	2	bails
bals	6	63	5404	2	bals
bels	6	61	4249	2	bels
bias	6	47	3817	2	bias
bibs	8	48	3100	2	bibs
bids	7	58	3846	2	bids
bigs	7	62	3503	2	bigs
bile	6	61	4719	2	bile
biles	7	55	4214	2	biles
bilk	10	58	2443	2	bilk
bilks	11	51	1789	2	bilks
bill	6	72	3995	2	bill
bills	7	56	3286	2	bills
bins	6	65	4826	2	bins
bios	6	63	3533	2	bios
birls	7	40	2316	2	birls
bis	5	68	6067	2	bi_s
bits	6	61	4817	2	bits
boils	7	54	2719	2	boils
ceils	7	50	1940	2	ceils
cels	6	55	3497	2	cels
cigs	7	56	2511	2	cigs
cis	5	77	4804	2	ci_s
coils	7	50	3008	2	coils
cols	6	65	5308	2	cols
dals	5	71	4512	2	dals
deils	6	57	2286	2	deils
dels	5	67	4547	2	dels
dials	6	49	2534	2	dials
dibs	7	62	3369	2	dibs
dies	5	56	5353	2	dies
difs	8	60	2733	2	difs
digs	6	60	3606	2	digs
dill	5	52	3998	2	dill
dills	6	55	3097	2	dills
dims	7	54	3503	2	dims
dins	5	66	5205	2	dins
diols	6	55	2101	2	diols
dips	7	55	3692	2	dips
dirls	6	47	2050	2	dirls
dis	4	64	5990	2	di_s
diss	5	64	3449	2	diss
dits	5	64	5053	2	dits
dols	5	69	4305	2	dols
eels	4	65	3674	2	eels
ells	4	64	3135	2	ells
els	3	76	4572	2	_els
evils	8	41	1426	2	evils
fabs	9	86	3586	2	fabs
fads	8	69	3988	2	fads
fags	8	69	3912	2	fags
fail	7	48	4024	2	fail_
fairs	8	58	2544	2	fairs
fall	7	55	3531	2	fall
falls	8	57	2765	2	falls
false	8	48	1812	2	false
falx	14	71	2078	2	falx
fans	7	62	4737	2	fans
farls	8	57	3111	2	farls
fas	6	82	6293	2	f_as
fats	7	62	5250	2	fats
fays	10	85	3536	2	fays
feds	8	52	3432	2	feds
feels	8	52	2304	2	feels
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fell	7	68	3307	2	fell
fells	8	53	2738	2	fells
felt	7	51	4693	2	felt
felts	8	53	2454	2	felts
fems	9	64	2870	2	fems
fens	7	61	3976	2	fens
fes	6	65	5167	2	f_es
fess	7	65	2916	2	fess
fets	7	53	4594	2	fets
feus	7	58	3075	2	feus
fiar	7	64	2734	2	fiar
fiars	8	67	2083	2	fiars
fiat	7	66	4665	2	fiat
fiats	8	53	2448	2	fiats
fib	8	63	4428	2	fi_b
fice	9	57	3712	2	fice
fices	10	60	3116	2	fices
fico	9	58	2460	2	fico
ficus	10	50	1549	2	ficus
fid	7	68	4770	2	fi_d
fido	8	77	2641	2	fido
fidos	9	58	1906	2	fidos
fie	6	71	5245	2	fi_e
fief	10	73	3137	2	fief
fiefs	11	62	1370	2	fiefs
field	9	50	1532	2	field
fields	10	42	1104	2	fields
fife	10	60	2771	2	fife
fifes	11	48	2239	2	fifes
fig	7	62	4284	2	fi_g
filar	8	48	1929	2	filar
filch	13	48	1332	2	filch
filed	9	53	3190	2	filed
filer	8	54	3300	2	filer
filers	9	46	2372	2	filers
filet	8	55	4016	2	filet
filets	9	47	1895	2	filets
fille	8	43	2740	2	fille
filles	9	42	2452	2	filles
fillo	8	43	1978	2	fillo
fillos	9	44	1508	2	fillos
filly	11	44	2490	2	filly
filmi	10	59	1400	2	filmi
filmis	11	46	1028	2	filmis
filmy	13	61	1404	2	filmy
filose	9	61	1250	2	filose
filth	11	50	1582	2	filth
filths	12	38	978	2	filths
filum	10	50	1543	2	filum
fin	6	64	5804	2	fi_n
finals	9	43	1616	2	finals
find	8	75	3261	2	find
finds	9	54	2483	2	finds
fine	7	51	4796	2	fine
fines	8	66	4426	2	fines
finis	8	68	2426	2	finis
fink	11	75	3213	2	fink
finks	12	54	2422	2	finks
fino	7	60	3470	2	fino
finos	8	62	2695	2	finos
fir	6	67	4490	2	fi_r
fire	7	62	4560	2	fire
fires	8	57	4075	2	fires
firm	9	60	2646	2	firm
firms	10	52	1742	2	firms
firn	7	69	2751	2	firn
firns	8	60	1854	2	firns
first	8	62	2612	2	first
fisc	9	68	1976	2	fisc
fiscs	10	53	1188	2	fiscs
fish	10	69	2628	2	fish
fist	7	62	4843	2	fist
fists	8	55	2754	2	fists
fit	6	63	6546	2	fi_t
fitly	11	51	1497	2	fitly
five	10	76	2975	2	five
fives	11	60	2736	2	fives
fix	13	62	3611	2	fi_x
fixes	15	47	2359	2	fixes
fixt	14	107	2972	2	fixt
fiz	15	62	3877	2	fi_z
fizz	15	75	1983	2	fizz
flails	9	43	1300	2	flails
flic	9	62	2373	2	flic
flics	10	54	1836	2	flics
flies	8	56	3071	2	flies
flip	9	63	2426	2	flip
flips	10	51	1774	2	flips
flir	7	64	2220	2	flir
flirs	8	55	1893	2	flirs
flit	7	65	3927	2	flit
flits	8	56	2522	2	flits
flu	6	65	3021	2	f_lu
flus	7	56	2654	2	flus
fly	9	71	2495	2	f_ly
foals	8	57	2169	2	foals
fobs	9	60	3427	2	fobs
foes	7	65	4344	2	foes
fogs	8	70	3500	2	fogs
foil	7	64	3391	2	foil_
foins	8	55	2338	2	foins
fold	8	65	2894	2	fold
folds	9	52	2169	2	folds
folk	11	60	2154	2	folk
folks	12	60	1712	2	folks
fons	7	69	4389	2	fons
fools	8	68	2420	2	fools
fops	9	65	3268	2	fops
foss	7	64	3164	2	foss
fouls	8	72	2143	2	fouls
fowls	11	55	1889	2	fowls
foys	10	56	2829	2	foys
frails	9	37	1647	2	frails
fries	8	55	3560	2	fries
frigs	9	60	1927	2	frigs
frill	8	49	1756	2	frill
frills	9	44	1422	2	frills
frits	8	61	2910	2	frits
fubs	9	63	2879	2	fubs
fuds	8	65	2857	2	fuds
fuels	8	71	1735	2	fuels
fugs	8	57	3069	2	fugs
full	7	52	2915	2	full
fulls	8	46	2352	2	fulls
funs	7	52	3573	2	funs
furls	8	53	2205	2	furls
furs	7	67	3504	2	furs
fusils	9	39	1234	2	fusils
fuss	7	60	2793	2	fuss
fuzils	18	40	796	2	fuzils
gals	5	79	4650	2	gals
gels	5	68	3610	2	gels
gibs	7	55	2928	2	gibs
gids	6	59	3375	2	gids
gies	5	56	4143	2	gies
gigs	6	66	3119	2	gigs
gild	6	55	2652	2	gild
gilds	7	54	1753	2	gilds
gill	5	63	3619	2	gill
gills	6	47	2819	2	gills
gilt	5	63	4855	2	gilt
gilts	6	49	2426	2	gilts
gins	5	55	4396	2	gins
gips	7	56	3293	2	gips
girls	6	45	1839	2	girls
gits	5	57	4460	2	gits
guls	5	59	3085	2	guls
hails	8	52	3164	2	hails
heils	8	52	2219	2	heils
hies	7	48	4284	2	hies
hila	7	62	2836	2	hila
hili	7	56	2664	2	hili
hill	7	64	3950	2	hill
hills	8	54	3135	2	hills
hilt	7	58	5072	2	hilt
hilts	8	69	2441	2	hilts
hilus	8	48	1764	2	hilus
hims	9	52	3098	2	hims
hins	7	64	4800	2	hins
hips	9	64	3371	2	hips
his	6	63	5951	2	hi_s
hiss	7	56	2922	2	hiss
hits	7	55	4514	2	hits
hols	7	69	4629	2	hols
ids	4	75	3548	2	_ids
ifs	6	71	2425	2	_ifs
ilk	7	83	2531	2	_ilk
ilks	8	72	1857	2	_ilks
ill	3	74	3710	2	_ill
ills	4	70	3042	2	ills
ins	3	59	4561	2	_ins
is	2	70	4822	2	_i_s
its	3	55	3884	2	_its
jails	12	54	2294	2	jails
jibs	13	67	2409	2	jibs
jigs	12	65	2477	2	jigs
jill	11	64	3027	2	jill
jills	12	51	2282	2	jills
jilt	11	58	3943	2	jilt
jilts	12	47	1741	2	jilts
jins	11	56	3502	2	jins
kails	9	55	2522	2	kails
kids	9	60	2965	2	kids
kifs	11	60	2352	2	kifs
kill	8	55	3319	2	kill
kills	9	45	2618	2	kills
kiln	8	56	2099	2	kiln
kilns	9	51	1299	2	kilns
kilo	8	60	2868	2	kilo
kilos	9	50	2148	2	kilos
kilt	8	61	4443	2	kilt
kilts	9	51	2219	2	kilts
kins	8	57	4792	2	kins
kips	10	64	3053	2	kips
kirs	8	58	3175	2	kirs
kis	7	80	5149	2	ki_s
kiss	8	52	2741	2	kiss
kits	8	64	4178	2	kits
libs	6	67	3277	2	libs
lids	5	63	3647	2	lids
lies	4	64	5420	2	lies
lilo	4	67	3157	2	lilo
lilos	5	58	2187	2	lilos
lilt	4	63	4995	2	lilt
lilts	5	58	2280	2	lilts
lily	7	67	3019	2	lily
lins	4	70	5906	2	lins
lips	6	71	4145	2	lips
lis	3	71	6228	2	li_s
lits	4	62	5250	2	lits
mails	7	60	3778	2	mails
mels	6	59	4153	2	mels
mibs	8	53	3049	2	mibs
mics	8	74	3516	2	mics
mids	7	65	4180	2	mids
migs	7	69	3533	2	migs
mil	5	57	5212	2	mil_
mild	7	53	3086	2	mild
milds	8	64	2206	2	milds
mile	6	63	5258	2	mile
miles	7	46	4507	2	miles
milk	10	50	2848	2	milk
milks	11	50	2058	2	milks
mill	6	65	4149	2	mill
mills	7	54	3505	2	mills
milo	6	55	3611	2	milo
milos	7	54	2801	2	milos
milt	6	54	5582	2	milt
milts	7	54	3071	2	milts
mips	8	55	3409	2	mips
mirs	6	69	4058	2	mirs
mis	5	81	6263	2	mi_s
miss	6	53	3943	2	miss
moils	7	61	2575	2	moils
mols	6	59	4857	2	mols
nails	5	57	3040	2	nails
nibs	6	50	2832	2	nibs
nil	3	61	4420	2	nil_
nill	4	56	3431	2	nill
nills	5	49	2667	2	nills
nims	6	62	2689	2	nims
nips	6	58	3093	2	nips
nits	4	57	4165	2	nits
noils	5	50	2433	2	noils
oil	3	74	5206	2	oil_
oily	7	79	3226	2	oily
owls	7	60	2293	2	owls
pails	7	58	3306	2	pails
pals	6	69	5135	2	pals
pias	6	65	4256	2	pias
pics	8	56	3392	2	pics
pies	6	69	4961	2	pies
pigs	7	66	3423	2	pigs
pile	6	56	4970	2	pile
piles	7	47	4261	2	piles
pili	6	61	3036	2	pili
pilis	7	58	2520	2	pilis
pill	6	53	3947	2	pill
pills	7	41	3097	2	pills
pilus	7	59	2106	2	pilus
pily	9	61	3274	2	pily
pins	6	55	5846	2	pins
pips	8	58	3714	2	pips
pis	5	63	6204	2	pi_s
piss	6	50	3334	2	piss
pits	6	63	4875	2	pits
pols	6	60	4456	2	pols
puls	6	54	3756	2	puls
qis	12	69	3439	2	qi_s
rails	5	59	3740	2	rails
rials	5	50	2667	2	rials
rias	4	55	4060	2	rias
ribs	6	58	3303	2	ribs
rids	5	65	3956	2	rids
riels	5	51	2133	2	riels
rifs	7	49	2901	2	rifs
rigs	5	51	3760	2	rigs
rile	4	56	5054	2	rile
riles	5	53	4364	2	riles
rill	4	51	4091	2	rill
rills	5	50	3271	2	rills
rims	6	59	3631	2	rims
rins	4	61	5320	2	rins
rips	6	62	3744	2	rips
roils	5	48	2679	2	roils
sails	5	57	3810	2	sails
sals	4	68	5167	2	sals
sels	4	63	4598	2	sels
sials	5	42	2724	2	sials
sibs	6	59	3355	2	sibs
sics	6	52	3410	2	sics
sild	5	50	3059	2	sild
silds	6	55	2053	2	silds
silk	8	55	2933	2	silk
silks	9	46	2068	2	silks
sill	4	55	4516	2	sill
sills	5	51	3599	2	sills
silo	4	60	3792	2	silo
silos	5	60	2943	2	silos
silt	4	65	5820	2	silt
silts	5	53	3082	2	silts
sims	6	57	3718	2	sims
sins	4	67	5528	2	sins
sips	6	57	4011	2	sips
sirs	4	43	3834	2	sirs
sis	3	73	6055	2	si_s
sits	4	50	5021	2	sits
soils	5	53	2798	2	soils
sols	4	54	4816	2	sols
tails	5	56	3419	2	tails
tels	4	68	4169	2	tels
tics	6	57	2964	2	tics
ties	4	52	4832	2	ties
til	3	63	5027	2	til_
tile	4	54	5145	2	tile
tiles	5	55	4210	2	tiles
till	4	59	4121	2	till
tills	5	46	3171	2	tills
tilt	4	62	5243	2	tilt
tilts	5	53	2561	2	tilts
tins	4	52	5131	2	tins
tips	6	64	3677	2	tips
tirls	5	45	1980	2	tirls
tis	3	70	5665	2	ti_s
tits	4	61	4505	2	tits
toils	5	45	2749	2	toils
vails	8	58	2593	2	vails
veils	8	49	1880	2	veils
vials	8	58	2238	2	vials
vids	8	56	2755	2	vids
vies	7	52	3863	2	vies
vigs	8	54	2728	2	vigs
vile	7	61	3981	2	vile
vill	7	52	3508	2	vill
vills	8	64	2932	2	vills
vims	9	54	2332	2	vims
viols	8	61	1810	2	viols
virls	8	56	1860	2	virls
vis	6	67	4762	2	vi_s
wails	8	66	3148	2	wails
wigs	8	49	3126	2	wigs
wild	8	51	2652	2	wild
wilds	9	48	1821	2	wilds
wile	7	59	4438	2	wile
wiles	8	54	3787	2	wiles
will	7	57	3752	2	will
wills	8	45	2896	2	wills
wilt	7	62	4630	2	wilt
wilts	8	50	2350	2	wilts
wily	10	64	2882	2	wily
wins	7	59	4918	2	wins
wis	6	65	5234	2	wi_s
wiss	7	56	3055	2	wiss
wits	7	60	4488	2	wits
xis	10	69	3534	2	xi_s
yids	8	52	2497	2	yids
yill	7	56	2898	2	yill
yills	8	39	2155	2	yills
yins	7	53	3513	2	yins
yips	9	52	2671	2	yips
zigs	14	54	2280	2	zigs
zill	13	57	2762	2	zill
zills	14	40	2078	2	zills
zins	13	57	3501	2	zins
zips	15	57	2380	2	zips
zits	13	60	3030	2	zits

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	470	0.873	34217.6
3	Display Results	470	470	0.126	3730.2
	(SQL Overall)	178691	470	1.265	141257.7