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

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

383 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
amis	6	64	4532	(None)
ahis	7	61	3538	1	ahis
aims	6	77	3818	1	aims
ais	3	90	8357	1	a_is
amas	6	77	4629	1	amas
ami	5	66	4681	1	ami_
amia	6	68	3690	1	amia
amias	7	58	3147	1	amias
amid	7	70	3635	1	amid
amids	8	56	2751	1	amids
amie	6	63	3985	1	amie
amies	7	68	3769	1	amies
amin	6	60	4225	1	amin
amins	7	55	3432	1	amins
amir	6	51	2975	1	amir
amirs	7	59	2492	1	amirs
amiss	7	58	2307	1	amiss
amps	8	62	3034	1	amps
amus	6	55	2961	1	amus
anis	4	57	4646	1	anis
axis	11	61	2791	1	axis
mis	5	81	6262	1	_mis
tamis	7	67	2873	1	tamis
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	a_as
abas	6	86	4208	2	abas
abos	6	77	3441	2	abos
abris	7	57	2260	2	abris
abs	5	93	5607	2	a_bs
abys	9	72	2188	2	abys
aces	6	76	4509	2	aces
acid	7	75	3339	2	acid
acids	8	71	2100	2	acids
acmes	9	60	2065	2	acmes
acmic	11	3	1233	2	acmic
acts	6	69	2986	2	acts
adds	6	76	2245	2	adds
adios	6	58	2286	2	adios
adit	5	64	4365	2	adit
adits	6	65	2371	2	adits
admit	8	3	1949	2	admit
admits	9	4	1141	2	admits
admix	15	5	773	2	admix
ados	5	76	3351	2	ados
ads	4	97	5573	2	a_ds
aegis	6	3	1678	2	aegis
agas	5	59	3884	2	agas
ages	5	58	4459	2	ages
agin	5	61	3271	2	agin
agio	5	78	2845	2	agio
agios	6	59	1986	2	agios
agism	8	46	1406	2	agism
agist	6	63	2558	2	agist
agmas	8	59	1987	2	agmas
ags	4	75	5166	2	a_gs
ahi	6	80	4023	2	ahi_
ahs	6	86	4482	2	a_hs
ai	2	112	8839	2	a_i_
aid	4	92	6908	2	a_id
aids	5	78	4636	2	aids
ail	3	71	7104	2	a_il
ails	4	56	5471	2	ails
aim	5	78	5821	2	a_im
ain	3	75	7909	2	a_in
ains	4	61	5888	2	ains
air	3	80	5839	2	a_ir
airs	4	64	4742	2	airs
ait	3	80	9390	2	a_it
aits	4	63	5553	2	aits
akin	8	63	2803	2	akin
alas	4	63	5812	2	alas
albs	6	86	2857	2	albs
ales	4	70	6710	2	ales
alias	5	58	3460	2	alias
alif	7	62	4214	2	alif
alifs	8	61	2126	2	alifs
alist	5	61	3678	2	alist
alit	4	61	5569	2	alit
alls	4	67	4092	2	alls
almas	7	66	2977	2	almas
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__
ama	5	108	5330	2	am_a
amah	9	89	2749	2	amah
amahs	10	78	1906	2	amahs
amain	7	49	2291	2	amain
amass	7	71	1968	2	amass
ambit	9	42	2371	2	ambit
ambits	10	37	1341	2	ambits
ambo	8	82	2514	2	ambo
ambos	9	53	2125	2	ambos
amen	6	67	3315	2	amen
amens	7	56	2484	2	amens
amice	9	61	2287	2	amice
amices	10	50	1801	2	amices
amici	9	42	1739	2	amici
amicus	10	38	1000	2	amicus
amide	8	61	2848	2	amide
amides	9	57	2266	2	amides
amido	8	57	2098	2	amido
amidst	9	49	1323	2	amidst
amiga	8	55	1481	2	amiga
amigas	9	59	1217	2	amigas
amigo	8	65	1547	2	amigo
amigos	9	45	1121	2	amigos
amine	7	58	3538	2	amine
amines	8	47	2798	2	amines
amino	7	54	2550	2	amino
amity	10	4	1609	2	amity
ammo	8	55	2013	2	ammo
ammos	9	48	1582	2	ammos
amnia	7	59	1864	2	amnia
amnic	9	55	1624	2	amnic
amnio	7	52	1805	2	amnio
amnios	8	49	1252	2	amnios
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	1510	2	amyl
amyls	10	45	1269	2	amyls
anas	4	66	4986	2	anas
ands	5	78	3361	2	ands
anes	4	52	5593	2	anes
ani	3	77	5118	2	ani_
anil	4	64	3743	2	anil
anils	5	63	2672	2	anils
animis	8	46	1594	2	animis
anise	5	51	2970	2	anise
antis	5	50	3331	2	antis
ants	4	72	4347	2	ants
anus	4	71	3111	2	anus
apes	6	60	4743	2	apes
aphis	10	59	1713	2	aphis
apish	10	51	1663	2	apish
apos	6	54	3382	2	apos
apps	8	63	1969	2	apps
apsis	7	57	1829	2	apsis
arbs	6	68	3473	2	arbs
arcs	6	78	3478	2	arcs
ares	4	58	7102	2	ares
arfs	7	60	2996	2	arfs
aria	4	62	4542	2	aria
arias	5	54	3802	2	arias
arid	5	76	4271	2	arid
aril	4	58	4302	2	aril
arils	5	87	3220	2	arils
arise	5	64	3643	2	arise
arks	8	59	3687	2	arks
armies	8	51	2369	2	armies
arms	6	61	3749	2	arms
arris	5	68	2468	2	arris
ars	3	76	7093	2	a_rs
arsis	5	57	2242	2	arsis
arts	4	96	5026	2	arts
as	2	110	8307	2	a__s
asks	8	57	2121	2	asks
aspis	7	46	1814	2	aspis
asps	6	56	2209	2	asps
ass	3	78	4406	2	a_ss
ates	4	50	4792	2	ates
atmas	7	57	2101	2	atmas
auks	8	55	2526	2	auks
auris	5	53	3153	2	auris
aves	7	61	4260	2	aves
avid	8	83	2596	2	avid
aviso	8	57	1396	2	aviso
avos	7	72	2701	2	avos
awes	7	60	3755	2	awes
awls	7	59	2609	2	awls
awns	7	53	2443	2	awns
axes	11	73	3785	2	axes
axil	11	64	2445	2	axil
axils	12	72	1750	2	axils
ayes	7	65	4351	2	ayes
ayin	7	63	3174	2	ayin
ayins	8	53	2161	2	ayins
ays	6	70	5029	2	a_ys
bams	8	70	4445	2	bam_s
basis	7	54	2986	2	basis
bis	5	68	6066	2	_bis
bris	6	55	3961	2	bris
cadis	8	44	2850	2	cadis
camas	9	63	3352	2	camas
cames	9	70	4731	2	cames
camisa	10	31	1432	2	camisa
camise	10	33	1963	2	camise
camos	9	59	2761	2	camos
camps	11	63	3026	2	camps
cams	8	70	4728	2	cam_s
chis	9	59	3331	2	chis
cis	5	77	4803	2	_cis
cris	6	62	3343	2	cris
dais	5	70	4070	2	dais
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
dims	7	54	3502	2	dims
dis	4	64	5989	2	_dis
egis	5	65	2065	2	egis
emes	6	54	3466	2	emes
emic	8	64	2275	2	emic
emir	6	59	1870	2	emir
emirs	7	61	1616	2	emirs
emit	6	54	3842	2	emit
emits	7	54	2147	2	emits
ems	5	64	3549	2	em_s
emus	6	68	2168	2	emus
fames	10	57	3592	2	fames
famish	14	3	1184	2	famish
gadis	7	48	2529	2	gadis
gamas	8	54	3136	2	gamas
gambs	10	57	2112	2	gambs
games	8	62	3855	2	games
gamic	10	39	1620	2	gamic
gamin	8	44	2300	2	gamin
gamins	9	44	2005	2	gamins
gamps	10	53	2371	2	gamps
gams	7	66	4888	2	gam_s
ghis	8	50	2016	2	ghis
hajis	15	67	1628	2	hajis
hames	10	61	3870	2	hames
hams	9	64	4613	2	ham_s
hims	9	52	3097	2	hims
his	6	63	5950	2	_his
iambs	9	58	1506	2	iambs
ibis	6	65	1958	2	ibis
imid	7	61	2229	2	imid
imids	8	60	1514	2	imids
impis	9	62	1385	2	impis
imps	8	62	2112	2	imps
iris	4	57	3255	2	iris
is	2	70	4821	2	__is
iwis	7	71	1701	2	iwis
jambs	16	60	1462	2	jambs
jams	13	52	3107	2	jam_s
kadis	10	59	2106	2	kadis
kakis	8	61	1684	2	kakis
kames	11	50	2469	2	kames
kami	10	58	2364	2	kami_
kamik	10	50	1155	2	kamik
kamiks	11	38	791	2	kamiks
khis	11	70	1798	2	khis
kis	7	80	5148	2	_kis
kois	8	51	2940	2	kois
kris	8	64	2360	2	kris
lamas	7	55	3279	2	lamas
lambs	9	59	2141	2	lambs
lames	7	54	4554	2	lames
lamia	7	53	2432	2	lamia
lamias	8	50	2061	2	lamias
lamps	9	56	2483	2	lamps
lams	6	65	5226	2	lam_s
lapis	7	62	2315	2	lapis
laris	5	47	3746	2	laris
leis	4	57	3960	2	leis
lis	3	71	6227	2	_lis
macs	8	67	4251	2	macs
mads	7	68	4537	2	mads
maes	6	69	4840	2	maes
mags	7	54	4453	2	mags
maid	7	55	3766	2	maid
maids	8	63	2714	2	maids
mail	6	55	4345	2	mail
mails	7	60	3778	2	mails
maim	8	58	3149	2	maim
maims	9	63	2179	2	maims
main	6	53	4552	2	main
mains	7	56	3511	2	mains
mair	6	61	3378	2	mair
mairs	7	62	2830	2	mairs
maist	7	55	3568	2	maist
mamas	9	59	3077	2	mamas
mamie	9	58	2600	2	mamie
mamies	10	46	2624	2	mamies
mans	6	63	5455	2	mans
maps	8	61	4105	2	maps
mars	6	62	6187	2	mars
mas	5	81	7582	2	_mas
mass	6	60	4494	2	mass
mats	6	54	6029	2	mats
mavis	10	56	2272	2	mavis
maws	9	64	3714	2	maws
maxis	14	57	2156	2	maxis
mays	9	69	4003	2	mays
mi	4	82	4905	2	_mi_
mib	7	69	4612	2	_mib
mibs	8	53	3048	2	_mibs
mic	7	76	4764	2	_mic
mics	8	74	3515	2	_mics
mid	6	73	5447	2	_mid
mids	7	65	4179	2	_mids
mig	6	56	4608	2	_mig
migs	7	69	3532	2	_migs
mil	5	57	5211	2	_mil
mils	6	60	4533	2	_mils
mim	7	60	4842	2	_mim
mips	8	55	3408	2	_mips
mir	5	70	4677	2	_mir
mirs	6	69	4057	2	_mirs
mise	6	60	4358	2	_mise
miso	6	72	2990	2	_miso
miss	6	53	3942	2	_miss
mist	6	61	5453	2	_mist
mix	12	61	3818	2	_mix
mos	5	70	6712	2	_mos
mus	5	59	4675	2	_mus
nabis	7	60	2058	2	nabis
names	7	48	3336	2	names
naris	5	57	3529	2	naris
nazis	14	52	1608	2	nazis
nims	6	62	2688	2	nims
oasis	5	64	2255	2	oasis
obis	6	62	2684	2	obis
omit	6	53	3737	2	omit
omits	7	50	1826	2	omits
oms	5	63	3751	2	om_s
padis	8	62	2714	2	padis
pams	8	56	4176	2	pam_s
paris	7	51	4594	2	paris
pavis	10	64	2273	2	pavis
phis	9	57	2490	2	phis
pis	5	63	6203	2	_pis
pois	6	65	3904	2	pois
psis	6	81	2034	2	psis
qadis	15	59	1785	2	qadis
qis	12	69	3438	2	_qis
ragis	6	63	2560	2	ragis
rais	4	52	5262	2	rais
rakis	9	53	2344	2	rakis
rami	6	60	3409	2	rami_
ramie	7	50	2782	2	ramie
ramies	8	46	3046	2	ramies
ramps	9	62	2463	2	ramps
rams	6	59	5077	2	ram_s
ramus	7	64	1828	2	ramus
ranis	5	52	3583	2	ranis
reis	4	53	4323	2	reis
rims	6	59	3630	2	rims
sadis	6	49	3085	2	sadis
sakis	9	53	2367	2	sakis
salmis	8	5	1427	2	salmis
samps	9	61	2467	2	samps
saris	5	45	4495	2	saris
satis	5	56	3368	2	satis
seis	4	55	4239	2	seis
semis	7	46	2353	2	semis
sims	6	57	3717	2	sims
sis	3	73	6054	2	_sis
skis	8	48	2529	2	skis
smit	6	51	3841	2	smit
sris	4	54	3415	2	sris
swamis	11	42	1229	2	swamis
tames	7	52	4201	2	tames
tamps	9	55	2408	2	tamps
tams	6	72	4793	2	tam_s
tapis	7	50	2886	2	tapis
taxis	12	68	2197	2	taxis
this	7	60	2738	2	this
tis	3	70	5664	2	_tis
tuis	4	48	2964	2	tuis
umamis	10	3	827	2	umamis
umps	8	57	2194	2	umps
vamps	12	54	1548	2	vamps
vims	9	54	2331	2	vims
vis	6	67	4761	2	_vis
wadis	9	52	2396	2	wadis
wames	10	64	3280	2	wames
wamus	10	55	1468	2	wamus
wis	6	65	5233	2	_wis
xis	10	69	3533	2	_xis
yagis	9	54	1657	2	yagis
yams	9	53	3073	2	yam_s
ywis	10	53	1310	2	ywis
zamia	16	51	1521	2	zamia
zamias	17	42	1292	2	zamias

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.266	671770.7
2	DLD Change Limit	29872	383	0.813	36742.9
3	Display Results	383	383	0.093	4118.3
	(SQL Overall)	178691	383	1.172	152466.7