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

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

217 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
mummery	13	33	666	(None)
mummer	9	36	1454	1	mummer_
mummers	10	37	1284	1	mummers
summery	14	32	941	1	summery
bummer	12	40	1410	2	bummer_
bummers	13	37	1244	2	bummers
cummer	12	44	1459	2	cummer_
cummers	13	37	1348	2	cummers
flummery	18	3	305	2	flummery
gummer	11	46	1545	2	gummer_
gummers	12	37	1220	2	gummers
hummer	13	36	1527	2	hummer_
hummers	14	38	1306	2	hummers
mammary	13	3	599	2	mammary
mammer	9	42	1886	2	mammer_
mammers	10	46	1569	2	mammers
mammey	12	43	1089	2	mamme_y
mummed	10	44	1155	2	mumme_d
mummify	16	4	333	2	mummify
mummy	11	49	1362	2	mumm__y
mumper	12	35	1352	2	mumper_
mumpers	13	33	1137	2	mumpers
nummary	14	31	465	2	nummary
rummer	10	47	1548	2	rummer_
rummers	11	35	1365	2	rummers
summary	14	29	735	2	summary
summer	10	40	1771	2	summer_
summerly	15	27	510	2	summerly
summers	11	36	1650	2	summers
ambery	13	38	1113	3	_ambery
buggery	14	36	793	3	buggery
bummed	13	42	1172	3	bumme_d
bummest	13	29	862	3	bummest
bumper	12	37	1434	3	bumper_
bumpers	13	39	1205	3	bumpers
butlery	12	36	942	3	butlery
buttery	12	43	1119	3	buttery
cumber	12	40	1670	3	cumber_
cumbers	13	45	1541	3	cumbers
cutlery	12	44	839	3	cutlery
dammer	11	43	1793	3	dammer_
dammers	12	32	1427	3	dammers
dimmer	11	41	1261	3	dimmer_
dimmers	12	38	1156	3	dimmers
drummer	12	40	750	3	drummer_
drummers	13	31	616	3	drummers
dumber	11	44	1417	3	dumber_
dummy	13	47	1278	3	dumm__y
dumper	11	46	1521	3	dumper_
dumpers	12	34	1266	3	dumpers
dupery	12	37	874	3	du_pery
emery	10	48	1433	3	__emery
emmer	9	43	1446	3	_emmer_
emmers	10	40	1322	3	_emmers
empery	13	4	868	3	_empery
fullery	13	33	797	3	fullery
fumer	10	59	1823	3	fu_mer_
fumers	11	36	1338	3	fu_mers
fumier	11	3	1090	3	fumier_
furmety	15	3	481	3	furmety
gammer	11	123	1833	3	gammer_
gammers	12	32	1456	3	gammers
glummer	12	41	798	3	glummer_
grummer	12	33	878	3	grummer_
gummed	12	38	1166	3	gumme_d
gummier	12	34	947	3	gummier_
gummy	13	54	1365	3	gumm__y
gunnery	11	37	637	3	gunnery
guttery	11	42	776	3	guttery
hammer	13	81	2003	3	hammer_
hammers	14	42	1606	3	hammers
hemmer	13	41	1264	3	hemmer_
hemmers	14	33	1084	3	hemmers
humeri	11	3	852	3	hu_meri
hummed	14	48	1267	3	humme_d
humper	13	41	1588	3	humper_
humpers	14	27	1352	3	humpers
jammer	17	40	1413	3	jammer_
jammers	18	37	1070	3	jammers
jumper	17	36	1237	3	jumper_
jumpers	18	39	984	3	jumpers
kummel	14	26	617	3	kumme_l
kummels	15	23	479	3	kummels
limmer	10	43	1479	3	limmer_
limmers	11	34	1308	3	limmers
lumber	10	38	1777	3	lumber_
lumberly	15	4	468	3	lumberly
lumbers	11	38	1591	3	lumbers
lumper	10	38	1665	3	lumper_
lumpers	11	35	1448	3	lumpers
maimer	10	45	1459	3	maimer_
maimers	11	38	1304	3	maimers
mamey	12	54	1883	3	m_ame_y
mammee	9	44	1785	3	mamme_e
mammees	10	44	1114	3	mammees
mammered	12	23	765	3	mammered
mammet	9	43	1925	3	mamme_t
mammets	10	39	1111	3	mammets
mammeys	13	37	672	3	mammeys
mammy	11	52	1516	3	mamm__y
mamzer	19	45	983	3	mamzer_
mamzers	20	40	916	3	mamzers
mastery	12	42	1432	3	mastery
mattery	12	38	1071	3	mattery
maumetry	15	4	347	3	maumetry
member	12	25	885	3	member_
members	13	25	860	3	members
memory	13	3	880	3	m_emory
mercery	14	39	762	3	mercery
mimer	9	48	2576	3	m_imer_
mimers	10	55	2018	3	m_imers
mimicry	16	4	349	3	mimicry
misery	11	41	1354	3	m_isery
mockery	18	37	691	3	mockery
mommy	11	40	1075	3	momm__y
momser	10	40	1141	3	momser_
momsers	11	38	1085	3	momsers
momzer	19	32	755	3	momzer_
momzers	20	36	713	3	momzers
monkery	16	31	745	3	monkery
mopery	13	52	1097	3	m_opery
mothery	15	37	1051	3	mothery
mucker	14	38	1639	3	mucker_
muckers	15	36	1280	3	muckers
mudder	10	44	1349	3	mudder_
mudders	11	32	1111	3	mudders
mugger	10	39	1470	3	mugger_
muggers	11	36	1193	3	muggers
mulberry	15	4	256	3	mulberry
muley	10	48	1928	3	mu_le_y
muller	8	38	2035	3	muller_
mullers	9	32	1730	3	mullers
mulley	11	40	1345	3	mulle_y
mumbler	13	35	1091	3	mumbler_
mumblers	14	32	876	3	mumblers
mumbly	15	31	946	3	mu_mbly
mumm	7	57	1886	3	mumm___
mummeries	12	4	724	3	mummeries
mummied	11	32	710	3	mummied
mummies	10	38	1284	3	mummies
mumming	11	40	1002	3	mumming
mumms	8	55	1315	3	mumm__s
mumped	13	38	1316	3	mumpe_d
murder	9	36	1378	3	murder_
murders	10	33	1136	3	murders
murker	12	37	1524	3	murker_
murmur	10	3	485	3	murmur_
murmurs	11	3	452	3	murmurs
murrey	11	43	1226	3	murre_y
murry	10	51	2023	3	mu__rry
muser	7	60	2412	3	mu_ser_
musers	8	47	1910	3	mu_sers
musher	11	38	2057	3	musher_
mushers	12	40	1644	3	mushers
musketry	17	4	218	3	musketry
muster	8	47	2452	3	muster_
musters	9	45	2251	3	musters
mutely	11	38	1165	3	mu_tely
muter	7	45	2554	3	mu_ter_
mutter	8	44	1888	3	mutter_
mutters	9	41	1714	3	mutters
mystery	15	43	652	3	mystery
number	10	39	1322	3	number_
numbers	11	37	1124	3	numbers
nunnery	10	35	530	3	nunnery
nursery	10	39	602	3	nursery
plumbery	17	31	553	3	plumbery
plummer	13	29	852	3	plummer_
puckery	18	30	626	3	puckery
puffery	18	23	511	3	puffery
pummel	12	27	804	3	pumme_l
pummelo	13	28	423	3	pummelo
pummels	13	23	654	3	pummels
pumper	12	44	1555	3	pumper_
pumpers	13	31	1367	3	pumpers
quavery	22	22	548	3	quavery
query	17	42	1208	3	qu__ery
quivery	22	26	546	3	quivery
rammer	10	35	1965	3	rammer_
rammers	11	37	1504	3	rammers
rimmer	10	35	1603	3	rimmer_
rimmers	11	38	1288	3	rimmers
rubbery	14	33	759	3	rubbery
rudery	10	41	903	3	ru_dery
rummest	11	27	983	3	rummest
rummier	11	30	956	3	rummier_
rummy	12	42	1241	3	rumm__y
scummer	13	39	875	3	scummer_
scummers	14	27	778	3	scummers
shimmery	18	26	525	3	shimmery
simmer	10	41	1535	3	simmer_
simmers	11	33	1461	3	simmers
slumbery	15	29	604	3	slumbery
slummer	11	37	1120	3	slummer_
slummers	12	35	893	3	slummers
stemmery	15	33	469	3	stemmery
summed	11	40	1404	3	summe_d
summered	13	3	814	3	summered
summitry	15	4	332	3	summitry
surgery	11	31	921	3	surgery
symmetry	18	4	355	3	symmetry
timbery	14	25	689	3	timbery
trumpery	15	3	361	3	trumpery
tumefy	14	3	422	3	tu_mefy
tummler	11	26	661	3	tummler_
tummlers	12	29	570	3	tummlers
tummy	12	47	1199	3	tumm__y
turnery	10	35	742	3	turnery
tushery	13	3	563	3	tushery
umber	9	46	1759	3	_umber_
umbers	10	42	1521	3	_umbers
unmerry	12	4	502	3	_unmerry
wommera	14	14	406	3	wommera
yammer	13	37	1318	3	yammer_
yammers	14	34	1032	3	yammers
yummier	14	30	684	3	yummier_
yummy	15	42	915	3	yumm__y

Search took 7 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.440	406115.9
2	DLD Change Limit	134027	217	5.716	23447.7
3	Display Results	217	217	0.080	2712.5
	(SQL Overall)	178691	217	6.236	28654.7