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

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

385 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
amas	6	77	4629	(None)
aas	3	109	7539	1	a_as
abas	6	86	4208	1	abas
agas	5	59	3884	1	agas
agmas	8	59	1987	1	agmas
alas	4	63	5812	1	alas
almas	7	66	2977	1	almas
ama	5	108	5330	1	ama_
amah	9	89	2748	1	amah
amahs	10	78	1906	1	amahs
amass	7	71	1968	1	amass
amias	7	58	3146	1	amias
amis	6	64	4531	1	amis
amps	8	62	3034	1	amps
amus	6	55	2961	1	amus
anas	4	66	4986	1	anas
atmas	7	57	2101	1	atmas
camas	9	63	3352	1	camas
gamas	8	54	3135	1	gamas
lamas	7	55	3279	1	lamas
mamas	9	59	3077	1	mamas
mas	5	81	7581	1	_mas
aa	2	191	7995	2	a_a_
aah	6	162	5296	2	a_ah
aahs	7	164	2856	2	aahs
aal	3	90	5867	2	a_al
aals	4	99	4114	2	aals
aba	5	128	5095	2	aba_
abase	7	60	2348	2	abase
abash	10	60	1651	2	abash
abbas	9	59	1864	2	abbas
abomas	10	11	1358	2	abomas
abos	6	77	3441	2	abos
abs	5	93	5607	2	a_bs
abys	9	72	2188	2	abys
aces	6	76	4509	2	aces
acmes	9	60	2065	2	acmes
acts	6	69	2986	2	acts
adds	6	76	2245	2	adds
adman	8	45	1790	2	adman
admass	9	5	714	2	admass
ados	5	76	3351	2	ados
ads	4	97	5573	2	a_ds
afar	7	67	2078	2	afar
afars	8	57	1651	2	afars
aga	4	104	4723	2	aga_
agamas	9	74	1344	2	agamas
agar	5	87	2641	2	agar
agars	6	61	2064	2	agars
ages	5	58	4459	2	ages
aghas	9	70	1487	2	aghas
agma	7	76	2326	2	agma_
ags	4	75	5166	2	a_gs
aha	6	112	4664	2	aha_
ahis	7	61	3538	2	ahis
ahs	6	86	4482	2	a_hs
aids	5	78	4635	2	aids
ails	4	56	5471	2	ails
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
airs	4	64	4742	2	airs
ais	3	90	8357	2	a_is
aits	4	63	5553	2	aits
ajar	11	62	1770	2	ajar
ala	3	124	6360	2	ala_
alae	4	56	4375	2	alae
alan	4	68	4408	2	alan
alans	5	56	3617	2	alans
alar	4	63	4007	2	alar
albas	7	59	2539	2	albas
albs	6	86	2857	2	albs
ales	4	70	6710	2	ales
alfas	8	72	1904	2	alfas
algas	6	56	2493	2	algas
alias	5	58	3460	2	alias
alls	4	67	4092	2	alls
alma	6	63	3302	2	alma_
almah	10	69	1725	2	almah
almahs	11	86	1161	2	almahs
almes	7	51	2654	2	almes
alms	6	58	3492	2	alms
alps	6	55	2924	2	alps
als	3	66	6302	2	a_ls
alts	4	66	3990	2	alts
am	4	118	7556	2	am__
amain	7	49	2288	2	amain
amaze	16	60	1660	2	amaze
amazes	17	56	1347	2	amazes
ambo	8	82	2513	2	ambo
ambos	9	53	2124	2	ambos
amebas	10	3	1145	2	amebas
amen	6	67	3315	2	amen
amens	7	56	2484	2	amens
ami	5	66	4680	2	am_i
amia	6	68	3689	2	amia
amid	7	70	3633	2	amid
amids	8	56	2750	2	amids
amie	6	63	3984	2	amie
amies	7	68	3768	2	amies
amigas	9	59	1216	2	amigas
amin	6	60	4224	2	amin
amins	7	55	3431	2	amins
amir	6	51	2974	2	amir
amirs	7	59	2491	2	amirs
amiss	7	58	2306	2	amiss
ammo	8	55	2013	2	ammo
ammos	9	48	1582	2	ammos
amok	10	2	1740	2	amok
amoks	11	4	1355	2	amoks
amp	7	75	4102	2	am_p
amu	5	82	3732	2	am_u
amuse	7	59	2083	2	amuse
amyl	9	55	1509	2	amyl
amyls	10	45	1268	2	amyls
ana	3	95	5982	2	ana_
anal	4	80	3752	2	anal
ands	5	78	3361	2	ands
anes	4	52	5593	2	anes
angas	6	58	2798	2	angas
animas	8	44	1872	2	animas
anis	4	57	4646	2	anis
anlas	5	56	2693	2	anlas
annas	5	58	2488	2	annas
anoas	5	72	2649	2	anoas
ansa	4	59	2777	2	ansa
antas	5	54	3203	2	antas
ants	4	72	4347	2	ants
anus	4	71	3111	2	anus
apes	6	60	4743	2	apes
apos	6	54	3382	2	apos
apps	8	63	1969	2	apps
aquas	14	24	1261	2	aquas
arak	8	69	2957	2	arak
araks	9	48	2088	2	araks
arbs	6	68	3473	2	arbs
arcs	6	78	3478	2	arcs
areas	5	59	3577	2	areas
ares	4	58	7102	2	ares
arfs	7	60	2996	2	arfs
arias	5	54	3802	2	arias
arks	8	59	3687	2	arks
arms	6	61	3749	2	arms
aromas	8	10	1861	2	aromas
arras	5	56	2613	2	arras
ars	3	76	7093	2	a_rs
arts	4	96	5026	2	arts
as	2	110	8307	2	__as
asks	8	57	2121	2	asks
asps	6	56	2209	2	asps
ass	3	78	4406	2	a_ss
atap	6	67	2245	2	atap
ataps	7	64	1483	2	ataps
ates	4	50	4792	2	ates
atlas	5	58	2158	2	atlas
atma	6	81	2177	2	atma_
atman	7	55	2014	2	atman
atmans	8	44	1396	2	atmans
auks	8	55	2526	2	auks
auras	5	59	3255	2	auras
ava	6	101	3932	2	ava_
avast	8	55	1936	2	avast
aves	7	61	4260	2	aves
avgas	9	69	1213	2	avgas
avos	7	72	2701	2	avos
awa	6	119	3967	2	awa_
awash	11	66	1316	2	awash
away	10	80	2422	2	away
awes	7	60	3755	2	awes
awls	7	59	2609	2	awls
awns	7	53	2443	2	awns
axal	11	65	2049	2	axal
axes	11	73	3785	2	axes
axis	11	61	2791	2	axis
axman	14	48	1318	2	axman
ayah	10	80	2299	2	ayah
ayahs	11	68	1352	2	ayahs
ayes	7	65	4351	2	ayes
ays	6	70	5029	2	a_ys
azan	13	65	2178	2	azan
azans	14	65	1688	2	azans
baas	6	68	4467	2	baas
babas	9	63	2573	2	babas
balas	7	69	3721	2	balas
bams	8	70	4445	2	bam_s
bas	5	86	8175	2	_bas
bemas	9	64	2428	2	bemas
bias	6	47	3815	2	bias
bimas	9	55	2174	2	bimas
boas	6	61	5083	2	boas
bras	6	57	4645	2	bras
cacas	9	56	2798	2	cacas
camass	10	41	1418	2	camass
cames	9	70	4731	2	cames
camos	9	59	2761	2	camos
camps	11	63	3026	2	camps
cams	8	70	4728	2	cam_s
casas	7	53	2784	2	casas
comas	9	58	3300	2	comas
cymas	12	64	1788	2	cymas
dadas	7	58	1986	2	dadas
daman	8	48	2116	2	daman
damans	9	47	1598	2	damans
damar	8	41	1773	2	damar
damars	9	38	1499	2	damars
damask	13	3	584	2	damask
dames	8	54	3585	2	dames
damns	8	49	1692	2	damns
damps	10	52	2041	2	damps
dams	7	74	4437	2	dam_s
dramas	9	58	1465	2	dramas
dumas	8	54	2043	2	dumas
emes	6	54	3466	2	emes
ems	5	64	3549	2	em_s
emus	6	68	2168	2	emus
eras	4	54	4150	2	eras
etas	4	64	3227	2	etas
eyas	7	64	2743	2	eyas
fames	10	57	3592	2	fames
fas	6	82	6293	2	_fas
favas	11	56	1859	2	favas
galas	6	57	3164	2	galas
gama	7	70	3551	2	gama_
gamay	11	64	1910	2	gamay
gamays	12	63	1090	2	gamays
gambas	11	58	1751	2	gambas
gambs	10	57	2112	2	gambs
games	8	62	3855	2	games
gammas	11	57	1469	2	gammas
gamps	10	53	2371	2	gamps
gams	7	66	4888	2	gam_s
gas	4	88	7025	2	_gas
goas	5	52	3994	2	goas
gramas	9	43	1720	2	gramas
hahas	11	71	1844	2	hahas
halmas	11	70	1789	2	halmas
hamal	10	46	2310	2	hamal
hamals	11	48	1681	2	hamals
hames	10	61	3870	2	hames
hams	9	64	4613	2	ham_s
hamzas	20	11	901	2	hamzas
has	6	73	7265	2	_has
iambs	9	58	1505	2	iambs
imam	8	17	1832	2	imam
imams	9	15	1110	2	imams
imps	8	62	2111	2	imps
jambs	16	60	1462	2	jambs
jams	13	52	3107	2	jam_s
javas	15	59	1542	2	javas
kaas	8	65	3184	2	kaas
kakas	8	51	1734	2	kakas
kames	11	50	2469	2	kames
kanas	9	53	2691	2	kanas
kapas	11	60	2173	2	kapas
karmas	12	30	1373	2	karmas
kas	7	70	5858	2	_kas
katas	9	59	2209	2	katas
kavas	12	59	1995	2	kavas
keas	8	63	3709	2	keas
koas	8	56	3509	2	koas
kvas	11	70	1594	2	kvas
lama	6	66	3529	2	lama_
lambs	9	59	2141	2	lambs
lames	7	54	4554	2	lames
lamias	8	50	2061	2	lamias
lampas	10	66	1595	2	lampas
lamps	9	56	2483	2	lamps
lams	6	65	5226	2	lam_s
las	3	72	8147	2	_las
lavas	8	54	2222	2	lavas
leas	4	59	5418	2	leas
limas	7	56	2763	2	limas
llamas	8	8	897	2	llamas
lumas	7	56	2291	2	lumas
ma	4	100	6065	2	_ma_
maar	6	60	2505	2	maar
maars	7	46	2163	2	maars
mac	7	80	5392	2	_mac
macs	8	67	4250	2	macs
mad	6	89	5870	2	_mad
mads	7	68	4536	2	mads
mae	5	76	5910	2	_mae
maes	6	69	4839	2	maes
mag	6	79	5647	2	_mag
magmas	11	55	1250	2	magmas
mags	7	54	4452	2	mags
mama	8	62	3158	2	mama_
mambas	12	57	1624	2	mambas
mammas	9	46	1640	2	mammas
man	5	74	6585	2	_man
manas	7	62	4042	2	manas
mans	6	63	5453	2	mans
map	7	72	5511	2	_map
maps	8	61	4104	2	maps
mar	5	79	6594	2	_mar
maras	7	54	4328	2	maras
mars	6	62	6186	2	mars
masa	6	50	3471	2	_masa
masas	7	56	3041	2	masas
mash	9	60	3939	2	_mash
mask	10	52	2735	2	_mask
mass	6	60	4493	2	mass
mast	6	59	5995	2	_mast
mat	5	80	8393	2	_mat
mats	6	54	6028	2	mats
maw	8	70	5009	2	_maw
maws	9	64	3713	2	maws
max	12	90	4544	2	_max
may	8	87	5762	2	_may
mayas	10	59	2438	2	mayas
mays	9	69	4002	2	mays
mis	5	81	6261	2	_mis
moas	6	55	4534	2	moas
mos	5	70	6712	2	_mos
mus	5	59	4675	2	_mus
nadas	6	63	2081	2	nadas
nalas	5	55	2836	2	nalas
names	7	48	3336	2	names
nanas	5	59	2863	2	nanas
napas	7	59	2435	2	napas
nemas	7	53	2157	2	nemas
nomas	7	47	2641	2	nomas
obas	6	57	3093	2	obas
ocas	6	67	2963	2	ocas
odas	5	72	3026	2	odas
okas	8	52	2539	2	okas
omasa	7	4	948	2	omasa
oms	5	63	3751	2	om_s
pacas	9	60	2940	2	pacas
pampas	12	49	1399	2	pampas
pams	8	56	4176	2	pam_s
papas	9	49	2749	2	papas
paras	7	61	4304	2	paras
pas	5	87	7574	2	_pas
peas	6	57	5506	2	peas
pias	6	65	4255	2	pias
pimas	9	47	2510	2	pimas
pumas	9	51	2156	2	pumas
pyas	9	62	2570	2	pyas
ragas	6	53	2606	2	ragas
raias	5	46	3112	2	raias
rajas	12	73	1772	2	rajas
ramal	7	46	2224	2	ramal
ramps	9	62	2463	2	ramps
rams	6	59	5077	2	ram_s
ramus	7	64	1828	2	ramus
ras	3	75	7539	2	_ras
rayas	8	59	2205	2	rayas
rias	4	55	4059	2	rias
ryas	7	72	2461	2	ryas
sagas	6	60	2588	2	sagas
sambas	10	42	1926	2	sambas
samps	9	61	2467	2	samps
seas	4	57	5527	2	seas
shamas	11	37	1793	2	shamas
simas	7	57	2755	2	simas
skas	8	53	2571	2	skas
smash	10	48	1443	2	smash
somas	7	60	3037	2	somas
spas	6	70	3672	2	spas
takas	9	55	2068	2	takas
talas	5	59	3589	2	talas
tamal	7	35	2261	2	tamal
tamals	8	41	1662	2	tamals
tames	7	52	4201	2	tames
tamis	7	67	2872	2	tamis
tamps	9	55	2408	2	tamps
tams	6	72	4793	2	tam_s
tapas	7	46	2771	2	tapas
tas	3	84	7710	2	_tas
teas	4	58	5149	2	teas
twas	7	68	2408	2	twas
ulamas	8	9	1045	2	ulamas
umps	8	57	2194	2	umps
upas	6	83	2238	2	upas
utas	4	59	2495	2	utas
vamps	12	54	1548	2	vamps
varas	8	60	2819	2	varas
vas	6	77	5577	2	_vas
wames	10	64	3280	2	wames
wamus	10	55	1468	2	wamus
was	6	87	6756	2	_was
yams	9	53	3073	2	yam_s
yeas	7	86	3842	2	yeas
zamias	17	42	1292	2	zamias
zas	12	69	4683	2	_zas

Search took 4 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.140	1276364.3
2	DLD Change Limit	29872	385	2.250	13276.4
3	Display Results	385	385	0.266	1447.4
	(SQL Overall)	178691	385	2.656	67278.2