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

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

153 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
mammary	13	3	599	(None)
ambary	13	40	1054	2	_ambary
dammar	11	43	890	2	dammar_
dammars	12	30	819	2	dammars
mamma	8	63	1791	2	mamma__
mammae	9	46	1321	2	mamma_e
mammal	9	51	1275	2	mamma_l
mammals	10	38	927	2	mammals
mammas	9	46	1640	2	mamma_s
mammate	10	44	1127	2	mammate
mammati	10	39	837	2	mammati
mammer	9	42	1886	2	mammer_
mammers	10	46	1569	2	mammers
mammey	12	43	1089	2	mamm_ey
mammy	11	52	1516	2	mamm__y
manuary	12	3	777	2	manuary
mummery	13	33	666	2	mummery
nummary	14	31	465	2	nummary
palmary	14	33	855	2	palmary
summary	14	29	735	2	summary
alary	8	61	2344	3	_a_lary
ambari	10	30	1216	3	_ambari
ambery	13	38	1113	3	_ambery
ambry	12	35	1210	3	_a_mbry
angary	10	3	1132	3	_angary
apiary	11	39	1038	3	_apiary
ariary	9	41	1420	3	_ariary
armory	11	42	1147	3	_armory
aviary	12	33	841	3	_aviary
aweary	12	3	730	3	_aweary
calamary	15	4	546	3	calamary
calvary	15	3	718	3	calvary
canary	11	3	1469	3	ca_nary
damar	8	41	1773	3	da_mar_
damars	9	38	1499	3	da_mars
dammer	11	43	1793	3	dammer_
dammers	12	32	1427	3	dammers
datary	10	3	1024	3	da_tary
daymare	13	7	563	3	daymare
earmark	13	4	565	3	earmark
gamay	11	64	1910	3	ga_ma_y
gamma	10	61	1610	3	gamma__
gammas	11	57	1469	3	gamma_s
gammer	11	123	1833	3	gammer_
gammers	12	32	1456	3	gammers
gammy	13	55	1489	3	gamm__y
gramary	13	5	590	3	gramary
grammar	12	40	689	3	grammar_
grammars	13	34	594	3	grammars
hammada	15	4	508	3	hammada
hammal	13	45	1206	3	hamma_l
hammals	14	40	921	3	hammals
hammam	12	41	933	3	hamma_m
hammams	13	38	643	3	hammams
hammer	13	81	2003	3	hammer_
hammers	14	42	1605	3	hammers
hammily	17	3	606	3	hammily
hammy	15	51	1343	3	hamm__y
hymnary	18	4	303	3	hymnary
jaggary	19	30	486	3	jaggary
jammer	17	40	1413	3	jammer_
jammers	18	37	1070	3	jammers
jammy	19	48	1019	3	jamm__y
lactary	12	3	784	3	lactary
laminary	13	33	725	3	laminary
laniary	10	6	801	3	laniary
maar	6	60	2505	3	ma__ar_
maars	7	46	2163	3	ma__ars
madman	11	37	1238	3	madma_n
magma	10	45	1357	3	magma__
magmas	11	55	1250	3	magma_s
magmata	12	3	746	3	magmata
maimer	10	45	1459	3	maimer_
maimers	11	38	1304	3	maimers
makar	11	56	1497	3	ma_kar_
makars	12	46	1263	3	ma_kars
malady	12	3	786	3	ma_lady
malar	7	64	2444	3	ma_lar_
malarky	16	4	543	3	ma_larky
malars	8	50	2068	3	ma_lars
mallard	10	3	1027	3	mallard
malmsey	14	3	362	3	malmsey
malmy	12	48	1634	3	malm__y
mama	8	62	3158	3	ma_ma__
mamas	9	59	3077	3	ma_ma_s
mamba	11	63	1752	3	mamba__
mambas	12	57	1624	3	mamba_s
mamey	12	54	1883	3	ma_m_ey
mammality	15	4	427	3	mammality
mammalogy	16	5	215	3	mammalogy
mammatus	11	4	423	3	mammatus
mammee	9	44	1785	3	mamm_ee
mammees	10	44	1114	3	mammees
mammered	12	23	765	3	mammered
mammet	9	43	1925	3	mamm_et
mammets	10	39	1111	3	mammets
mammeys	13	37	672	3	mammeys
mammie	9	43	1378	3	mamm_ie
mammies	10	43	1476	3	mammies
mammillary	16	5	176	3	mamm~~ill~~ary
mammock	16	6	439	3	mammock
mammon	9	3	964	3	mamm_on
mammons	10	4	851	3	mammons
mammoth	13	4	498	3	mammoth
mamzer	19	45	983	3	mamzer_
mamzers	20	40	916	3	mamzers
mangaby	15	3	535	3	mangaby
manmade	12	3	796	3	manmade
mansard	10	4	931	3	mansard
manward	13	4	909	3	manward
margay	12	3	1059	3	marga_y
marry	10	48	2169	3	ma__rry
martyry	15	3	337	3	martyry
mascara	11	3	802	3	mascara
masonry	12	4	412	3	masonry
mastery	12	42	1432	3	mastery
mattery	12	38	1071	3	mattery
maumetry	15	4	347	3	maumetry
mayday	15	3	587	3	mayda_y
mazard	18	3	876	3	ma_zard
mazzard	18	4	446	3	mazzard
memory	13	3	880	3	m_emory
miliary	12	4	946	3	miliary
mimbar	12	9	749	3	mimbar_
mimbars	13	9	738	3	mimbars
mimicry	16	4	349	3	mimicry
mismark	15	3	670	3	mismark
momma	8	51	1105	3	momma__
mommas	9	41	1065	3	momma_s
mommy	11	40	1075	3	momm__y
mortary	12	36	904	3	mortary
mummer	9	36	1454	3	mummer_
mummers	10	37	1284	3	mummers
mummify	16	4	333	3	mummify
mummy	11	49	1362	3	mumm__y
palmar	10	41	1346	3	palmar_
primary	14	3	770	3	primary
rammer	10	35	1965	3	rammer_
rammers	11	37	1504	3	rammers
rammy	12	43	1249	3	ramm__y
rampart	11	3	1199	3	rampart
salary	9	5	1521	3	sa_lary
samara	8	3	1385	3	sa_mara
sambar	10	39	1416	3	sambar_
sambars	11	51	1384	3	sambars
samsara	9	3	691	3	samsara
smeary	11	41	1080	3	_smeary
summery	14	32	941	3	summery
tamari	8	3	1338	3	ta_mari
tammy	12	40	1322	3	tamm__y
vagary	13	3	733	3	va_gary
yammer	13	37	1318	3	yammer_
yammers	14	34	1032	3	yammers

Search took 9 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	134027	0.156	1145455.1
2	DLD Change Limit	134027	153	8.033	16684.6
3	Display Results	153	153	0.046	3326.1
	(SQL Overall)	178691	153	8.235	21699.0