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

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

400 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
nils	4	61	3245	(None)
ails	4	56	5471	1	ails
anils	5	63	2672	1	anils
fils	7	58	3869	1	fils
mils	6	60	4533	1	mils
nails	5	57	3040	1	nails
nibs	6	50	2831	1	nibs
nil	3	61	4419	1	nil_
nill	4	56	3430	1	nill
nills	5	49	2667	1	nills
nims	6	62	2688	1	nims
nips	6	58	3092	1	nips
nits	4	57	4164	1	nits
noils	5	50	2433	1	noils
oils	4	63	3797	1	oils
tils	4	57	3961	1	tils
aals	4	99	4114	2	aals
aids	5	78	4635	2	aids
ail	3	71	7104	2	ail_
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
airs	4	64	4742	2	airs
ais	3	90	8357	2	ai_s
aits	4	63	5553	2	aits
alls	4	67	4092	2	alls
als	3	66	6302	2	_als
anil	4	64	3743	2	anil_
anile	5	46	3446	2	anile
anis	4	57	4646	2	ani_s
anvils	9	21	971	2	anvils
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	3816	2	bias
bibs	8	48	3099	2	bibs
bids	7	58	3843	2	bids
bigs	7	62	3502	2	bigs
bile	6	61	4718	2	bile
biles	7	55	4214	2	biles
bilk	10	58	2442	2	bilk
bilks	11	51	1789	2	bilks
bill	6	72	3994	2	bill
bills	7	56	3286	2	bills
bins	6	65	4825	2	bins
bios	6	63	3532	2	bios
birls	7	40	2316	2	birls
bis	5	68	6066	2	bi_s
bits	6	61	4816	2	bits
boils	7	54	2719	2	boils
ceils	7	50	1940	2	ceils
cels	6	55	3497	2	cels
cigs	7	56	2510	2	cigs
cis	5	77	4803	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	3368	2	dibs
dies	5	56	5352	2	dies
difs	8	60	2732	2	difs
digs	6	60	3605	2	digs
dill	5	52	3997	2	dill
dills	6	55	3097	2	dills
dims	7	54	3502	2	dims
dins	5	66	5204	2	dins
diols	6	55	2101	2	diols
dips	7	55	3691	2	dips
dirls	6	47	2050	2	dirls
dis	4	64	5989	2	di_s
diss	5	64	3448	2	diss
dits	5	64	5052	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
enols	5	47	1840	2	enols
evils	8	41	1426	2	evils
fails	8	56	3148	2	fails
fibs	9	63	2950	2	fibs
fids	8	70	3473	2	fids
figs	8	53	3264	2	figs
fil	6	54	4714	2	fil_
fila	7	47	2913	2	fila
file	7	54	4664	2	file
files	8	54	4127	2	files
fill	7	55	4019	2	fill
fills	8	46	3237	2	fills
film	9	48	2817	2	film
films	10	56	1796	2	films
filo	7	60	3428	2	filo
filos	8	61	2538	2	filos
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fits	7	60	4346	2	fits
foils	8	50	2581	2	foils
gals	5	79	4650	2	gals
gels	5	68	3610	2	gels
gibs	7	55	2927	2	gibs
gids	6	59	3373	2	gids
gies	5	56	4142	2	gies
gigs	6	66	3118	2	gigs
gild	6	55	2651	2	gild
gilds	7	54	1752	2	gilds
gill	5	63	3618	2	gill
gills	6	47	2819	2	gills
gilt	5	63	4854	2	gilt
gilts	6	49	2426	2	gilts
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
girls	6	45	1839	2	girls
gits	5	57	4459	2	gits
guls	5	59	3085	2	guls
hails	8	52	3164	2	hails
heils	8	52	2219	2	heils
hies	7	48	4283	2	hies
hila	7	62	2835	2	hila
hili	7	56	2663	2	hili
hill	7	64	3949	2	hill
hills	8	54	3135	2	hills
hilt	7	58	5071	2	hilt
hilts	8	69	2441	2	hilts
hilus	8	48	1764	2	hilus
hims	9	52	3097	2	hims
hins	7	64	4799	2	hins
hips	9	64	3370	2	hips
his	6	63	5950	2	hi_s
hiss	7	56	2921	2	hiss
hits	7	55	4513	2	hits
hols	7	69	4629	2	hols
ids	4	75	3546	2	_ids
ifs	6	71	2424	2	_ifs
ilk	7	83	2530	2	_ilk
ilks	8	72	1857	2	_ilks
ill	3	74	3709	2	_ill
ills	4	70	3042	2	ills
inks	8	69	2650	2	inks
inly	7	56	2221	2	inly
inns	4	69	2093	2	inns
ins	3	59	4560	2	_ins
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jails	12	54	2294	2	jails
jibs	13	67	2408	2	jibs
jigs	12	65	2476	2	jigs
jill	11	64	3026	2	jill
jills	12	51	2282	2	jills
jilt	11	58	3942	2	jilt
jilts	12	47	1741	2	jilts
jins	11	56	3501	2	jins
kails	9	55	2521	2	kails
kids	9	60	2963	2	kids
kifs	11	60	2350	2	kifs
kill	8	55	3317	2	kill
kills	9	45	2617	2	kills
kiln	8	56	2097	2	kiln
kilns	9	51	1298	2	kilns
kilo	8	60	2866	2	kilo
kilos	9	50	2147	2	kilos
kilt	8	61	4441	2	kilt
kilts	9	51	2218	2	kilts
kins	8	57	4790	2	kins
kips	10	64	3051	2	kips
kirs	8	58	3173	2	kirs
kis	7	80	5147	2	ki_s
kiss	8	52	2739	2	kiss
kits	8	64	4176	2	kits
knits	9	39	1474	2	knits
libs	6	67	3276	2	libs
lids	5	63	3645	2	lids
lies	4	64	5419	2	lies
lilo	4	67	3156	2	lilo
lilos	5	58	2187	2	lilos
lilt	4	63	4994	2	lilt
lilts	5	58	2280	2	lilts
lily	7	67	3018	2	lily
lins	4	70	5905	2	lins
lips	6	71	4144	2	lips
lis	3	71	6227	2	li_s
lits	4	62	5249	2	lits
mails	7	60	3778	2	mails
mels	6	59	4153	2	mels
mibs	8	53	3048	2	mibs
mics	8	74	3515	2	mics
mids	7	65	4178	2	mids
migs	7	69	3532	2	migs
mil	5	57	5211	2	mil_
mild	7	53	3085	2	mild
milds	8	64	2205	2	milds
mile	6	63	5257	2	mile
miles	7	46	4507	2	miles
milk	10	50	2847	2	milk
milks	11	50	2058	2	milks
mill	6	65	4148	2	mill
mills	7	54	3505	2	mills
milo	6	55	3610	2	milo
milos	7	54	2801	2	milos
milt	6	54	5581	2	milt
milts	7	54	3071	2	milts
mips	8	55	3408	2	mips
mirs	6	69	4057	2	mirs
mis	5	81	6262	2	mi_s
miss	6	53	3942	2	miss
moils	7	61	2575	2	moils
mols	6	59	4857	2	mols
nabs	6	62	3619	2	nabs
nags	5	54	3602	2	nags
naifs	8	76	1742	2	naifs
nail	4	58	3865	2	nail_
nala	4	69	3039	2	nala
nalas	5	55	2836	2	nalas
nans	4	61	3939	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nays	7	59	3159	2	nays
nebs	6	61	2498	2	nebs
negs	5	57	2736	2	negs
neifs	8	56	1304	2	neifs
ness	4	55	2656	2	ness
nets	4	59	4153	2	nets
news	7	61	2737	2	news
nib	5	67	4519	2	ni_b
nice	6	55	3471	2	nice
nick	10	66	2760	2	nick
nicks	11	49	2049	2	nicks
nicols	8	8	1024	2	nicols
nide	5	55	3578	2	nide
nides	6	52	2913	2	nides
nidi	5	65	2439	2	nidi
nidus	6	59	1357	2	nidus
nigh	8	52	2066	2	nigh
nighs	9	50	1361	2	nighs
nihils	9	3	757	2	nihils
nim	5	71	4295	2	ni_m
nine	4	58	4217	2	nine
nines	5	59	3734	2	nines
nip	5	69	4598	2	ni_p
nipa	6	94	2163	2	nipa
nipas	7	71	1667	2	nipas
nisi	4	58	2324	2	nisi
nisus	5	60	1439	2	nisus
nit	3	70	6594	2	ni_t
nite	4	59	4358	2	nite
nites	5	57	3634	2	nites
nix	10	69	3283	2	ni_x
nixe	11	57	2202	2	nixe
nixes	12	45	1962	2	nixes
nixy	14	57	1451	2	nixy
nobs	6	64	3690	2	nobs
nods	5	58	3822	2	nods
noels	5	64	1870	2	noels
noes	4	58	4539	2	noes
nogs	5	65	3461	2	nogs
noil	4	61	3324	2	noil_
noily	8	61	2099	2	noily
noirs	5	56	1546	2	noirs
nolo	4	62	2931	2	nolo
nolos	5	44	2335	2	nolos
noms	6	56	3640	2	noms
nos	3	88	5932	2	n_os
nous	4	61	3698	2	nous
nows	7	57	3823	2	nows
nubs	6	59	2714	2	nubs
null	4	51	2531	2	null
nulls	5	50	1998	2	nulls
nuns	4	52	2823	2	nuns
nurls	5	55	1968	2	nurls
nus	3	79	3939	2	n_us
nuts	4	50	3267	2	nuts
oil	3	74	5205	2	oil_
oily	7	79	3225	2	oily
owls	7	60	2293	2	owls
pails	7	58	3306	2	pails
pals	6	69	5135	2	pals
pias	6	65	4255	2	pias
pics	8	56	3391	2	pics
pies	6	69	4960	2	pies
pigs	7	66	3422	2	pigs
pile	6	56	4969	2	pile
piles	7	47	4261	2	piles
pili	6	61	3035	2	pili
pilis	7	58	2520	2	pilis
pill	6	53	3946	2	pill
pills	7	41	3097	2	pills
pilus	7	59	2106	2	pilus
pily	9	61	3273	2	pily
pins	6	55	5845	2	pins
pips	8	58	3713	2	pips
pis	5	63	6203	2	pi_s
piss	6	50	3333	2	piss
pits	6	63	4874	2	pits
pols	6	60	4456	2	pols
puls	6	54	3756	2	puls
qis	12	69	3438	2	qi_s
rails	5	59	3740	2	rails
rials	5	50	2667	2	rials
rias	4	55	4059	2	rias
ribs	6	58	3302	2	ribs
rids	5	65	3954	2	rids
riels	5	51	2133	2	riels
rifs	7	49	2900	2	rifs
rigs	5	51	3759	2	rigs
rile	4	56	5053	2	rile
riles	5	53	4364	2	riles
rill	4	51	4090	2	rill
rills	5	50	3271	2	rills
rims	6	59	3630	2	rims
rins	4	61	5319	2	rins
rips	6	62	3743	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	3354	2	sibs
sics	6	52	3409	2	sics
sild	5	50	3058	2	sild
silds	6	55	2052	2	silds
silk	8	55	2932	2	silk
silks	9	46	2068	2	silks
sill	4	55	4515	2	sill
sills	5	51	3598	2	sills
silo	4	60	3791	2	silo
silos	5	60	2942	2	silos
silt	4	65	5819	2	silt
silts	5	53	3082	2	silts
sims	6	57	3717	2	sims
sins	4	67	5527	2	sins
sips	6	57	4010	2	sips
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	si_s
sits	4	50	5020	2	sits
snails	6	48	1665	2	snails
snibs	7	56	1376	2	snibs
snips	7	58	1801	2	snips
snits	5	41	2483	2	snits
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	2963	2	tics
ties	4	52	4831	2	ties
til	3	63	5026	2	til_
tile	4	54	5144	2	tile
tiles	5	55	4210	2	tiles
till	4	59	4120	2	till
tills	5	46	3170	2	tills
tilt	4	62	5242	2	tilt
tilts	5	53	2561	2	tilts
tins	4	52	5130	2	tins
tips	6	64	3676	2	tips
tirls	5	45	1980	2	tirls
tis	3	70	5664	2	ti_s
tits	4	61	4503	2	tits
toils	5	45	2749	2	toils
units	5	49	2343	2	units
vails	8	58	2593	2	vails
veils	8	49	1880	2	veils
vials	8	58	2238	2	vials
vids	8	56	2753	2	vids
vies	7	52	3862	2	vies
vigs	8	54	2727	2	vigs
vile	7	61	3980	2	vile
vill	7	52	3507	2	vill
vills	8	64	2932	2	vills
vims	9	54	2331	2	vims
viols	8	61	1810	2	viols
virls	8	56	1860	2	virls
vis	6	67	4761	2	vi_s
wails	8	66	3148	2	wails
wigs	8	49	3125	2	wigs
wild	8	51	2651	2	wild
wilds	9	48	1820	2	wilds
wile	7	59	4437	2	wile
wiles	8	54	3787	2	wiles
will	7	57	3751	2	will
wills	8	45	2896	2	wills
wilt	7	62	4629	2	wilt
wilts	8	50	2350	2	wilts
wily	10	64	2881	2	wily
wins	7	59	4917	2	wins
wis	6	65	5233	2	wi_s
wiss	7	56	3054	2	wiss
wits	7	60	4487	2	wits
xis	10	69	3533	2	xi_s
yids	8	52	2495	2	yids
yill	7	56	2897	2	yill
yills	8	39	2155	2	yills
yins	7	53	3512	2	yins
yips	9	52	2669	2	yips
zigs	14	54	2279	2	zigs
zill	13	57	2761	2	zill
zills	14	40	2078	2	zills
zins	13	57	3500	2	zins
zips	15	57	2379	2	zips
zits	13	60	3029	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.076	2351197.4
2	DLD Change Limit	29872	400	1.016	29401.6
3	Display Results	400	400	0.123	3252.0
	(SQL Overall)	178691	400	1.215	147070.8