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

Here are the results of your fuzzy-string dictionary search for “chatting” 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
chatting	14	28	1014	(None)
catting	10	39	2264	1	c_atting
chanting	14	34	1353	1	chanting
charting	14	26	1419	1	charting
hatting	11	39	2023	1	_hatting
batting	10	44	2227	2	_batting
blatting	11	41	1165	2	blatting
canting	10	47	2590	2	c_anting
carting	10	42	2828	2	c_arting
casting	10	46	2834	2	c_asting
catling	10	48	1979	2	c_atling
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
chalking	18	33	1006	2	chalking
champing	18	36	1093	2	champing
chancing	16	28	1028	2	chancing
changing	15	32	1151	2	changing
chapping	18	37	1072	2	chapping
charging	15	29	1077	2	charging
charing	13	37	2132	2	cha_ring
charking	18	35	1261	2	charking
charming	16	30	1203	2	charming
charring	14	29	1316	2	charring
chasing	13	37	1589	2	cha_sing
chattering	16	10	864	2	chattering
chattier	13	3	751	2	chattier
chattily	16	3	460	2	chattily
chaunting	15	5	541	2	chaunting
chawing	16	48	1303	2	cha_wing
cheating	14	40	1452	2	cheating
chitling	14	29	1066	2	chitling
chuting	13	29	1073	2	ch_uting
clotting	11	31	1064	2	clotting
coacting	13	34	1270	2	coacting
coapting	13	35	1161	2	coapting
coasting	11	36	1551	2	coasting
coating	10	35	2531	2	coa_ting
crafting	14	37	1017	2	crafting
crating	10	37	2520	2	cra_ting
cutting	10	38	1749	2	c_utting
dratting	10	38	965	2	dratting
fatting	11	38	1870	2	_fatting
flatting	12	35	1125	2	flatting
hafting	14	40	1417	2	_hafting
halting	11	44	1907	2	_halting
hanting	11	41	2448	2	_hanting
hasting	11	47	2519	2	_hasting
hating	10	49	2971	2	_ha_ting
hitting	11	30	1727	2	_hitting
hotting	11	31	1652	2	_hotting
hutting	11	30	1603	2	_hutting
matting	10	36	2014	2	_matting
patting	10	37	2234	2	_patting
platting	11	48	1303	2	platting
ratting	8	38	2236	2	_ratting
scatting	11	33	1181	2	scatting
shafting	15	27	868	2	shafting
shitting	12	32	1266	2	shitting
shotting	12	30	1238	2	shotting
shutting	12	30	969	2	shutting
slatting	9	40	1423	2	slatting
spatting	11	31	1176	2	spatting
swatting	12	30	959	2	swatting
tatting	8	40	1952	2	_tatting
unhatting	13	3	587	2	unhatting
vatting	11	36	1485	2	_vatting
whetting	15	3	597	2	whetting

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	69	3.700	32718.6
3	Display Results	69	69	0.016	4312.5
	(SQL Overall)	178691	69	4.109	43487.7