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

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

86 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
clacking	17	33	1349	(None)
blacking	17	42	1360	1	blacking
clanking	15	43	1306	1	clanking
clicking	17	36	1098	1	clicking
clocking	17	43	1241	1	clocking
clucking	17	42	999	1	clucking
cracking	17	40	1390	1	cracking
flacking	18	43	1179	1	flacking
lacking	14	38	2154	1	_lacking
slacking	15	39	1413	1	slacking
backing	16	55	2344	2	_backing
blackings	18	31	676	2	blackings
blanking	15	44	1193	2	blanking
blocking	17	45	1057	2	blocking
caching	15	63	1750	2	c_aching
cackling	17	26	1094	2	c_ackling
caking	13	46	2467	2	c_a_king
calking	14	46	1778	2	c_alking
carking	14	43	2285	2	c_arking
casking	14	43	1735	2	c_asking
chalking	18	33	1006	2	chalking
charking	18	35	1261	2	charking
checking	20	37	920	2	checking
chocking	20	40	1101	2	chocking
chucking	20	37	950	2	chucking
cladding	13	3	714	2	cladding
clagging	13	32	888	2	clagging
claiming	13	27	930	2	claiming
clamming	15	32	937	2	clamming
clamping	15	40	1115	2	clamping
clanging	12	40	1212	2	clanging
clapping	15	38	1060	2	clapping
clashing	14	38	1219	2	clashing
clasping	13	33	1026	2	clasping
classing	11	32	1179	2	classing
clawing	13	38	1267	2	cla_wing
claying	13	36	1430	2	cla_ying
cleeking	15	26	781	2	cleeking
clerking	15	25	716	2	clerking
clinking	15	36	1166	2	clinking
cloaking	15	29	971	2	cloaking
clonking	15	38	1015	2	clonking
clunking	15	32	943	2	clunking
coaching	16	40	1196	2	coaching
coacting	13	34	1270	2	coacting
cocking	16	36	1998	2	c_ocking
crackings	18	34	684	2	crackings
crackling	18	15	700	2	crackling
cranking	15	46	1307	2	cranking
cricking	17	34	1265	2	cricking
crocking	17	43	1344	2	crocking
flaking	15	41	1449	2	fla_king
flanking	16	42	1108	2	flanking
flecking	18	40	823	2	flecking
flicking	18	41	1004	2	flicking
flocking	18	34	1087	2	flocking
glaceing	12	3	653	2	glaceing
hacking	17	37	2061	2	_hacking
jacking	21	45	1526	2	_jacking
knacking	14	29	671	2	knacking
lacing	9	46	2623	2	_lac_ing
laking	11	50	2704	2	_la_king
larking	12	37	1825	2	_larking
licking	14	41	1828	2	_licking
locking	14	37	1815	2	_locking
lucking	14	36	1583	2	_lucking
packing	16	44	2072	2	_packing
placing	12	38	1528	2	plac_ing
planking	15	35	1301	2	planking
plucking	17	35	772	2	plucking
quacking	24	3	674	2	quacking
racking	14	43	2366	2	_racking
sacking	14	41	2270	2	_sacking
shacking	18	40	1408	2	shacking
slaking	12	37	1747	2	sla_king
slicking	15	37	1259	2	slicking
smacking	17	35	1076	2	smacking
snacking	15	34	1170	2	snacking
stacking	15	42	1508	2	stacking
tacking	14	44	2148	2	_tacking
talcking	15	6	708	2	talcking
thacking	18	31	1004	2	thacking
tracking	15	37	1546	2	tracking
whacking	21	37	748	2	whacking
wracking	18	34	996	2	wracking
yacking	17	43	1568	2	_yacking

Search took 5 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	86	3.826	31641.1
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	4.249	42054.8