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

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

82 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
counting	11	31	1527	(None)
courting	11	25	1457	1	courting
mounting	11	27	1181	1	mounting
accounting	15	4	492	2	accounting
amounting	12	3	664	2	amounting
blunting	11	31	984	2	blunting
bouncing	13	31	877	2	bouncing
bounding	12	30	1213	2	bounding
bunting	10	37	1883	2	_bunting
canting	10	47	2590	2	c_anting
chanting	14	34	1353	2	chanting
chaunting	15	5	541	2	chaunting
chunking	18	32	805	2	chunking
chuting	13	29	1073	2	chu_ting
clouting	11	30	1168	2	clou_ting
clunking	15	32	943	2	clunking
coacting	13	34	1270	2	coacting
coapting	13	35	1161	2	coapting
coasting	11	36	1551	2	coasting
coating	10	35	2531	2	co_ating
coining	10	39	2054	2	coin_ing
compting	15	30	1360	2	compting
coning	9	43	3182	2	co_n_ing
conking	14	36	1845	2	co_nking
conning	10	37	1875	2	co_nning
connoting	12	3	1002	2	connoting
coopting	13	34	1131	2	coopting
corning	10	37	2012	2	corn_ing
costing	10	43	2302	2	co_sting
coting	9	46	2925	2	co__ting
couching	16	32	1326	2	couching
coughing	15	30	921	2	coughing
countering	13	3	1447	2	countering
countian	10	4	812	2	countian
countians	11	4	733	2	countians
counties	10	3	1628	2	counties
couping	12	43	1702	2	cou_ping
coupling	13	3	1078	2	coupling
coursing	11	31	1202	2	coursing
coveting	14	19	1230	2	coveting
crusting	11	36	1279	2	crusting
cunning	10	42	1462	2	c_unning
cutting	10	38	1749	2	c_utting
daunting	10	33	1040	2	daunting
doubting	12	3	737	2	doubting
dunting	9	34	1838	2	_dunting
founding	13	30	1079	2	founding
grunting	10	26	958	2	grunting
haunting	12	35	1005	2	haunting
hounding	13	26	1005	2	hounding
hunting	11	43	1712	2	_hunting
jaunting	16	32	863	2	jaunting
jointing	16	24	861	2	jointing
jouncing	18	33	685	2	jouncing
jousting	16	30	935	2	jousting
lounging	10	3	675	2	lounging
louting	8	37	1938	2	lou_ting
lunting	8	38	1774	2	_lunting
moulting	11	27	1031	2	moulting
mounding	12	33	1126	2	mounding
mountings	12	26	616	2	mountings
munting	10	37	1877	2	_munting
ousting	8	40	2135	2	_ousting
outing	7	41	2815	2	_ou_ting
pointing	11	28	1368	2	pointing
pouncing	13	31	888	2	pouncing
pounding	12	33	1147	2	pounding
pouting	10	35	1994	2	pou_ting
punting	10	33	1844	2	_punting
recounting	13	3	919	2	recounting
rounding	10	28	1228	2	rounding
rousting	9	39	1327	2	rousting
routing	8	38	2109	2	rou_ting
scouting	11	26	1275	2	scou_ting
shunting	12	36	1043	2	shunting
sounding	10	27	1287	2	sounding
stunting	9	28	1150	2	stunting
taunting	9	35	1093	2	taunting
touting	8	41	1845	2	tou_ting
vaunting	12	33	875	2	vaunting
wonting	11	32	1410	2	wo_nting
wounding	13	24	940	2	wounding

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.143	1249587.4
2	DLD Change Limit	121059	82	4.403	27494.7
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	4.579	39024.0