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

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

463 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
oils	4	63	3798	(None)
ails	4	56	5472	1	ails
boils	7	54	2719	1	boils
coils	7	50	3008	1	coils
fils	7	58	3870	1	fils
foils	8	50	2581	1	foils
mils	6	60	4534	1	mils
moils	7	61	2575	1	moils
nils	4	61	3246	1	nils
noils	5	50	2433	1	noils
oil	3	74	5206	1	oil_
oily	7	79	3226	1	oily
owls	7	60	2293	1	owls
roils	5	48	2679	1	roils
soils	5	53	2798	1	soils
tils	4	57	3962	1	tils
toils	5	45	2749	1	toils
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
boil	6	63	3518	2	boil_
bolls	7	55	3131	2	bolls
bowls	10	61	2143	2	bowls
broils	8	41	1417	2	broils
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
coals	7	61	2960	2	coals
coifs	10	57	1870	2	coifs
coil	6	64	3965	2	coil_
coins	7	58	3455	2	coins
coirs	7	52	2105	2	coirs
cols	6	65	5308	2	cols
cools	7	56	3263	2	cools
cowls	10	69	2221	2	cowls
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
doily	9	53	2103	2	doily
doits	6	62	2367	2	doits
dolls	6	61	2692	2	dolls
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
fails	8	56	3148	2	fails
fibs	9	63	2951	2	fibs
fids	8	70	3475	2	fids
figs	8	53	3265	2	figs
fil	6	54	4715	2	fil_
fila	7	47	2914	2	fila
file	7	54	4665	2	file
files	8	54	4127	2	files
fill	7	55	4020	2	fill
fills	8	46	3237	2	fills
film	9	48	2818	2	film
films	10	56	1796	2	films
filo	7	60	3429	2	filo
filos	8	61	2538	2	filos
fins	7	58	4910	2	fins
firs	7	66	3772	2	firs
fits	7	60	4347	2	fits
foals	8	57	2169	2	foals
foil	7	64	3391	2	foil_
foins	8	55	2338	2	foins
fools	8	68	2420	2	fools
fouls	8	72	2143	2	fouls
fowls	11	55	1889	2	fowls
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
goals	6	55	2129	2	goals
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
howls	11	62	1922	2	howls
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
ions	4	67	3785	2	ions
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
joins	12	58	1841	2	joins
jowls	15	62	1452	2	jowls
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
koels	9	46	1390	2	koels
kohls	12	43	780	2	kohls
kois	8	51	2941	2	koi_s
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
loids	6	62	2071	2	loids
loins	5	67	2842	2	loins
lolls	5	121	2173	2	lolls
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
moil	6	55	3409	2	moil_
molls	7	51	2978	2	molls
mols	6	59	4857	2	mols
mools	7	60	2717	2	mools
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
noels	5	64	1870	2	noels
noil	4	61	3324	2	noil_
noily	8	61	2099	2	noily
noirs	5	56	1546	2	noirs
oafs	7	64	2526	2	oafs
oaks	8	65	2790	2	oaks
oars	4	68	4603	2	oars
oats	4	65	5421	2	oats
obas	6	57	3093	2	obas
obes	6	60	3683	2	obes
obias	7	61	1686	2	obias
obis	6	62	2684	2	obis
obits	7	46	1755	2	obits
obols	7	37	1586	2	obols
ocas	6	67	2963	2	ocas
odas	5	72	3026	2	odas
odds	6	89	1993	2	odds
odes	5	72	4324	2	odes
ods	4	75	4622	2	o_ds
odyls	9	42	865	2	odyls
oes	3	58	6619	2	o_es
offs	10	71	1701	2	offs
ogle	5	63	2505	2	ogle
ogles	6	52	2318	2	ogles
ohias	8	44	1557	2	ohias
ohms	9	55	1403	2	ohms
ohs	6	62	3231	2	o_hs
oi	2	90	6149	2	oi__
oiled	6	44	2947	2	oiled
oiler	5	46	2828	2	oiler
oilers	6	47	2119	2	oilers
oink	8	54	2935	2	oink
oinks	9	48	1991	2	oinks
okas	8	52	2539	2	okas
okes	8	49	3634	2	okes
old	4	70	3347	2	o_ld
olds	5	59	2658	2	olds
ole	3	71	5521	2	o_le
oles	4	64	5347	2	oles
olio	4	68	2967	2	olio
olios	5	45	2085	2	olios
olla	4	48	2117	2	olla
ollas	5	42	1828	2	ollas
omits	7	50	1826	2	omits
oms	5	63	3751	2	o_ms
ones	4	61	4653	2	ones
only	7	53	1972	2	only
onos	4	62	2900	2	onos
ons	3	61	4851	2	o_ns
onus	4	58	2681	2	onus
oohs	7	52	2069	2	oohs
oops	6	52	3267	2	oops
oots	4	64	4644	2	oots
opals	7	57	1835	2	opals
opes	6	59	4261	2	opes
ops	5	66	4125	2	o_ps
opts	6	81	2474	2	opts
opus	6	64	2059	2	opus
orals	5	58	2648	2	orals
orbs	6	66	2625	2	orbs
orcs	6	70	2543	2	orcs
ores	4	60	5668	2	ores
oriels	6	49	1462	2	oriels
orle	4	56	3046	2	orle
orles	5	53	2621	2	orles
ors	3	57	5011	2	o_rs
orts	4	65	3833	2	orts
os	2	113	5988	2	o__s
oses	4	66	4151	2	oses
ouds	5	64	3011	2	ouds
ours	4	72	3756	2	ours
outs	4	57	4696	2	outs
ovals	8	54	1339	2	ovals
owes	7	51	3710	2	owes
owl	6	62	2897	2	owl_
owns	7	68	1958	2	owns
oxes	11	65	3072	2	oxes
oxids	13	12	897	2	oxids
oxims	14	10	764	2	oxims
oyes	7	49	4013	2	oyes
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
poilu	7	23	1600	2	poilu
poilus	8	22	1057	2	poilus
pois	6	65	3904	2	poi_s
polis	7	47	3116	2	polis
polls	7	46	2772	2	polls
pols	6	60	4456	2	pols
pools	7	44	2770	2	pools
puls	6	54	3756	2	puls
qis	12	69	3439	2	qi_s
rails	5	59	3740	2	rails
reoils	6	45	1687	2	reoils
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
roil	4	62	3529	2	roil_
roily	8	61	2111	2	roily
rolls	5	53	2623	2	rolls
rotls	5	56	2016	2	rotls
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
soil	4	61	3883	2	soil_
sols	4	54	4816	2	sols
souls	5	51	2736	2	souls
spoils	8	46	1453	2	spoils
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
toil	4	65	3628	2	toil_
toile	5	46	2649	2	toile
toiles	6	39	2351	2	toiles
toits	5	53	2747	2	toits
tolls	5	47	2843	2	tolls
tools	5	53	2524	2	tools
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
voids	9	54	1468	2	voids
voila	8	48	1394	2	voila
voile	8	47	1972	2	voile
voiles	9	46	1644	2	voiles
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
wools	8	44	2146	2	wools
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
yowls	11	57	1543	2	yowls
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
zorils	15	38	1088	2	zorils

Search took 3 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	463	2.080	14361.5
3	Display Results	463	463	0.110	4209.1
	(SQL Overall)	178691	463	2.470	72344.5