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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

89 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
masonry	12	4	412	(None)
canonry	12	3	591	2	canonry
mason	7	48	2018	2	mason__
masoned	10	3	980	2	masoned
masonic	11	3	991	2	masonic
masons	8	39	1651	2	mason_s
mastery	12	42	1432	2	mastery
agony	9	64	1565	3	_agon_y
almonry	12	10	473	3	almonry
amatory	12	3	861	3	amato_ry
astony	9	5	1052	3	_aston_y
atony	8	72	1885	3	_aton_y
baloney	12	3	748	3	baloney
barony	11	59	1530	3	baron_y
blazonry	22	4	216	3	blazonry
calory	11	3	1284	3	calo_ry
cannonry	13	4	328	3	cannonry
deaconry	14	4	332	3	deaconry
falconry	16	4	253	3	falconry
felonry	13	29	484	3	felonry
heronry	13	4	604	3	heronry
jaspery	19	40	525	3	jaspery
macon	9	45	1995	3	macon__
macons	10	40	1724	3	macon_s
madonna	10	4	440	3	madonna
mahonia	12	3	844	3	mahonia
mainly	11	4	1149	3	ma_inly
major	14	52	1292	3	majo_r_
majorly	19	4	315	3	majorly
majors	15	45	1109	3	majo_rs
mammary	13	3	599	3	mammary
mangy	11	50	2123	3	ma__ngy
manly	10	50	2294	3	ma__nly
manor	7	80	2392	3	mano_r_
manors	8	44	2088	3	mano_rs
manuary	12	3	777	3	manuary
many	9	57	3184	3	ma__n_y
marry	10	48	2169	3	ma__rry
martyry	15	3	337	3	martyry
mascara	11	3	802	3	mascara
mascon	10	36	1274	3	mascon__
mascons	11	34	1158	3	mascon_s
maser	7	50	2997	3	mas_er_
masers	8	46	2345	3	mas_ers
masher	11	41	2320	3	masher_
mashers	12	46	2105	3	mashers
mashy	13	60	1650	3	mas__hy
masker	12	44	1610	3	masker_
maskers	13	39	1383	3	maskers
masoning	11	3	976	3	masoning
masonite	10	4	968	3	masonite
masonries	11	4	685	3	masonries
massy	10	45	1896	3	mas__sy
master	8	48	3134	3	master_
masterly	13	31	765	3	masterly
masters	9	46	2892	3	masters
matronly	13	4	478	3	matronly
mattery	12	38	1071	3	mattery
maundy	12	50	678	3	ma_undy
mayor	10	66	1662	3	mayo_r_
mayors	11	57	1419	3	mayo_rs
memory	13	3	880	3	memo_ry
meson	7	41	1831	3	meson__
mesonic	11	3	1009	3	mesonic
mesons	8	32	1584	3	meson_s
misandry	14	4	386	3	misandry
misentry	13	4	577	3	misentry
misery	11	41	1354	3	mis_ery
money	10	48	2684	3	m__oney
mony	9	68	3000	3	m__on_y
moony	10	48	1827	3	m_oon_y
moory	10	51	1579	3	m__oory
mystery	15	43	652	3	mystery
pastry	11	49	1303	3	pas_try
savory	12	43	1056	3	savo_ry
savoury	13	36	587	3	savoury
saxony	16	3	623	3	saxon_y
sonly	8	57	1805	3	__sonly
sonny	8	50	1610	3	__sonny
sonsy	8	64	1637	3	__sonsy
sorry	8	46	1825	3	__sorry
suasory	10	4	604	3	suaso_ry
unsoncy	12	4	551	3	unsoncy
unsonsy	10	4	502	3	unsonsy
vapory	14	39	876	3	vapo_ry
vapoury	15	28	480	3	vapoury
wastery	13	46	1099	3	wastery
wastry	12	38	877	3	was_try
weaponry	16	4	202	3	weaponry

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	134027	0.140	1276364.3
2	DLD Change Limit	134027	89	7.110	18850.5
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.280	24545.5