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

Here are the results of your fuzzy-string dictionary search for “mynahs” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

322 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
mynahs	14	41	644	(None)
mynah	13	56	956	1	mynah_
mynas	10	58	1523	1	myna_s
ayahs	11	68	1352	2	ay_ahs
manas	7	62	4042	2	mana_s
manats	8	46	2346	2	manats
menads	9	55	1438	2	menads
minas	7	54	3411	2	mina_s
monads	9	45	1530	2	monads
monas	7	47	3215	2	mona_s
months	11	38	1293	2	months
mylars	11	43	1044	2	mylars
myna	9	58	1529	2	myna__
myrrhs	14	4	359	2	myrrhs
myths	13	59	1160	2	my_ths
synchs	14	40	845	2	synchs
synths	12	37	788	2	synths
yeahs	11	52	1455	2	_yeahs
aahs	7	164	2856	3	__aahs
ahs	6	86	4482	3	___ahs
almahs	11	86	1161	3	almahs
amahs	10	78	1906	3	_amahs
anas	4	66	4986	3	_ana_s
ankhs	12	11	672	3	_ankhs
annals	6	64	1592	3	annals
annas	5	58	2488	3	anna_s
ayah	10	80	2299	3	ay_ah_
bimahs	13	50	830	3	bimahs
blahs	10	56	1651	3	_blahs
bunas	7	51	2657	3	buna_s
bylaws	14	41	583	3	bylaws
byname	13	25	636	3	byname
bynames	14	25	624	3	bynames
bypass	13	4	504	3	bypass
bypaths	17	4	319	3	bypaths
byways	17	3	467	3	byways
canals	8	44	2166	3	canals
conchs	13	47	1490	3	conchs
cyans	10	57	1481	3	cy_ans
cycads	14	47	621	3	cycads
cycas	12	65	1382	3	cyca_s
cymars	13	59	914	3	cymars
cymas	12	64	1788	3	cyma_s
cynics	13	37	736	3	cynics
dahs	8	82	3181	3	__dahs
denars	7	46	2143	3	denars
dinars	7	54	1756	3	dinars
donas	6	59	2647	3	dona_s
dunams	9	3	783	3	dunams
dyads	10	54	997	3	dy_ads
dynamo	12	7	416	3	dynamo
dynamos	13	7	385	3	dynamos
dynast	10	8	822	3	dynast
dynasts	11	5	510	3	dynasts
dynels	10	53	681	3	dynels
dynes	9	59	1758	3	dyn_es
ephahs	14	3	550	3	ephahs
etnas	5	47	1393	3	etna_s
eyas	7	64	2743	3	ey_a_s
eyass	8	44	1078	3	ey_ass
eyras	8	47	1592	3	eyra_s
finals	9	43	1616	3	finals
fynbos	14	3	328	3	fynbos
galahs	10	55	1267	3	galahs
ganjahs	18	10	400	3	ganjahs
gerahs	10	3	941	3	gerahs
gnars	6	67	1885	3	_gnars
gnash	9	44	983	3	_gnash
gnats	6	52	1771	3	_gnats
gnaws	9	63	1114	3	_gnaws
gonads	8	45	1173	3	gonads
hahs	10	83	3336	3	__hahs
honans	9	48	1450	3	honans
horahs	12	63	1387	3	horahs
hyenas	12	8	895	3	hyena_s
hylas	11	48	1590	3	hyla_s
hymnals	15	4	352	3	hymnals
kanas	9	53	2691	3	kana_s
kenafs	13	3	711	3	kenafs
kinas	9	56	2691	3	kina_s
knaps	11	55	1117	3	_knaps
knars	9	44	1611	3	_knars
kyaks	11	45	916	3	ky_aks
kyars	12	48	1396	3	ky_ars
kyats	12	50	1244	3	ky_ats
lanais	6	3	1679	3	lanais
linacs	8	3	1081	3	linacs
lotahs	9	47	987	3	lotahs
lunars	6	50	1281	3	lunars
lunas	5	50	2501	3	luna_s
lymphs	16	3	505	3	lymphs
lynch	13	46	898	3	lynch_
lynches	15	37	887	3	lynches
lynxes	16	3	432	3	lynxes
maars	7	46	2163	3	m_aars
macaws	13	3	702	3	macaws
machs	12	57	2256	3	m_achs
macs	8	67	4250	3	m__acs
madams	11	3	1094	3	madams
mads	7	68	4536	3	m__ads
maenads	10	3	737	3	maenads
maes	6	69	4839	3	m__aes
mags	7	54	4452	3	m__ags
makars	12	46	1263	3	makars
malars	8	50	2068	3	malars
mamas	9	59	3077	3	mama_s
mana	6	53	4194	3	mana__
manage	9	38	1890	3	manage
manages	10	34	1896	3	manages
manana	8	48	1607	3	manana
mananas	9	34	1473	3	mananas
manat	7	60	3998	3	mana_t
manche	13	35	1510	3	manche
manches	14	38	1862	3	manches
manes	7	66	4895	3	man_es
mangas	9	41	2292	3	mangas
manges	9	46	2894	3	manges
mangos	9	43	1933	3	mangos
maniacs	11	43	1306	3	maniacs
manias	8	40	2903	3	manias
manics	10	39	1993	3	manics
mannans	9	36	1152	3	mannans
mannas	8	50	1980	3	mannas
manors	8	44	2088	3	manors
manos	7	49	3361	3	man_os
mans	6	63	5453	3	m__ans
manses	8	42	2551	3	manses
mantas	8	57	2536	3	mantas
mantes	8	44	3078	3	mantes
mantis	8	39	2603	3	mantis
manuals	9	3	1121	3	manuals
manus	7	59	2492	3	man_us
maps	8	61	4104	3	m__aps
maras	7	54	4328	3	mara_s
mars	6	62	6186	3	m__ars
mas	5	81	7581	3	m__a_s
masas	7	56	3041	3	masa_s
mash	9	60	3939	3	m__ash
mass	6	60	4493	3	m__ass
maths	10	56	2402	3	m_aths
mats	6	54	6028	3	m__ats
matsahs	12	3	656	3	matsahs
matzahs	21	3	448	3	matzahs
maws	9	64	3713	3	m__aws
mayas	10	59	2438	3	maya_s
maydays	16	3	448	3	maydays
mays	9	69	4002	3	m__ays
meads	8	54	2532	3	m_eads
meals	7	59	3337	3	m_eals
means	7	58	3122	3	m_eans
meats	7	50	3405	3	m_eats
medals	9	42	1804	3	medals
megass	9	21	944	3	megass
menace	10	32	1694	3	menace
menaces	11	27	1552	3	menaces
menad	8	59	1898	3	mena_d
menage	9	32	1654	3	menage
menages	10	36	1539	3	menages
mends	8	49	2769	3	men_ds
menials	9	40	1568	3	menials
menorahs	13	4	654	3	menorahs
mensas	8	51	1585	3	mensas
menses	8	42	2245	3	menses
mensh	10	54	1355	3	mensh_
menshes	12	3	1044	3	menshes
menus	7	58	2284	3	men_us
mesas	7	68	2320	3	mesa_s
metals	8	45	2088	3	metals
meths	10	53	2023	3	m_eths
micas	9	68	2305	3	mica_s
mikvahs	19	16	249	3	mikvahs
mina	6	51	3690	3	mina__
minae	7	56	2772	3	mina_e
minces	10	44	2080	3	minces
minds	8	54	2712	3	min_ds
miners	8	41	2663	3	miners
mines	7	56	5195	3	min_es
minims	10	45	1480	3	minims
minis	7	54	3298	3	min_is
minish	11	52	1629	3	minish
minkes	12	46	1878	3	minkes
minks	11	58	2927	3	min_ks
minors	8	51	1709	3	minors
mints	7	68	3404	3	min_ts
minus	7	52	2393	3	min_us
minxes	15	46	1298	3	minxes
minyans	12	3	726	3	minyans
mirths	11	49	1299	3	mirths
moans	7	46	2436	3	m_oans
moas	6	55	4534	3	m_oa_s
moats	7	58	2764	3	m_oats
mochas	13	3	1065	3	mochas
modals	9	39	1444	3	modals
molars	8	55	1732	3	molars
molas	7	51	3209	3	mola_s
mollahs	12	32	828	3	mollahs
monad	8	55	1947	3	mona_d
monades	10	37	1382	3	monades
monarchs	15	4	483	3	monarchs
mondes	9	43	2235	3	mondes
mondos	9	52	1733	3	mondos
moneys	11	55	1362	3	moneys
mongos	9	43	1862	3	mongos
monies	8	32	3316	3	monies
monish	11	42	1759	3	monish
monks	11	61	2339	3	mon_ks
monos	7	59	3086	3	mon_os
mons	6	81	5225	3	mon__s
montes	8	42	2693	3	montes
month	10	48	1842	3	month_
moolahs	12	34	738	3	moolahs
morals	8	53	2463	3	morals
moras	7	64	3876	3	mora_s
morass	8	46	1449	3	morass
morays	11	46	1388	3	morays
morphs	13	14	943	3	morphs
moths	10	60	2155	3	m_oths
mouths	11	52	1453	3	mouths
moxas	14	50	1439	3	moxa_s
mullahs	12	38	873	3	mullahs
munch	12	49	1710	3	munch_
munches	14	42	1579	3	munches
mungos	9	43	1137	3	mungos
munis	7	50	2200	3	mun_is
muns	6	55	3591	3	mun__s
murals	8	40	1675	3	murals
muras	7	53	2956	3	mura_s
musths	11	58	948	3	musths
myases	11	37	1155	3	myases
myasis	11	40	1046	3	myasis
mycs	11	53	1429	3	my__cs
myiases	12	3	549	3	myiases
myiasis	12	4	548	3	myiasis
mylar	10	53	1153	3	myla_r
myomas	13	3	829	3	myomas
myopes	13	41	996	3	myopes
myoses	11	40	1384	3	myoses
myosis	11	40	1255	3	myosis
myriads	13	3	434	3	myriads
myrrh	13	3	709	3	myrrh_
mysids	12	4	656	3	mysids
myth	12	67	1543	3	my_th_
mythos	14	39	846	3	mythos
mythy	16	56	867	3	my_thy
nabs	6	62	3619	3	__nabs
nags	5	54	3602	3	__nags
nah	6	98	4700	3	__nah_
nanas	5	59	2863	3	nana_s
nans	4	61	3939	3	__nans
naos	4	74	2973	3	__naos
naps	6	62	3858	3	__naps
nays	7	59	3159	3	__nays
ninths	9	3	693	3	ninths
nonas	5	51	2665	3	nona_s
nymphs	16	3	350	3	nymphs
obeahs	11	3	586	3	obeahs
odahs	9	56	1008	3	_odahs
opahs	10	54	1198	3	_opahs
pinas	7	54	3445	3	pina_s
pujahs	18	40	494	3	pujahs
punas	7	48	2675	3	puna_s
punkahs	16	28	478	3	punkahs
pyas	9	62	2570	3	py_a_s
pyrans	11	4	1106	3	pyrans
qanats	15	41	1281	3	qanats
rajahs	16	49	766	3	rajahs
rayahs	12	57	919	3	rayahs
ryas	7	72	2461	3	ry_a_s
rynds	9	56	997	3	ryn_ds
sanghs	10	53	1206	3	sanghs
selahs	9	3	1321	3	selahs
shahs	11	59	1951	3	_shahs
shnaps	11	4	808	3	shnaps
sinhs	8	67	1960	3	sin_hs
snags	6	44	2131	3	_snags
snaps	7	47	1956	3	_snaps
snash	8	48	1567	3	_snash
snaths	9	51	1291	3	_snaths
snaws	8	61	1636	3	_snaws
sonars	6	48	1897	3	sonars
subahs	11	45	1238	3	subahs
sunnahs	10	32	659	3	sunnahs
surahs	9	45	1554	3	surahs
sylphs	14	3	554	3	sylphs
synapse	12	3	413	3	synapse
synch	13	50	1179	3	synch_
syncs	10	46	1017	3	syn_cs
syngas	10	36	891	3	syngas
synods	10	7	795	3	synods
synth	11	37	1182	3	synth_
syphs	13	51	945	3	sy_phs
tenths	9	44	1266	3	tenths
torahs	9	51	1564	3	torahs
tunas	5	42	2412	3	tuna_s
tynes	8	59	2030	3	tyn_es
ulnas	5	57	1653	3	ulna_s
unais	5	34	2077	3	_unais
unaus	5	32	1657	3	_unaus
vinals	9	47	1648	3	vinals
vinas	8	51	2634	3	vina_s
whydahs	20	4	188	3	whydahs
wynds	12	63	1037	3	wyn_ds
wynns	11	51	747	3	wyn_ns
wyns	10	57	1703	3	wyn__s
xylans	16	3	588	3	xylans
yags	8	66	3229	3	_y_ags
yah	9	90	4635	3	_y_ah_
yaks	11	60	2520	3	_y_aks
yams	9	53	3073	3	_y_ams
yangs	9	56	1869	3	_yangs
yanks	12	53	1657	3	_yanks
yaps	9	59	3352	3	_y_aps
yaws	10	55	3121	3	_y_aws
yays	10	57	2891	3	_y_ays
yeah	10	67	2541	3	_yeah_
yeans	8	66	2488	3	_yeans
years	8	45	2767	3	_years
yeas	7	86	3842	3	_yea_s
yechs	13	61	1258	3	_yechs
yodhs	12	66	901	3	_yodhs
yoghs	12	54	1059	3	_yoghs
yuans	8	46	1332	3	_yuans

Search took 8 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	322	7.576	14878.0
3	Display Results	322	322	0.110	2927.3
	(SQL Overall)	178691	322	7.826	22833.0