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

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

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
coldcocking	20	9	148	(None)
clocking	17	43	1241	3	c_l__ocking
coldcock	16	4	277	3	coldcock___
coldcocked	19	5	130	3	coldcock_ed
coldcocks	17	4	254	3	coldcock__s
concocting	14	4	841	3	co_ncocting
blocking	17	45	1057	4	_bl__ocking
boldfacing	19	5	148	4	boldfac_ing
chocking	20	40	1101	4	c___hocking
clacking	17	33	1349	4	c_l__acking
clicking	17	36	1098	4	c_l__icking
cloaking	15	29	971	4	c_l__oaking
clodhopping	22	5	122	4	clodhopping
clonking	15	38	1015	4	c_l__onking
clucking	17	42	999	4	c_l__ucking
cocking	16	36	1998	4	____cocking
cocooning	14	4	702	4	co__cooning
collecting	15	4	828	4	col_lecting
collocating	16	4	590	4	collocating
colloguing	14	4	454	4	col_loguing
colocating	15	4	862	4	coloc_ating
coloring	11	4	1484	4	col__o_ring
colouring	12	5	873	4	col__ouring
condoling	13	5	1037	4	cond_o_ling
condoning	13	3	978	4	cond_o_ning
conducing	15	3	769	4	cond_uc_ing
conducting	16	4	883	4	cond_ucting
convoking	19	3	574	4	co_nvo_king
cooking	14	38	1897	4	co___o_king
cordoning	13	3	806	4	cord_o_ning
crocking	17	43	1344	4	c___rocking
deadlocking	20	5	171	4	deadlocking
docking	15	36	1501	4	___d_ocking
flocking	18	34	1087	4	_fl__ocking
forelocking	21	4	259	4	forelocking
goldbricking	23	6	85	4	goldbricking
gridlocking	20	5	116	4	gridlocking
locking	14	37	1815	4	__l__ocking
noncoking	16	4	681	4	no_nco_king
outcooking	17	4	552	4	_outcooking
outrocking	17	4	705	4	_outrocking
paddocking	21	4	241	4	_paddocking
padlocking	20	4	302	4	_padlocking
peacocking	21	4	331	4	_peacocking
politicking	20	6	334	4	politicking
recocking	18	13	837	4	__recocking
redocking	17	12	678	4	_red_ocking
relocking	16	13	768	4	rel__ocking
roadblocking	22	6	90	4	roadblocking
rollicking	17	4	293	4	rol_licking
uncocking	18	3	623	4	__uncocking
undocking	17	3	565	4	_und_ocking
unlocking	16	3	607	4	unl__ocking
woodworking	23	5	140	4	woodworking

Search took 9 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	148819	0.420	425454.8
2	DLD Change Limit	148819	54	8.096	18381.8
3	Display Results	54	54	0.013	4153.8
	(SQL Overall)	178691	54	8.529	20951.0