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

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

54 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
clogging	13	36	850	(None)
blogging	13	36	901	1	blogging
clagging	13	32	888	1	clagging
cogging	12	35	1371	1	c_ogging
flogging	14	32	917	1	flogging
logging	10	33	1681	1	_logging
slogging	11	34	1049	1	slogging
beclogging	17	4	341	2	beclogging
blagging	13	31	917	2	blagging
bloggings	14	26	426	2	bloggings
bogging	12	36	1575	2	_bogging
chugging	16	3	491	2	chugging
clanging	12	40	1212	2	clanging
clinging	12	29	1091	2	clinging
cloaking	15	29	971	2	cloaking
clocking	17	43	1241	2	clocking
cloggier	12	4	425	2	cloggier
cloggily	15	4	324	2	cloggily
clomping	15	32	965	2	clomping
cloning	10	32	1547	2	clo_ning
clonking	15	38	1015	2	clonking
clopping	15	35	1108	2	clopping
closing	10	31	1484	2	clo_sing
clothing	14	27	878	2	clothing
clotting	11	31	1064	2	clotting
clouding	12	26	949	2	clouding
clouring	11	28	1127	2	clouring
clouting	11	30	1168	2	clouting
clowning	14	30	725	2	clowning
cloying	13	35	1175	2	clo_ying
dogging	11	33	1269	2	_dogging
flagging	14	32	923	2	flagging
floggings	15	31	412	2	floggings
fogging	13	35	1373	2	_fogging
frogging	14	35	873	2	frogging
glugging	10	31	635	2	glugging
hogging	13	31	1280	2	_hogging
jogging	17	32	1123	2	_jogging
lagging	10	33	1674	2	_lagging
legging	10	39	1264	2	_legging
lodging	10	31	1081	2	_lodging
loggings	11	39	823	2	_loggings
longing	9	39	1578	2	_longing
lugging	10	41	1435	2	_lugging
mogging	12	33	1149	2	_mogging
nogging	10	36	1272	2	_nogging
plugging	13	30	689	2	plugging
progging	13	26	1038	2	progging
shogging	14	30	802	2	shogging
slagging	11	37	1158	2	slagging
slugging	11	33	942	2	slugging
snogging	11	31	804	2	snogging
togging	10	35	1274	2	_togging
unclogging	15	4	354	2	unclogging

Search took 6 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	121059	0.393	454684.5
2	DLD Change Limit	121059	54	5.356	22602.5
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	5.765	30995.8