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

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

67 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
cloaking	15	29	971	(None)
clocking	17	43	1241	1	clocking
clonking	15	38	1015	1	clonking
croaking	15	37	1216	1	croaking
becloaking	19	4	488	2	becloaking
bloating	11	35	1281	2	bloating
blocking	17	45	1057	2	blocking
caking	13	46	2467	2	c__aking
chocking	20	40	1101	2	chocking
choking	17	39	1194	2	cho_king
clacking	17	33	1349	2	clacking
clanking	15	43	1306	2	clanking
clawing	13	38	1267	2	cl_awing
claying	13	36	1430	2	cl_aying
cleaning	11	31	1238	2	cleaning
clearing	11	30	1488	2	clearing
cleating	11	35	1813	2	cleating
cleaving	14	138	968	2	cleaving
cleeking	15	26	781	2	cleeking
clerking	15	25	716	2	clerking
clicking	17	36	1098	2	clicking
clinking	15	36	1166	2	clinking
clogging	13	36	850	2	clogging
clomping	15	32	965	2	clomping
cloning	10	32	1547	2	clo_ning
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
clucking	17	42	999	2	clucking
clunking	15	32	943	2	clunking
coaling	10	37	2282	2	c_oaling
coaming	12	38	1832	2	c_oaming
coating	10	35	2531	2	c_oating
coaxing	17	35	1170	2	c_oaxing
cocking	16	36	1998	2	c_ocking
coking	13	45	2388	2	c_o_king
comaking	17	3	999	2	comaking
conking	14	36	1845	2	c_onking
cooking	14	38	1897	2	c_ooking
corking	14	30	1882	2	c_orking
creaking	15	34	1412	2	creaking
crocking	17	43	1344	2	crocking
crooking	15	36	1134	2	crooking
flaking	15	41	1449	2	fl_aking
floating	12	31	1188	2	floating
flocking	18	34	1087	2	flocking
gloaming	12	26	801	2	gloaming
gloating	10	26	1146	2	gloating
laking	11	50	2704	2	_l_aking
leaking	12	36	1697	2	_leaking
loading	9	41	1461	2	_loading
loafing	11	31	979	2	_loafing
loaming	10	36	1373	2	_loaming
loaning	8	36	1483	2	_loaning
locking	14	37	1815	2	_locking
looking	12	34	1504	2	_looking
plonking	15	35	856	2	plonking
slaking	12	37	1747	2	sl_aking
soaking	12	31	1661	2	_soaking
troaking	13	33	1097	2	troaking
uncloaking	17	8	485	2	uncloaking

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	121059	0.140	1276364.3
2	DLD Change Limit	121059	67	3.503	34558.7
3	Display Results	67	67	0.013	5153.8
	(SQL Overall)	178691	67	3.656	48876.1