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

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

69 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
chalking	18	33	1006	(None)
calking	14	46	1778	1	c_alking
charking	18	35	1261	1	charking
balking	14	37	1735	2	_balking
bechalking	22	4	411	2	bechalking
caking	13	46	2467	2	c_a_king
calkin	12	35	1549	2	c_alkin_
calkings	15	28	922	2	c_alkings
calkins	13	38	1487	2	c_alkins
calling	10	38	2677	2	c_alling
calming	12	39	1597	2	c_alming
calving	13	41	1350	2	c_alving
carking	14	43	2285	2	c_arking
casking	14	43	1735	2	c_asking
caulking	15	3	680	2	caulking
chaffing	20	3	632	2	chaffing
chafing	16	39	1149	2	cha_fing
chaining	14	28	1078	2	chaining
chairing	14	31	1077	2	chairing
chalkier	17	3	675	2	chalkier
champing	18	36	1093	2	champing
chancing	16	28	1028	2	chancing
changing	15	32	1151	2	changing
chanting	14	34	1353	2	chanting
chapping	18	37	1072	2	chapping
charging	15	29	1077	2	charging
charing	13	37	2132	2	cha_ring
charming	16	30	1203	2	charming
charring	14	29	1316	2	charring
charting	14	26	1419	2	charting
chasing	13	37	1589	2	cha_sing
chatting	14	28	1014	2	chatting
chawing	16	48	1303	2	cha_wing
checking	20	37	920	2	checking
cheeking	18	34	908	2	cheeking
childing	15	28	850	2	childing
chilling	14	35	1218	2	chilling
chinking	18	32	1089	2	chinking
chirking	18	33	938	2	chirking
chocking	20	40	1101	2	chocking
choking	17	39	1194	2	ch_oking
chucking	20	37	950	2	chucking
chunking	18	32	805	2	chunking
clacking	17	33	1349	2	clacking
clanking	15	43	1306	2	clanking
coaling	10	37	2282	2	coal_ing
cracking	17	40	1390	2	cracking
cranking	15	46	1307	2	cranking
hacking	17	37	2061	2	_hacking
haling	10	42	2978	2	_hal_ing
haloing	11	38	1413	2	_haloing
halting	11	44	1907	2	_halting
halving	14	35	1154	2	_halving
hanking	15	46	1910	2	_hanking
harking	15	41	2094	2	_harking
hawking	18	37	1142	2	_hawking
holking	15	35	1231	2	_holking
hulking	15	39	1098	2	_hulking
shacking	18	40	1408	2	shacking
shaking	15	33	1725	2	sha_king
shanking	16	36	1228	2	shanking
sharking	16	39	1297	2	sharking
stalking	13	35	1222	2	stalking
talking	12	38	1582	2	_talking
thacking	18	31	1004	2	thacking
thanking	16	40	952	2	thanking
walking	15	40	1330	2	_walking
whacking	21	37	748	2	whacking
whaling	14	39	1077	2	whal_ing

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.390	458182.1
2	DLD Change Limit	121059	69	4.000	30264.8
3	Display Results	69	69	0.016	4312.5
	(SQL Overall)	178691	69	4.406	40556.3