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

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

457 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
lays	7	60	4325	(None)
ays	6	70	5029	1	_ays
bays	9	71	4391	1	bays
cays	9	54	3767	1	cays
clays	10	55	2133	1	clays
days	8	76	3713	1	days
fays	10	85	3536	1	fays
flays	11	63	2105	1	flays
gays	8	73	3802	1	gays
hays	10	61	3807	1	hays
jays	14	63	2834	1	jays
kays	11	60	3219	1	kays
labs	6	71	4512	1	labs
lacs	6	69	4248	1	lacs
lads	5	65	4913	1	lads
lags	5	65	4622	1	lags
lams	6	65	5226	1	lams
laps	6	68	4887	1	laps
lars	4	69	5657	1	lars
las	3	72	8147	1	la_s
lass	4	74	4454	1	lass
lats	4	59	6270	1	lats
lavs	7	67	3415	1	lavs
laws	7	64	4168	1	laws
lay	6	88	6535	1	lay_
leys	7	64	3018	1	leys
mays	9	69	4002	1	mays
nays	7	59	3159	1	nays
pays	9	59	4022	1	pays
plays	10	63	2077	1	plays
rays	7	76	4235	1	rays
says	7	59	4210	1	says
slays	8	57	2368	1	slays
ways	10	77	3795	1	ways
yays	10	57	2891	1	yays
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	_aas
abs	5	93	5607	2	_abs
abys	9	72	2188	2	abys
ads	4	97	5573	2	_ads
ags	4	75	5166	2	_ags
ahs	6	86	4482	2	_ahs
ais	3	90	8357	2	_ais
alans	5	56	3617	2	alans
alas	4	63	5812	2	alas
albs	6	86	2857	2	albs
ales	4	70	6710	2	ales
allays	9	43	1374	2	allays
alls	4	67	4092	2	alls
alms	6	58	3492	2	alms
alps	6	55	2924	2	alps
als	3	66	6302	2	_als
alts	4	66	3990	2	alts
always	12	40	913	2	always
ars	3	76	7093	2	_ars
as	2	110	8307	2	_a_s
ass	3	78	4406	2	_ass
ay	5	117	7389	2	_ay_
aye	6	71	5176	2	_aye
ayes	7	65	4351	2	_ayes
baas	6	68	4467	2	baas
bads	7	70	4886	2	bads
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
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
bay	8	96	6164	2	bay_
belays	11	43	1385	2	belays
beys	9	138	2955	2	beys
blabs	9	56	1963	2	blabs
blahs	10	56	1651	2	blahs
blams	9	50	2385	2	blams
blats	7	51	3250	2	blats
blaws	10	56	2046	2	blaws
boys	9	67	3733	2	boys
brays	10	67	2311	2	brays
buys	9	57	2679	2	buys
bys	8	52	2946	2	_bys
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
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
cay	8	71	5598	2	cay_
chays	13	53	1974	2	chays
clads	8	57	2273	2	clads
clags	8	56	2112	2	clags
clams	9	51	2767	2	clams
clans	7	50	3101	2	clans
claps	9	56	2618	2	claps
class	7	55	2548	2	class
claws	10	60	2083	2	claws
clay	9	59	2741	2	clay_
cloys	10	49	1694	2	cloys
coys	9	75	3724	2	coys
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
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
day	7	62	5411	2	day_
delays	10	40	1405	2	delays
deys	8	50	2747	2	deys
drays	9	58	1977	2	drays
drys	8	63	1480	2	drys
ears	4	63	5659	2	ears
easy	7	62	2449	2	easy
eats	4	70	5487	2	eats
elans	5	55	2775	2	elans
eyas	7	64	2743	2	eyas
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
fay	9	74	5486	2	fay_
flabs	10	58	1864	2	flabs
flags	9	53	2128	2	flags
flams	10	51	2501	2	flams
flans	8	53	2797	2	flans
flaps	10	56	2138	2	flaps
flats	8	64	2974	2	flats
flaws	11	59	2034	2	flaws
flay	10	63	3280	2	flay_
fleys	11	70	1560	2	fleys
foys	10	56	2829	2	foys
frays	11	69	2010	2	frays
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
gay	7	68	5649	2	gay_
glads	7	56	2061	2	glads
glams	8	58	2293	2	glams
glans	6	51	2583	2	glans
glass	6	55	1813	2	glass
gleys	9	65	1485	2	gleys
goys	8	63	2841	2	goys
grays	9	56	2133	2	grays
guys	8	50	1964	2	guys
haes	7	76	5102	2	haes
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
hay	9	73	5877	2	hay_
hoys	10	77	3393	2	hoys
inlays	9	38	987	2	inlays
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
jay	13	62	4267	2	jay_
joys	14	66	2466	2	joys
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kafs	11	64	2374	2	kafs
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kay	10	67	4554	2	kay_
kayo	11	64	1755	2	kayo
kayos	12	77	1470	2	kayos
keys	11	63	2216	2	keys
la	2	192	6163	2	la__
lab	5	88	6478	2	la_b
lac	5	101	5582	2	la_c
lace	6	68	4847	2	lace
laces	7	61	4176	2	laces
lack	10	58	3768	2	lack
lacks	11	61	2920	2	lacks
lacy	9	58	2963	2	lacy
lad	4	81	6570	2	la_d
lade	5	63	4598	2	lade
lades	6	51	4127	2	lades
lady	8	65	2715	2	lady
lag	4	78	6212	2	la_g
laic	6	59	3156	2	laic
laics	7	64	1925	2	laics
laid	5	64	3914	2	laid
lain	4	61	4628	2	lain
lair	4	59	3415	2	lair
lairs	5	54	2587	2	lairs
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
lall	4	55	3131	2	lall
lalls	5	53	2413	2	lalls
lam	5	76	6671	2	la_m
lama	6	66	3529	2	lama
lamas	7	55	3279	2	lamas
lamb	8	68	3214	2	lamb
lambs	9	59	2141	2	lambs
lame	6	68	4929	2	lame
lames	7	54	4554	2	lames
lamp	8	62	3382	2	lamp
lamps	9	56	2483	2	lamps
land	5	63	3730	2	land
lands	6	54	2690	2	lands
lane	4	51	5332	2	lane
lanes	5	49	4679	2	lanes
lang	5	66	3737	2	lang
lank	8	47	3444	2	lank
lap	5	85	6527	2	la_p
lapis	7	62	2315	2	lapis
lapse	7	49	1768	2	lapse
lar	3	79	6753	2	la_r
lard	5	67	4200	2	lard
lards	6	53	3186	2	lards
lares	5	48	5263	2	lares
lari	4	58	3915	2	lari
laris	5	47	3746	2	laris
lark	8	57	3386	2	lark
larks	9	52	2781	2	larks
lase	4	61	4851	2	lase
lases	5	49	4476	2	lases
lash	7	65	3965	2	lash
lassi	5	63	1685	2	lassi
lasso	5	50	1568	2	lasso
last	4	62	6032	2	last
lasts	5	77	3126	2	lasts
lat	3	75	9340	2	la_t
late	4	75	6048	2	late
lath	7	66	4038	2	lath
laths	8	60	2240	2	laths
lati	4	64	3827	2	lati
latu	4	79	3418	2	latu
laud	5	65	2772	2	laud
lauds	6	56	1848	2	lauds
lav	6	68	4734	2	la_v
lava	7	67	2542	2	lava
lavas	8	54	2222	2	lavas
lave	7	56	4214	2	lave
laves	8	60	3915	2	laves
law	6	86	5664	2	la_w
lawn	7	59	2563	2	lawn
lawns	8	52	1542	2	lawns
lax	10	76	5152	2	la_x
laxes	12	54	3009	2	laxes
layed	9	51	2738	2	layed
layer	8	46	2647	2	layer
layers	9	39	2118	2	layers
layin	8	47	2033	2	layin
layins	9	38	1765	2	layins
layup	10	3	772	2	layup
layups	11	3	399	2	layups
laze	13	62	3505	2	laze
lazes	14	51	2957	2	lazes
lazy	16	64	2307	2	lazy
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lears	5	59	3873	2	lears
leas	4	59	5418	2	leas
lees	4	54	5588	2	lees
legs	5	61	3369	2	legs
leis	4	57	3960	2	leis
leks	8	54	2760	2	leks
lens	4	61	4649	2	lens
les	3	56	6307	2	l_es
less	4	56	3510	2	less
lets	4	71	4794	2	lets
ley	6	62	4681	2	ley_
liars	5	47	2316	2	liars
libs	6	67	3276	2	libs
lids	5	63	3645	2	lids
lies	4	64	5419	2	lies
lins	4	70	5905	2	lins
lips	6	71	4144	2	lips
lis	3	71	6227	2	l_is
lits	4	62	5249	2	lits
loads	6	53	2337	2	loads
loafs	8	56	1699	2	loafs
loams	7	56	1986	2	loams
loans	5	60	2646	2	loans
lobs	6	64	4108	2	lobs
logs	5	73	4311	2	logs
loos	4	90	5112	2	loos
lops	6	60	4335	2	lops
loss	4	53	3796	2	loss
lots	4	76	5209	2	lots
lows	7	58	4301	2	lows
luaus	5	45	1490	2	luaus
lues	4	59	4355	2	lues
lugs	5	52	3352	2	lugs
lums	6	57	3424	2	lums
luvs	7	58	1850	2	luvs
lyase	8	55	1241	2	lyase
lye	6	65	3341	2	l_ye
lyes	7	55	3083	2	lyes
lyse	7	63	2059	2	l_yse
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
may	8	87	5762	2	may_
maya	9	58	2458	2	maya
mayas	10	59	2438	2	mayas
mayo	9	65	2429	2	mayo
mayos	10	55	2193	2	mayos
mayst	10	66	2267	2	mayst
nabs	6	62	3619	2	nabs
nags	5	54	3602	2	nags
nans	4	61	3939	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nay	6	69	5277	2	nay_
oafs	7	64	2526	2	oafs
oaks	8	65	2790	2	oaks
oars	4	68	4603	2	oars
oats	4	65	5421	2	oats
ofays	11	48	892	2	ofays
okays	12	60	944	2	okays
onlays	9	39	871	2	onlays
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
pay	8	84	6118	2	pay_
plans	7	57	3127	2	plans
plats	7	55	3137	2	plats
platys	11	45	985	2	platys
play	9	59	2898	2	play_
playa	10	58	1294	2	playa
playas	11	46	1228	2	playas
ploys	10	58	1659	2	ploys
prays	10	50	2243	2	prays
pyas	9	62	2570	2	pyas
qats	13	53	3134	2	qats
quays	17	46	1204	2	quays
rads	5	60	4660	2	rads
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
ray	6	63	6199	2	ray_
raya	7	52	2482	2	raya
rayas	8	59	2205	2	rayas
relays	9	43	1675	2	relays
ryas	7	72	2461	2	ryas
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
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
say	6	72	6476	2	say_
sayst	8	53	2200	2	sayst
shays	11	60	2143	2	shays
slabs	7	53	2264	2	slabs
slags	6	65	2590	2	slags
slams	7	49	2790	2	slams
slaps	7	60	2571	2	slaps
slats	5	54	3690	2	slats
slaws	8	52	2271	2	slaws
slay	7	64	3638	2	slay_
soys	7	52	3393	2	soys
spays	10	55	2051	2	spays
splays	11	49	1087	2	splays
stays	8	60	2202	2	stays
sways	11	55	1846	2	sways
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
toys	7	80	3634	2	toys
trays	8	56	2343	2	trays
ulans	5	49	2130	2	ulans
unlays	9	38	1049	2	unlays
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
wags	8	61	4055	2	wags
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
way	9	67	5766	2	way_
whys	13	70	1166	2	whys
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
yay	9	69	4871	2	yay_
zags	14	68	2668	2	zags
zaps	15	68	2689	2	zaps
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	457	1.030	29001.9
3	Display Results	457	457	0.110	4154.5
	(SQL Overall)	178691	457	1.220	146468.0