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

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

569 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
lams	6	65	5226	(None)
alms	6	58	3492	1	alms
bams	8	70	4445	1	bams
blams	9	50	2385	1	blams
cams	8	70	4728	1	cams
clams	9	51	2767	1	clams
dams	7	74	4437	1	dams
flams	10	51	2501	1	flams
gams	7	66	4888	1	gams
glams	8	58	2293	1	glams
hams	9	64	4613	1	hams
jams	13	52	3107	1	jams
labs	6	71	4512	1	labs
lacs	6	69	4248	1	lacs
lads	5	65	4913	1	lads
lags	5	65	4622	1	lags
lam	5	76	6671	1	lam_
lama	6	66	3529	1	lama
lamas	7	55	3279	1	lamas
lamb	8	68	3214	1	lamb
lambs	9	59	2141	1	lambs
lame	6	68	4929	1	lame
lames	7	54	4554	1	lames
lamp	8	62	3382	1	lamp
lamps	9	56	2483	1	lamps
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
lays	7	60	4325	1	lays
loams	7	56	1986	1	loams
lums	6	57	3424	1	lums
pams	8	56	4176	1	pams
rams	6	59	5077	1	rams
slams	7	49	2790	1	slams
tams	6	72	4793	1	tams
yams	9	53	3073	1	yams
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
aims	6	77	3818	2	aims
ais	3	90	8357	2	_ais
alamo	7	4	1814	2	alamo
alamos	8	4	1500	2	alamos
alans	5	56	3617	2	alans
alarms	8	59	1305	2	alarms
alas	4	63	5812	2	alas
albs	6	86	2857	2	albs
ales	4	70	6710	2	ales
alls	4	67	4092	2	alls
alma	6	63	3302	2	alma
almas	7	66	2977	2	almas
alme	6	58	3216	2	alme
almes	7	51	2654	2	almes
alps	6	55	2924	2	alps
als	3	66	6302	2	_als
alts	4	66	3990	2	alts
alums	7	57	2060	2	alums
am	4	118	7556	2	_am_
ama	5	108	5330	2	_ama
amas	6	77	4629	2	_amas
ami	5	66	4681	2	_ami
amis	6	64	4532	2	_amis
amp	7	75	4102	2	_amp
amps	8	62	3034	2	_amps
amu	5	82	3732	2	_amu
amus	6	55	2961	2	_amus
arms	6	61	3749	2	arms
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
bags	7	66	4550	2	bags
balms	9	57	2392	2	balms
bals	6	63	5404	2	bals
bam	7	85	6014	2	bam_
bans	6	65	5514	2	bans
baps	8	60	4084	2	baps
barms	9	61	2846	2	barms
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
beams	9	53	2817	2	beams
blabs	9	56	1963	2	blabs
blahs	10	56	1651	2	blahs
blam	8	61	3170	2	blam_
blame	9	56	2549	2	blame
blames	10	51	2186	2	blames
blats	7	51	3250	2	blats
blaws	10	56	2046	2	blaws
bums	8	59	3459	2	bums
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
calms	9	52	2235	2	calms
cam	7	80	5898	2	cam_
camas	9	63	3352	2	camas
came	8	76	4875	2	came
cames	9	70	4731	2	cames
camo	8	57	3175	2	camo
camos	9	59	2761	2	camos
camp	10	63	3645	2	camp
camps	11	63	3026	2	camps
cans	6	50	5085	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
chams	12	60	2850	2	chams
clads	8	57	2273	2	clads
clags	8	56	2112	2	clags
claims	10	52	1157	2	claims
clam	8	63	3229	2	clam_
clamp	11	55	1765	2	clamp
clamps	12	45	1508	2	clamps
clans	7	50	3101	2	clans
claps	9	56	2618	2	claps
class	7	55	2548	2	class
claws	10	60	2083	2	claws
clays	10	55	2133	2	clays
crams	9	62	2915	2	crams
cwms	11	43	957	2	cwms
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
daks	9	71	3060	2	daks
dals	5	71	4512	2	dals
dam	6	74	5704	2	dam_
dame	7	71	4031	2	dame
dames	8	54	3585	2	dames
damn	7	57	2432	2	damn
damns	8	49	1692	2	damns
damp	9	62	2884	2	damp
damps	10	52	2041	2	damps
dans	5	67	4815	2	dans
daps	7	72	3916	2	daps
daws	8	66	3824	2	daws
days	8	76	3713	2	days
dims	7	54	3502	2	dims
doms	7	62	3957	2	doms
drams	8	60	2583	2	drams
ears	4	63	5659	2	ears
eats	4	70	5487	2	eats
elans	5	55	2775	2	elans
elms	6	73	2270	2	elms
ems	5	64	3549	2	_ems
exams	14	19	908	2	exams
fabs	9	86	3586	2	fabs
fads	8	69	3987	2	fads
fags	8	69	3912	2	fags
fame	9	56	3939	2	fame
fames	10	57	3592	2	fames
fans	7	62	4737	2	fans
farms	10	63	2495	2	farms
fas	6	82	6293	2	fa_s
fats	7	62	5250	2	fats
fays	10	85	3536	2	fays
fems	9	64	2870	2	fems
flabs	10	58	1864	2	flabs
flags	9	53	2128	2	flags
flam	9	63	3329	2	flam_
flame	10	51	2444	2	flame
flames	11	47	2369	2	flames
flamy	13	52	1747	2	flamy
flans	8	53	2797	2	flans
flaps	10	56	2138	2	flaps
flats	8	64	2974	2	flats
flaws	11	59	2034	2	flaws
flays	11	63	2105	2	flays
fleams	11	50	1194	2	fleams
foams	10	50	1795	2	foams
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
gam	6	70	6006	2	gam_
gama	7	70	3552	2	gama
gamas	8	54	3136	2	gamas
gamb	9	63	3184	2	gamb
gambs	10	57	2112	2	gambs
game	7	66	4432	2	game
games	8	62	3855	2	games
gamp	9	88	3321	2	gamp
gamps	10	53	2371	2	gamps
gamy	10	54	2753	2	gamy
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
gaums	8	62	1707	2	gaums
gays	8	73	3802	2	gays
gems	7	53	2911	2	gems
glads	7	56	2061	2	glads
glam	7	65	2934	2	glam_
glans	6	51	2583	2	glans
glass	6	55	1813	2	glass
gleams	9	48	1225	2	gleams
glims	8	74	1767	2	glims
gloams	9	52	1066	2	gloams
gloms	8	52	1978	2	gloms
glums	8	46	2142	2	glums
grams	8	53	2731	2	grams
gums	7	50	3094	2	gums
gyms	10	75	1459	2	gyms
haems	10	55	1701	2	haems
haes	7	76	5102	2	haes
hags	8	67	4084	2	hags
hahs	10	83	3336	2	hahs
halms	10	52	2521	2	halms
ham	8	63	6328	2	ham_
hame	9	70	4313	2	hame
hames	10	61	3870	2	hames
haps	9	64	4346	2	haps
harms	10	68	2901	2	harms
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
hems	9	55	3494	2	hems
hims	9	52	3097	2	hims
hums	9	68	3142	2	hums
iamb	8	66	2373	2	iamb
iambs	9	58	1506	2	iambs
imams	9	15	1111	2	imams
isms	6	62	1347	2	isms
jabs	13	58	3009	2	jabs
jags	12	61	3279	2	jags
jam	12	69	4252	2	jam_
jamb	15	55	2385	2	jamb
jambs	16	60	1462	2	jambs
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
kafs	11	64	2374	2	kafs
kalams	12	3	1060	2	kalams
kame	10	57	2823	2	kame
kames	11	50	2469	2	kames
kami	10	58	2364	2	kami
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kays	11	60	3219	2	kays
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
lamby	12	51	1484	2	lamby
lamed	8	52	3529	2	lamed
lameds	9	48	1203	2	lameds
lamer	7	52	3370	2	lamer
lamest	8	47	2276	2	lamest
lamia	7	53	2432	2	lamia
lamias	8	50	2061	2	lamias
lampas	10	66	1595	2	lampas
land	5	63	3731	2	land
lands	6	54	2690	2	lands
lane	4	51	5333	2	lane
lanes	5	49	4679	2	lanes
lang	5	66	3738	2	lang
lank	8	47	3445	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
larums	8	36	1053	2	larums
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
lay	6	88	6535	2	la_y
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
leys	7	64	3018	2	leys
liars	5	47	2316	2	liars
libs	6	67	3276	2	libs
lids	5	63	3645	2	lids
lies	4	64	5419	2	lies
lima	6	57	3413	2	lima
limas	7	56	2763	2	limas
limb	8	54	2938	2	limb
limbs	9	61	1894	2	limbs
lime	6	62	4493	2	lime
limes	7	56	3650	2	limes
limn	6	65	2769	2	limn
limns	7	57	1839	2	limns
limo	6	55	2973	2	limo
limos	7	53	2081	2	limos
limp	8	84	3249	2	limp
limps	9	55	2267	2	limps
limy	9	57	2771	2	limy
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
llama	7	9	989	2	llama
llamas	8	8	897	2	llamas
loads	6	53	2337	2	loads
loafs	8	56	1699	2	loafs
loam	6	56	3048	2	loam_
loamy	10	59	1334	2	loamy
loans	5	60	2646	2	loans
lobs	6	64	4108	2	lobs
logs	5	73	4311	2	logs
looms	7	51	2464	2	looms
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
lum	5	55	4293	2	lum_
luma	6	55	2752	2	luma
lumas	7	56	2291	2	lumas
lump	8	65	3170	2	lump
lumps	9	56	2498	2	lumps
luvs	7	58	1850	2	luvs
lyes	7	55	3083	2	lyes
macs	8	67	4251	2	macs
mads	7	68	4537	2	mads
maes	6	69	4840	2	maes
mags	7	54	4453	2	mags
maims	9	63	2179	2	maims
malms	9	50	2155	2	malms
mama	8	62	3159	2	mama
mamas	9	59	3077	2	mamas
mans	6	63	5455	2	mans
maps	8	61	4105	2	maps
mars	6	62	6187	2	mars
mas	5	81	7582	2	ma_s
mass	6	60	4494	2	mass
mats	6	54	6029	2	mats
maws	9	64	3714	2	maws
mays	9	69	4003	2	mays
mems	8	59	3150	2	mems
moms	8	65	3948	2	moms
mums	8	57	3277	2	mums
nabs	6	62	3619	2	nabs
nags	5	54	3602	2	nags
nam	5	59	5339	2	nam_
name	6	56	3741	2	name
names	7	48	3336	2	names
nans	4	61	3940	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nays	7	59	3159	2	nays
nims	6	62	2688	2	nims
noms	6	56	3640	2	noms
oafs	7	64	2526	2	oafs
oaks	8	65	2790	2	oaks
oars	4	68	4603	2	oars
oats	4	65	5421	2	oats
ogams	8	41	1268	2	ogams
ohms	9	55	1403	2	ohms
oms	5	63	3751	2	_oms
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
palms	9	49	2175	2	palms
pals	6	69	5135	2	pals
pam	7	78	5839	2	pam_
pans	6	58	5573	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
plans	7	57	3127	2	plans
plasm	9	41	1463	2	plasm
plasms	10	37	1133	2	plasms
plats	7	55	3137	2	plats
plays	10	63	2077	2	plays
plums	9	46	1995	2	plums
poms	8	70	3774	2	poms
prams	9	61	2551	2	prams
qats	13	53	3134	2	qats
rads	5	60	4660	2	rads
rags	5	54	4837	2	rags
rais	4	52	5262	2	rais
ram	5	68	6727	2	ram_
rami	6	60	3409	2	rami
ramp	8	59	3400	2	ramp
ramps	9	62	2463	2	ramps
ramus	7	64	1828	2	ramus
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
reams	7	57	2962	2	reams
rems	6	62	3772	2	rems
rims	6	59	3630	2	rims
roams	7	49	1961	2	roams
roms	6	70	3896	2	roms
rums	6	48	3347	2	rums
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
sags	5	59	4840	2	sags
sals	4	68	5167	2	sals
same	6	52	4564	2	same
samp	8	57	3359	2	samp
samps	9	61	2467	2	samps
sans	4	51	5336	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
scams	9	44	2397	2	scams
seams	7	57	3166	2	seams
shams	10	58	2941	2	shams
sims	6	57	3717	2	sims
slabs	7	53	2264	2	slabs
slags	6	65	2590	2	slags
slam	6	77	3797	2	slam_
slaps	7	60	2571	2	slaps
slats	5	54	3690	2	slats
slaws	8	52	2271	2	slaws
slays	8	57	2368	2	slays
slims	7	54	2365	2	slims
slums	7	46	2343	2	slums
soms	6	62	3937	2	soms
spams	9	49	2219	2	spams
sums	6	58	3758	2	sums
tabs	6	68	4298	2	tabs
tads	5	71	4394	2	tads
tags	5	55	4523	2	tags
tam	5	86	6342	2	tam_
tame	6	63	4366	2	tame
tames	7	52	4201	2	tames
tamis	7	67	2873	2	tamis
tamp	8	61	3300	2	tamp
tamps	9	55	2408	2	tamps
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
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
teams	7	57	2651	2	teams
toms	6	83	4349	2	toms
trams	7	53	2767	2	trams
ulama	7	7	1147	2	ulama
ulamas	8	9	1045	2	ulamas
ulans	5	49	2130	2	ulans
vacs	9	62	2620	2	vacs
vamp	11	55	2154	2	vamp
vamps	12	54	1548	2	vamps
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
vims	9	54	2331	2	vims
wabs	9	73	3723	2	wabs
wads	8	73	4314	2	wads
waes	7	60	4860	2	waes
wags	8	61	4055	2	wags
wame	9	50	3548	2	wame
wames	10	64	3280	2	wames
wamus	10	55	1468	2	wamus
wans	7	64	5227	2	wans
waps	9	66	4208	2	waps
warms	10	77	2685	2	warms
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
whams	13	55	1564	2	whams
yags	8	66	3229	2	yags
yaks	11	60	2520	2	yaks
yam	8	74	4899	2	yam_
yaps	9	59	3352	2	yaps
yaws	10	55	3121	2	yaws
yays	10	57	2891	2	yays
ylems	10	3	926	2	ylems
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.076	2351197.4
2	DLD Change Limit	29872	569	0.910	32826.4
3	Display Results	569	569	0.123	4626.0
	(SQL Overall)	178691	569	1.109	161128.0