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

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

363 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
oafs	7	64	2526	(None)
kafs	11	64	2374	1	kafs
loafs	8	56	1699	1	loafs
oaf	6	59	5288	1	oaf_
oaks	8	65	2790	1	oaks
oars	4	68	4603	1	oars
oats	4	65	5421	1	oats
offs	10	71	1701	1	offs
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
aff	9	55	3761	2	_aff
aft	6	68	4901	2	_aft
ags	4	75	5166	2	_ags
ahs	6	86	4482	2	_ahs
ais	3	90	8357	2	_ais
als	3	66	6302	2	_als
arfs	7	60	2996	2	arfs
ars	3	76	7093	2	_ars
as	2	110	8307	2	_a_s
ass	3	78	4406	2	_ass
ays	6	70	5029	2	_ays
baas	6	68	4467	2	baas
bads	7	70	4886	2	bads
baff	12	46	3227	2	baff
baffs	13	47	1805	2	baffs
bags	7	66	4550	2	bags
bals	6	63	5404	2	bals
bams	8	70	4445	2	bams
bans	6	65	5513	2	bans
baps	8	60	4084	2	baps
barfs	10	48	2600	2	barfs
bars	6	65	6409	2	bars
bas	5	86	8175	2	ba_s
bass	6	61	4678	2	bass
bats	6	69	6233	2	bats
bays	9	71	4391	2	bays
boars	7	52	2960	2	boars
boas	6	61	5083	2	boa_s
boats	7	56	3515	2	boats
boffs	13	49	1550	2	boffs
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
cafe	9	52	3032	2	cafe
cafes	10	64	2692	2	cafes
caff	12	56	3167	2	caff
caffs	13	54	1737	2	caffs
calfs	10	49	1938	2	calfs
cams	8	70	4728	2	cams
cans	6	50	5084	2	cans
caps	8	71	4789	2	caps
cars	6	73	6476	2	cars
cats	6	63	5634	2	cats
caws	9	60	3610	2	caws
cays	9	54	3767	2	cays
coals	7	61	2960	2	coals
coats	7	56	3499	2	coats
coffs	13	49	1630	2	coffs
coifs	10	57	1870	2	coifs
coofs	10	59	2471	2	coofs
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
daff	11	52	2968	2	daff
daffs	12	51	1642	2	daffs
daft	8	55	3725	2	daft
dags	6	66	4259	2	dags
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
daks	9	71	3060	2	daks
dals	5	71	4512	2	dals
dams	7	74	4437	2	dams
dans	5	67	4814	2	dans
daps	7	72	3916	2	daps
daws	8	66	3824	2	daws
days	8	76	3713	2	days
difs	8	60	2732	2	difs
doats	6	52	2488	2	doats
doffs	12	56	1433	2	doffs
ears	4	63	5659	2	ears
eats	4	70	5487	2	eats
effs	10	51	1403	2	effs
efs	6	68	2960	2	_efs
fabs	9	86	3586	2	fabs
fads	8	69	3987	2	fads
fags	8	69	3912	2	fags
fans	7	62	4736	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
gabs	7	67	4042	2	gabs
gads	6	78	4338	2	gads
gaes	5	63	4803	2	gaes
gaff	11	48	2815	2	gaff
gaffs	12	49	1465	2	gaffs
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
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
golfs	9	56	1610	2	golfs
goofs	9	48	2100	2	goofs
haafs	11	57	1116	2	haafs
haes	7	76	5102	2	haes
haft	10	59	4184	2	haft
hafts	11	62	1946	2	hafts
hags	8	67	4084	2	hags
hahs	10	83	3336	2	hahs
hams	9	64	4613	2	hams
haps	9	64	4346	2	haps
has	6	73	7265	2	ha_s
hats	7	68	5825	2	hats
haws	10	64	3944	2	haws
hays	10	61	3807	2	hays
hoars	8	59	2554	2	hoars
hoofs	11	57	2104	2	hoofs
howfs	14	48	1450	2	howfs
ifs	6	71	2424	2	_ifs
jabs	13	58	3009	2	jabs
jags	12	61	3279	2	jags
jams	13	52	3107	2	jams
jars	11	73	3835	2	jars
jaws	14	50	2729	2	jaws
jays	14	63	2834	2	jays
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kaf	10	68	4551	2	kaf_
kaifs	12	57	1564	2	kaifs
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kays	11	60	3219	2	kays
kefs	11	59	2274	2	kefs
khafs	15	64	884	2	khafs
kifs	11	60	2350	2	kifs
koans	9	58	1862	2	koans
koas	8	56	3509	2	koa_s
labs	6	71	4512	2	labs
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lags	5	65	4622	2	lags
lams	6	65	5226	2	lams
laps	6	68	4887	2	laps
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
leafs	8	57	2118	2	leafs
loads	6	53	2337	2	loads
loaf	7	67	3490	2	loaf_
loams	7	56	1986	2	loams
loans	5	60	2646	2	loans
loofs	8	56	2378	2	loofs
macs	8	67	4250	2	macs
mads	7	68	4536	2	mads
maes	6	69	4839	2	maes
mags	7	54	4452	2	mags
mans	6	63	5453	2	mans
maps	8	61	4104	2	maps
mars	6	62	6186	2	mars
mas	5	81	7581	2	ma_s
mass	6	60	4493	2	mass
mats	6	54	6028	2	mats
maws	9	64	3713	2	maws
mays	9	69	4002	2	mays
moans	7	46	2436	2	moans
moas	6	55	4534	2	moa_s
moats	7	58	2764	2	moats
nabs	6	62	3619	2	nabs
naff	10	51	2893	2	naff
naffs	11	62	1396	2	naffs
nags	5	54	3602	2	nags
naifs	8	76	1742	2	naifs
nans	4	61	3939	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nays	7	59	3159	2	nays
oafish	12	13	1172	2	oafish
oak	7	62	3865	2	oa_k
oaky	11	64	1995	2	oaky
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
of	5	82	4777	2	o_f_
ofay	10	64	1610	2	ofay
ofays	11	48	892	2	ofays
off	9	63	3163	2	o_ff
oft	6	77	4406	2	o_ft
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
okas	8	52	2539	2	okas
okays	12	60	944	2	okays
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
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pans	6	58	5572	2	pans
paps	8	64	4345	2	paps
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
poofs	10	52	2279	2	poofs
poufs	10	56	1606	2	poufs
qats	13	53	3134	2	qats
rads	5	60	4660	2	rads
raff	10	49	3304	2	raff
raffs	11	50	1752	2	raffs
raft	7	62	4591	2	raft
rafts	8	78	2063	2	rafts
rags	5	54	4837	2	rags
rais	4	52	5262	2	rais
rams	6	59	5077	2	rams
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
refs	7	57	3224	2	refs
rifs	7	49	2900	2	rifs
roads	6	65	2361	2	roads
roams	7	49	1961	2	roams
roans	5	49	2644	2	roans
roars	5	56	2223	2	roars
rolfs	8	48	1712	2	rolfs
roofs	8	53	2115	2	roofs
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
safe	7	59	3095	2	safe
safes	8	52	2672	2	safes
sags	5	59	4840	2	sags
sals	4	68	5167	2	sals
sans	4	51	5335	2	sans
saps	6	53	4637	2	saps
sass	4	50	3562	2	sass
saws	7	58	3948	2	saws
says	7	59	4210	2	says
soaks	9	52	2029	2	soaks
soaps	7	51	2071	2	soaps
soars	5	47	3251	2	soars
sofas	8	53	2071	2	sofas
tabs	6	68	4298	2	tabs
tads	5	71	4394	2	tads
tags	5	55	4523	2	tags
tams	6	72	4793	2	tams
tans	4	61	5481	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
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
toads	6	56	2106	2	toads
toffs	11	60	1672	2	toffs
vacs	9	62	2620	2	vacs
vans	7	62	3672	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
wads	8	73	4314	2	wads
waes	7	60	4860	2	waes
waff	13	42	2804	2	waff
waffs	14	63	1547	2	waffs
waft	10	61	3900	2	waft
wafts	11	69	2055	2	wafts
wags	8	61	4055	2	wags
waifs	11	57	1987	2	waifs
wans	7	64	5226	2	wans
waps	9	66	4208	2	waps
wars	7	86	5980	2	wars
was	6	87	6756	2	wa_s
wats	7	75	5588	2	wats
waws	10	68	3490	2	waws
ways	10	77	3795	2	ways
woads	9	48	1844	2	woads
wolfs	11	62	1416	2	wolfs
woofs	11	49	1800	2	woofs
yaff	13	53	2426	2	yaff
yaffs	14	53	1112	2	yaffs
yags	8	66	3229	2	yags
yaks	11	60	2520	2	yaks
yams	9	53	3073	2	yams
yaps	9	59	3352	2	yaps
yaws	10	55	3121	2	yaws
yays	10	57	2891	2	yays
zags	14	68	2668	2	zags
zaps	15	68	2689	2	zaps
zarfs	17	47	1362	2	zarfs
zas	12	69	4683	2	za_s

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.080	2233637.5
2	DLD Change Limit	29872	363	1.030	29001.9
3	Display Results	363	363	0.076	4776.3
	(SQL Overall)	178691	363	1.186	150666.9