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

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

97 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
counted	10	38	1580	(None)
counter	9	42	2015	1	counter
courted	10	35	1492	1	courted
mounted	10	36	1153	1	mounted
accounted	14	4	483	2	accounted
amounted	11	3	553	2	amounted
blunted	10	42	1066	2	blunted
bounced	12	36	1055	2	bounced
bounded	11	36	1376	2	bounded
bountied	11	3	633	2	bountied
bunted	9	52	1918	2	_bunted
canted	9	48	2578	2	c_anted
chanted	13	40	1595	2	chanted
chaunted	14	8	560	2	chaunted
chunked	17	42	821	2	chunked
chunter	12	39	1148	2	chunter
chuted	12	46	1184	2	chu_ted
clouted	10	42	1216	2	clou_ted
clunked	14	43	957	2	clunked
coacted	12	36	1161	2	coacted
coapted	12	39	1151	2	coapted
coasted	10	40	1596	2	coasted
coated	9	49	2704	2	co_ated
coined	9	45	2360	2	coin_ed
cointer	9	36	1672	2	cointer
compted	14	38	1353	2	compted
coned	8	60	4005	2	co_n_ed
conked	13	50	1911	2	co_nked
conned	9	51	1970	2	co_nned
connoted	11	3	886	2	connoted
conte	7	66	3320	2	co_nte_
contend	10	35	1189	2	co_ntend
contes	8	44	3291	2	co_ntes
coopted	12	37	1078	2	coopted
corned	9	52	2452	2	corn_ed
cornfed	13	3	738	2	cornfed
cornuted	11	3	747	2	cornuted
costed	9	56	2312	2	co_sted
coted	8	50	3385	2	co__ted
couched	15	41	1579	2	couched
coughed	14	33	1090	2	coughed
coulter	9	41	1560	2	coulter
counsel	9	4	854	2	counsel
count	7	49	3205	2	count__
countered	12	3	1300	2	countered
counters	10	33	2019	2	counters
countess	10	37	1005	2	countess
counties	10	3	1628	2	counties
country	12	38	804	2	country
counts	8	46	1827	2	count_s
county	11	43	1332	2	count_y
couped	11	50	1931	2	cou_ped
coupled	12	43	1267	2	coupled
coursed	10	41	1360	2	coursed
courter	9	45	1648	2	courter
couter	8	49	3022	2	cou_ter
coveted	13	30	1152	2	coveted
crusted	10	37	1276	2	crusted
daunted	9	38	1019	2	daunted
doubted	11	30	748	2	doubted
dunted	8	47	1850	2	_dunted
founded	12	40	1142	2	founded
grunted	9	33	928	2	grunted
haunted	11	39	973	2	haunted
hounded	12	33	1103	2	hounded
hunted	10	44	1701	2	_hunted
jaunted	15	41	856	2	jaunted
jointed	15	37	850	2	jointed
jounced	17	33	761	2	jounced
jousted	15	33	914	2	jousted
lounged	9	46	824	2	lounged
louted	7	49	2069	2	lou_ted
lunted	7	45	1752	2	_lunted
moulted	10	33	1031	2	moulted
mounded	11	37	1198	2	mounded
mounter	9	37	1317	2	mounter
ousted	7	37	2058	2	_ousted
outed	6	54	2906	2	_ou_ted
pointed	10	38	1398	2	pointed
pounced	12	35	1062	2	pounced
pounded	11	41	1280	2	pounded
pouted	9	40	2139	2	pou_ted
punted	9	46	1871	2	_punted
recounted	12	3	872	2	recounted
rounded	9	30	1350	2	rounded
rousted	8	40	1333	2	rousted
routed	7	56	2433	2	rou_ted
scouted	10	41	1203	2	scou_ted
shunted	11	33	978	2	shunted
sounded	9	32	1446	2	sounded
stunted	8	30	1040	2	stunted
taunted	8	43	1096	2	taunted
touted	7	44	1974	2	tou_ted
uncounted	12	3	852	2	uncounted
vaunted	11	43	886	2	vaunted
wonted	10	32	1328	2	wo_nted
wounded	12	32	976	2	wounded

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	107671	0.390	458182.1
2	DLD Change Limit	107671	97	3.470	31029.1
3	Display Results	97	97	0.043	2255.8
	(SQL Overall)	178691	97	3.903	45783.0