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

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

89 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
clanking	15	43	1306	(None)
blanking	15	44	1193	1	blanking
clacking	17	33	1349	1	clacking
clanging	12	40	1212	1	clanging
clinking	15	36	1166	1	clinking
clonking	15	38	1015	1	clonking
clunking	15	32	943	1	clunking
cranking	15	46	1307	1	cranking
flanking	16	42	1108	1	flanking
planking	15	35	1301	1	planking
banking	14	46	2135	2	_banking
blacking	17	42	1360	2	blacking
blinking	15	35	1062	2	blinking
caking	13	46	2467	2	c_a_king
calking	14	46	1778	2	c_alking
caning	9	41	2862	2	c_an_ing
canning	10	36	2013	2	c_anning
canting	10	47	2590	2	c_anting
carking	14	43	2285	2	c_arking
casking	14	43	1735	2	c_asking
chalking	18	33	1006	2	chalking
chancing	16	28	1028	2	chancing
changing	15	32	1151	2	changing
chanting	14	34	1353	2	chanting
charking	18	35	1261	2	charking
chinking	18	32	1089	2	chinking
chunking	18	32	805	2	chunking
cladding	13	3	714	2	cladding
clagging	13	32	887	2	clagging
claiming	13	27	930	2	claiming
clamming	15	32	937	2	clamming
clamping	15	40	1115	2	clamping
clankier	14	32	708	2	clankier
clankingly	20	4	331	2	clankingly
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
cleaning	11	31	1238	2	clean_ing
cleansing	12	3	507	2	cleansing
cleeking	15	26	781	2	cleeking
clerking	15	25	716	2	clerking
clicking	17	36	1098	2	clicking
clinging	12	29	1091	2	clinging
cloaking	15	29	971	2	cloaking
clocking	17	43	1241	2	clocking
cloning	10	32	1547	2	clon_ing
clucking	17	42	999	2	clucking
conking	14	36	1845	2	c_onking
cracking	17	40	1390	2	cracking
craning	10	36	2030	2	cran_ing
crankling	16	14	729	2	crankling
flacking	18	43	1179	2	flacking
flaking	15	41	1449	2	fla_king
flanging	13	27	1058	2	flanging
flunking	16	31	777	2	flunking
franking	16	43	1086	2	franking
glancing	12	4	706	2	glancing
hanking	15	46	1910	2	_hanking
lacking	14	38	2154	2	_lacking
laking	11	50	2704	2	_la_king
lancing	10	33	1412	2	_lancing
landing	9	28	1932	2	_landing
larking	12	37	1825	2	_larking
linking	12	38	1825	2	_linking
planing	10	34	1825	2	plan_ing
plankings	16	32	611	2	plankings
planning	11	36	1022	2	planning
planting	11	35	1538	2	planting
plinking	15	36	1124	2	plinking
plonking	15	35	856	2	plonking
plunking	15	32	848	2	plunking
pranking	15	38	1338	2	pranking
ranking	12	43	2088	2	_ranking
shanking	16	36	1228	2	shanking
skanking	12	28	874	2	skanking
slacking	15	39	1413	2	slacking
slaking	12	37	1747	2	sla_king
slanging	10	34	1343	2	slanging
slanting	9	41	1509	2	slanting
slinking	13	34	1298	2	slinking
spanking	15	39	1197	2	spanking
swanking	16	39	996	2	swanking
tanking	12	39	1879	2	_tanking
thanking	16	40	952	2	thanking
wanking	15	42	1678	2	_wanking
yanking	15	45	1246	2	_yanking

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.390	458182.1
2	DLD Change Limit	121059	89	3.376	35858.7
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	3.796	47073.5