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

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

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.

65 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
mamzers	20	40	916	(None)
mammers	10	46	1569	1	mammers
mamzer	19	45	983	1	mamzer_
mazers	17	39	1709	1	ma_zers
momzers	20	36	713	1	momzers
ambers	10	45	1958	2	_ambers
ameers	8	40	1557	2	_ameers
cambers	13	40	1744	2	cambers
campers	13	42	2029	2	campers
dammers	12	32	1427	2	dammers
damners	10	41	1211	2	damners
dampers	12	39	1569	2	dampers
gamers	9	44	2083	2	gam_ers
gammers	12	32	1456	2	gammers
gazers	16	45	1630	2	ga_zers
hammers	14	42	1606	2	hammers
hampers	14	36	1695	2	hampers
hazers	18	46	1595	2	ha_zers
jammers	18	37	1070	2	jammers
jazzers	22	32	476	2	jazzers
lambers	11	38	1711	2	lambers
lampers	11	38	1733	2	lampers
macers	10	53	2127	2	ma_cers
madders	11	35	1321	2	madders
mahzors	21	3	512	2	mahzors
mailers	9	44	2033	2	mailers
maimers	11	38	1304	2	maimers
maizes	17	51	1573	2	maize_s
makers	12	39	2173	2	ma_kers
mameys	13	44	952	2	mam_eys
mamies	10	46	2624	2	mamie_s
mammees	10	44	1114	2	mammees
mammer	9	42	1886	2	mammer_
mammets	10	39	1111	2	mammets
mammeys	13	37	672	2	mammeys
mangers	10	35	2126	2	mangers
manners	9	34	1783	2	manners
mappers	13	33	1378	2	mappers
markers	13	35	1610	2	markers
marrers	9	34	1431	2	marrers
masers	8	46	2345	2	ma_sers
mashers	12	46	2105	2	mashers
maskers	13	39	1384	2	maskers
masters	9	46	2892	2	masters
maters	8	50	3239	2	ma_ters
matters	9	44	2175	2	matters
maulers	9	42	1330	2	maulers
mazer	16	57	2242	2	ma_zer_
mazes	16	56	3217	2	ma_ze_s
members	13	25	860	2	members
mimers	10	55	2018	2	mim_ers
momsers	11	38	1084	2	momsers
momzer	19	32	755	2	momzer_
mummers	10	37	1284	2	mummers
mumpers	13	33	1137	2	mumpers
namers	8	45	1733	2	nam_ers
pampers	13	36	1593	2	pampers
panzers	18	40	1201	2	panzers
patzers	18	42	1057	2	patzers
rammers	11	37	1504	2	rammers
razers	15	49	1961	2	ra_zers
tamers	8	42	2403	2	tam_ers
tampers	11	35	1674	2	tampers
vampers	14	31	1162	2	vampers
yammers	14	34	1032	2	yammers

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	65	3.423	31455.2
3	Display Results	65	65	0.013	5000.0
	(SQL Overall)	178691	65	3.809	46912.8