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

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

77 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
merging	11	27	1176	(None)
emerging	12	3	789	1	emerging
serging	9	34	1667	1	serging
verging	12	38	1230	1	verging
amercing	13	3	719	2	amercing
barging	11	40	1848	2	barging
begging	12	30	1265	2	begging
berming	12	36	1483	2	berming
cering	9	45	2253	2	cer_ing
demerging	14	3	664	2	demerging
edging	9	35	1071	2	_edging
egging	9	32	1098	2	_egging
erring	7	38	1648	2	_erring
forging	12	41	1472	2	forging
gorging	10	26	1136	2	gorging
gurging	10	29	1011	2	gurging
hedging	13	34	895	2	hedging
herding	12	29	1512	2	herding
herring	11	36	1588	2	herring
immerging	15	4	410	2	immerging
jerking	19	30	892	2	jerking
kedging	14	35	756	2	kedging
kegging	14	32	829	2	kegging
kerbing	14	30	848	2	kerbing
kerfing	15	30	753	2	kerfing
kerning	12	40	1089	2	kerning
legging	10	39	1264	2	legging
margin	9	40	1684	2	margin_
margins	10	38	1519	2	margins
marking	14	40	2013	2	marking
marling	10	33	2276	2	marling
marring	10	33	1955	2	marring
marting	10	33	2501	2	marting
meaning	10	39	1870	2	meaning
meeting	10	33	1496	2	meeting
melding	11	34	1427	2	melding
melling	10	28	2262	2	melling
melting	10	33	1775	2	melting
mending	11	40	1868	2	mending
mensing	10	39	1510	2	mensing
meouing	10	5	920	2	meouing
meowing	13	6	859	2	meowing
merino	8	3	1509	2	mer_ino
meriting	11	3	1468	2	meriting
merlin	8	39	1668	2	merlin_
merlins	9	30	1581	2	merlins
meshing	13	45	1381	2	meshing
messing	10	39	1639	2	messing
meting	9	43	2059	2	me_ting
metring	10	32	1529	2	metring
mewing	12	39	1420	2	me_wing
mewling	13	32	951	2	mewling
miring	9	37	2380	2	mir_ing
mogging	12	33	1149	2	mogging
morning	10	32	1504	2	morning
mugging	12	27	1179	2	mugging
muring	9	51	2037	2	mur_ing
nerving	11	29	1083	2	nerving
parging	11	33	1860	2	parging
pegging	12	28	1113	2	pegging
perking	14	37	1646	2	perking
perming	12	34	1609	2	perming
purging	11	33	1418	2	purging
remerging	13	5	832	2	remerging
sergings	10	29	921	2	sergings
sering	7	47	3181	2	ser_ing
serving	11	30	1498	2	serving
smerking	15	25	847	2	smerking
surging	9	31	1543	2	surging
terming	10	40	1600	2	terming
urging	8	34	1312	2	_urging
vegging	13	30	887	2	vegging
venging	12	37	1094	2	venging
versing	11	23	1419	2	versing
wedging	13	30	872	2	wedging
yerking	15	36	881	2	yerking
zeroing	17	3	834	2	zeroing

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.376	475242.0
2	DLD Change Limit	107671	77	3.530	30501.7
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	3.936	45399.1