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

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

460 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
oaks	8	65	2790	(None)
daks	9	71	3060	1	daks
oafs	7	64	2526	1	oafs
oak	7	62	3865	1	oak_
oaky	11	64	1995	1	oaky
oars	4	68	4603	1	oars
oats	4	65	5421	1	oats
okas	8	52	2539	1	okas
soaks	9	52	2029	1	soaks
yaks	11	60	2520	1	yaks
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	_aas
abs	5	93	5607	2	_abs
ads	4	97	5573	2	_ads
ags	4	75	5166	2	_ags
ahs	6	86	4482	2	_ahs
ais	3	90	8357	2	_ais
als	3	66	6302	2	_als
araks	9	48	2088	2	araks
arks	8	59	3687	2	arks
ars	3	76	7093	2	_ars
as	2	110	8307	2	_a_s
ask	7	71	3070	2	_ask
asks	8	57	2121	2	asks
ass	3	78	4406	2	_ass
auks	8	55	2526	2	auks
ays	6	70	5029	2	_ays
baas	6	68	4467	2	baas
backs	13	57	2962	2	backs
bads	7	70	4886	2	bads
bags	7	66	4550	2	bags
bake	10	56	3751	2	bake
bakes	11	70	3537	2	bakes
balks	11	49	2629	2	balks
bals	6	63	5404	2	bals
bams	8	70	4445	2	bams
banks	11	55	2790	2	banks
bans	6	65	5514	2	bans
baps	8	60	4084	2	baps
barks	11	57	3581	2	barks
bars	6	65	6409	2	bars
bas	5	86	8175	2	ba_s
bask	10	51	3142	2	bask
basks	11	56	2176	2	basks
bass	6	61	4678	2	bass
bats	6	69	6233	2	bats
bays	9	71	4391	2	bays
beaks	11	53	2662	2	beaks
boars	7	52	2960	2	boars
boas	6	61	5083	2	boa_s
boats	7	56	3515	2	boats
bocks	13	45	2657	2	bocks
bonks	11	63	2646	2	bonks
books	11	57	2971	2	books
borks	11	57	2770	2	borks
bosks	11	52	1885	2	bosks
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
cake	10	54	3996	2	cake
cakes	11	60	3767	2	cakes
caky	13	62	2244	2	caky
calks	11	54	2160	2	calks
cams	8	70	4728	2	cams
cans	6	50	5085	2	cans
caps	8	71	4789	2	caps
carks	11	55	3421	2	carks
cars	6	73	6476	2	cars
cask	10	56	2643	2	cask
casks	11	57	2006	2	casks
cats	6	63	5634	2	cats
caws	9	60	3611	2	caws
cays	9	54	3767	2	cays
cloaks	12	44	1126	2	cloaks
coals	7	61	2960	2	coals
coats	7	56	3500	2	coats
cocks	13	52	2716	2	cocks
conks	11	55	2570	2	conks
cooks	11	54	2914	2	cooks
corks	11	60	2827	2	corks
croaks	12	58	1298	2	croaks
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
dags	6	66	4260	2	dags
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
dak	8	63	4069	2	dak_
dals	5	71	4512	2	dals
dams	7	74	4437	2	dams
dans	5	67	4815	2	dans
daps	7	72	3916	2	daps
darks	10	67	2787	2	darks
dawks	13	52	1349	2	dawks
daws	8	66	3824	2	daws
days	8	76	3713	2	days
dhaks	13	47	970	2	dhaks
doats	6	52	2488	2	doats
docks	12	60	2231	2	docks
dorks	10	57	2444	2	dorks
ears	4	63	5659	2	ears
eats	4	70	5487	2	eats
elks	8	58	2003	2	elks
fabs	9	86	3586	2	fabs
fads	8	69	3987	2	fads
fags	8	69	3912	2	fags
fake	11	55	3494	2	fake
fakes	12	60	3248	2	fakes
fans	7	62	4737	2	fans
fas	6	82	6293	2	fa_s
fats	7	62	5250	2	fats
fays	10	85	3536	2	fays
foals	8	57	2169	2	foals
foams	10	50	1795	2	foams
folks	12	60	1712	2	folks
forks	12	53	2468	2	forks
gabs	7	67	4042	2	gabs
gads	6	78	4338	2	gads
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gals	5	79	4650	2	gals
gams	7	66	4888	2	gams
gaps	7	60	4297	2	gaps
gars	5	57	5074	2	gars
gas	4	88	7025	2	ga_s
gats	5	67	5344	2	gats
gawks	13	68	1163	2	gawks
gays	8	73	3802	2	gays
goads	7	70	2285	2	goads
goals	6	55	2129	2	goals
goas	5	52	3994	2	goa_s
goats	6	55	2730	2	goats
gooks	10	54	2288	2	gooks
gowks	13	60	1195	2	gowks
hacks	14	49	2871	2	hacks
haes	7	76	5102	2	haes
hags	8	67	4084	2	hags
hahs	10	83	3336	2	hahs
haiks	12	51	2093	2	haiks
hake	11	56	3784	2	hake
hakes	12	60	3430	2	hakes
haku	11	69	2389	2	haku
hakus	12	51	1411	2	hakus
hams	9	64	4613	2	hams
hanks	12	62	2686	2	hanks
haps	9	64	4346	2	haps
harks	12	63	3343	2	harks
has	6	73	7265	2	ha_s
hats	7	68	5825	2	hats
hawks	15	54	1570	2	hawks
haws	10	64	3944	2	haws
hays	10	61	3807	2	hays
hoars	8	59	2555	2	hoars
hocks	14	49	2549	2	hocks
holks	12	47	2056	2	holks
honks	12	51	2452	2	honks
hooks	12	50	2712	2	hooks
howks	15	50	1685	2	howks
ilks	8	72	1857	2	ilks
inks	8	69	2650	2	inks
irks	8	62	2013	2	irks
jabs	13	58	3009	2	jabs
jacks	18	52	1983	2	jacks
jags	12	61	3279	2	jags
jake	15	59	2577	2	jake
jakes	16	50	2364	2	jakes
jams	13	52	3107	2	jams
jars	11	73	3835	2	jars
jauks	16	54	1246	2	jauks
jaws	14	50	2729	2	jaws
jays	14	63	2834	2	jays
jocks	18	51	1808	2	jocks
jouks	16	56	1234	2	jouks
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kafs	11	64	2374	2	kafs
kaka	7	65	1868	2	kaka
kakas	8	51	1734	2	kakas
kaki	7	65	2091	2	kaki
kakis	8	61	1684	2	kakis
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kays	11	60	3219	2	kays
koans	9	58	1862	2	koans
koas	8	56	3509	2	koa_s
konks	8	49	1711	2	konks
kooks	8	52	1726	2	kooks
kyaks	11	45	916	2	kyaks
labs	6	71	4512	2	labs
lacks	11	61	2920	2	lacks
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lags	5	65	4622	2	lags
lake	8	57	4160	2	lake
lakes	9	57	3765	2	lakes
lakh	11	49	1995	2	lakh
lakhs	12	52	1034	2	lakhs
laky	11	67	2582	2	laky
lams	6	65	5226	2	lams
laps	6	68	4887	2	laps
larks	9	52	2781	2	larks
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lass	4	74	4454	2	lass
lats	4	59	6270	2	lats
lavs	7	67	3415	2	lavs
laws	7	64	4168	2	laws
lays	7	60	4325	2	lays
leaks	9	59	2391	2	leaks
leks	8	54	2760	2	leks
loads	6	53	2337	2	loads
loafs	8	56	1699	2	loafs
loams	7	56	1986	2	loams
loans	5	60	2646	2	loans
locks	11	51	2692	2	locks
looks	9	51	2486	2	looks
macks	13	51	2760	2	macks
macs	8	67	4251	2	macs
mads	7	68	4537	2	mads
maes	6	69	4840	2	maes
mags	7	54	4453	2	mags
make	10	55	3789	2	make
makes	11	53	3685	2	makes
mako	10	56	2236	2	mako
makos	11	65	1836	2	makos
mans	6	63	5455	2	mans
maps	8	61	4105	2	maps
marks	11	59	3348	2	marks
mars	6	62	6187	2	mars
mas	5	81	7582	2	ma_s
mask	10	52	2736	2	mask
masks	11	53	2053	2	masks
mass	6	60	4494	2	mass
mats	6	54	6029	2	mats
maws	9	64	3714	2	maws
mays	9	69	4003	2	mays
moans	7	46	2437	2	moans
moas	6	55	4534	2	moa_s
moats	7	58	2764	2	moats
mocks	13	50	2382	2	mocks
monks	11	61	2339	2	monks
mosks	11	61	1700	2	mosks
nabs	6	62	3619	2	nabs
nags	5	54	3602	2	nags
nans	4	61	3940	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
narks	9	60	2603	2	narks
nays	7	59	3159	2	nays
nocks	11	51	2101	2	nocks
nooks	9	54	2039	2	nooks
oaf	6	59	5288	2	oa_f
oaken	9	58	1438	2	oaken
oakum	11	7	731	2	oakum
oakums	12	6	415	2	oakums
oar	3	70	5795	2	oa_r
oases	5	53	3098	2	oases
oasis	5	64	2255	2	oasis
oast	4	71	5632	2	oast
oasts	5	65	2918	2	oasts
oat	3	98	8826	2	oa_t
oath	7	61	3215	2	oath
oaths	8	61	1731	2	oaths
oaves	8	49	2561	2	oaves
obas	6	57	3093	2	obas
obes	6	60	3683	2	obes
obis	6	62	2684	2	obis
ocas	6	67	2963	2	ocas
odahs	9	56	1008	2	odahs
odas	5	72	3026	2	odas
odds	6	89	1992	2	odds
odes	5	72	4324	2	odes
ods	4	75	4621	2	o_ds
oes	3	58	6619	2	o_es
ofays	11	48	892	2	ofays
offs	10	71	1701	2	offs
ogams	8	41	1268	2	ogams
ohms	9	55	1403	2	ohms
ohs	6	62	3231	2	o_hs
oils	4	63	3797	2	oils
oinks	9	48	1991	2	oinks
oka	7	69	2680	2	o_ka
okay	11	59	1766	2	okay
okays	12	60	944	2	okays
oke	7	58	3948	2	o_ke
okes	8	49	3634	2	okes
olds	5	59	2657	2	olds
oles	4	64	5347	2	oles
oms	5	63	3751	2	o_ms
ones	4	61	4653	2	ones
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
opahs	10	54	1198	2	opahs
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
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	3010	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
owls	7	60	2293	2	owls
owns	7	68	1958	2	owns
oxes	11	65	3072	2	oxes
oyes	7	49	4013	2	oyes
packs	13	55	2893	2	packs
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
paiks	11	47	1985	2	paiks
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pans	6	58	5573	2	pans
paps	8	64	4345	2	paps
parks	11	61	3446	2	parks
pars	6	75	6079	2	pars
pas	5	87	7574	2	pa_s
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
paws	9	60	3818	2	paws
pays	9	59	4022	2	pays
peaks	11	48	2562	2	peaks
pocks	13	50	2296	2	pocks
porks	11	51	2414	2	porks
qats	13	53	3134	2	qats
racks	11	50	2885	2	racks
rads	5	60	4660	2	rads
rags	5	54	4837	2	rags
rais	4	52	5262	2	rais
rake	8	48	4157	2	rake
rakes	9	44	4035	2	rakes
raki	8	71	2783	2	raki
rakis	9	53	2344	2	rakis
raku	8	54	2377	2	raku
rakus	9	44	1367	2	rakus
rams	6	59	5077	2	rams
ranks	9	52	2573	2	ranks
raps	6	62	4773	2	raps
ras	3	75	7539	2	ra_s
rats	4	62	6037	2	rats
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
roads	6	65	2362	2	roads
roams	7	49	1961	2	roams
roans	5	49	2644	2	roans
roars	5	56	2224	2	roars
rocks	11	46	2641	2	rocks
rooks	9	53	2504	2	rooks
sabs	6	66	4374	2	sabs
sacks	11	42	2887	2	sacks
sacs	6	57	3907	2	sacs
sags	5	59	4840	2	sags
sake	8	52	4496	2	sake
sakes	9	55	4075	2	sakes
saki	8	56	2848	2	saki
sakis	9	53	2367	2	sakis
sals	4	68	5167	2	sals
sans	4	51	5336	2	sans
saps	6	53	4637	2	saps
sarks	9	66	3246	2	sarks
sass	4	50	3562	2	sass
saws	7	58	3948	2	saws
says	7	59	4210	2	says
skas	8	53	2571	2	skas
soak	8	72	2766	2	soak_
soaps	7	51	2071	2	soaps
soars	5	47	3251	2	soars
socks	11	49	2608	2	socks
sooks	9	44	2545	2	sooks
souks	9	48	2052	2	souks
suks	8	59	2712	2	suks
tabs	6	68	4298	2	tabs
tacks	11	54	3013	2	tacks
tads	5	71	4394	2	tads
tags	5	55	4523	2	tags
taka	8	76	2359	2	taka
takas	9	55	2068	2	takas
take	8	47	3926	2	take
takes	9	44	3779	2	takes
talks	9	43	2269	2	talks
tams	6	72	4793	2	tams
tanks	9	46	2473	2	tanks
tans	4	61	5482	2	tans
taos	4	55	4100	2	taos
taps	6	60	5067	2	taps
tars	4	67	6395	2	tars
tas	3	84	7710	2	ta_s
task	8	53	2665	2	task
tasks	9	49	1758	2	tasks
tass	4	56	4057	2	tass
tats	4	68	5813	2	tats
taus	4	63	4273	2	taus
tavs	7	56	3097	2	tavs
taws	7	56	4159	2	taws
teaks	9	42	2290	2	teaks
toads	6	56	2107	2	toads
troaks	10	44	1060	2	troaks
tsks	8	64	1066	2	tsks
vacs	9	62	2620	2	vacs
vans	7	62	3673	2	vans
vars	7	57	4207	2	vars
vas	6	77	5577	2	va_s
vats	7	68	4174	2	vats
vaus	7	59	2892	2	vaus
vavs	10	57	2043	2	vavs
vaws	10	55	2732	2	vaws
wabs	9	73	3723	2	wabs
wacks	14	66	2628	2	wacks
wads	8	73	4314	2	wads
waes	7	60	4860	2	waes
wags	8	61	4055	2	wags
wake	11	49	3570	2	wake
wakes	12	66	3365	2	wakes
walks	12	62	1850	2	walks
wanks	12	61	2448	2	wanks
wans	7	64	5227	2	wans
waps	9	66	4208	2	waps
warks	12	79	3240	2	warks
wars	7	86	5980	2	wars
was	6	87	6756	2	wa_s
wats	7	75	5588	2	wats
wauks	12	55	1516	2	wauks
waws	10	68	3490	2	waws
ways	10	77	3795	2	ways
woads	9	48	1844	2	woads
woks	11	62	2490	2	woks
wonks	12	48	1834	2	wonks
works	12	56	2190	2	works
yacks	14	44	1981	2	yacks
yags	8	66	3229	2	yags
yak	10	70	3856	2	yak_
yams	9	53	3073	2	yams
yanks	12	53	1657	2	yanks
yaps	9	59	3352	2	yaps
yaws	10	55	3121	2	yaws
yays	10	57	2891	2	yays
yocks	14	44	1837	2	yocks
yoks	11	62	2374	2	yoks
yolks	12	54	1277	2	yolks
yuks	11	64	1802	2	yuks
zags	14	68	2668	2	zags
zaps	15	68	2689	2	zaps
zas	12	69	4683	2	za_s
zeks	17	58	1506	2	zeks
zonks	18	48	1517	2	zonks
zooks	18	47	1694	2	zooks
zouks	18	44	1050	2	zouks

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.296	603685.8
2	DLD Change Limit	29872	460	0.986	30296.1
3	Display Results	460	460	0.123	3739.8
	(SQL Overall)	178691	460	1.405	127182.2