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

Here are the results of your fuzzy-string dictionary search for “charted” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

112 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
charted	13	51	1685	(None)
carted	9	86	3144	1	c_arted
chanted	13	40	1595	1	chanted
chared	12	54	2369	1	char_ed
charged	14	46	1402	1	charged
charked	17	48	1401	1	charked
charmed	15	47	1425	1	charmed
charred	13	46	1448	1	charred
charter	12	39	1830	1	charter
chatted	13	34	1189	1	chatted
canted	9	48	2578	2	c_anted
carded	10	54	2490	2	c_arded
cared	8	60	5009	2	c_ar_ed
caried	9	45	2869	2	c_aried
carked	13	40	2482	2	c_arked
carped	11	59	2376	2	c_arped
carte	7	59	4042	2	c_arte_
cartel	8	50	2253	2	c_artel
carter	8	49	3227	2	c_arter
cartes	8	62	3947	2	c_artes
carved	12	43	2085	2	c_arved
catted	9	54	2247	2	c_atted
cerated	10	39	2247	2	cerated
chafed	15	48	1391	2	cha_fed
chaffed	19	38	770	2	chaffed
chained	13	38	1269	2	chained
chaired	13	42	1124	2	chaired
chalked	17	44	986	2	chalked
champed	17	41	1148	2	champed
chanced	15	41	1321	2	chanced
changed	14	42	1414	2	changed
chanter	12	39	1973	2	chanter
chantey	15	41	1254	2	chantey
chapped	17	27	1144	2	chapped
chapter	14	42	1385	2	chapter
charade	13	12	991	2	charade
chard	11	61	2474	2	char__d
chare	10	52	3198	2	char_e_
chares	11	56	3180	2	char_es
charge	12	51	1421	2	charge_
charger	13	39	1406	2	charger
charges	13	46	1598	2	charges
charier	12	43	1790	2	charier
charioted	15	9	586	2	charioted
charley	15	11	827	2	charley
charmer	14	49	1366	2	charmer
charnel	12	40	1005	2	charnel
chart	10	50	3828	2	chart__
chartered	15	15	839	2	chartered
charters	13	41	1558	2	charters
charts	11	58	2309	2	chart_s
chased	12	50	1929	2	cha_sed
chasmed	15	47	1017	2	chasmed
chassed	13	47	1213	2	chassed
chaste	11	46	1739	2	chaste_
chasten	12	43	1240	2	chasten
chaster	12	47	1850	2	chaster
chattel	12	38	889	2	chattel
chatter	12	44	1664	2	chatter
chaunted	14	8	560	2	chaunted
chawed	15	52	1460	2	cha_wed
cheated	13	44	1634	2	cheated
chested	13	38	1167	2	chested
chirked	17	38	1033	2	chirked
chirmed	15	37	973	2	chirmed
chirped	15	37	978	2	chirped
chirred	13	36	1212	2	chirred
chorded	14	47	1055	2	chorded
chored	12	53	2188	2	chor_ed
chorten	12	28	1130	2	chorten
chortled	14	32	661	2	chortled
churned	13	35	837	2	churned
churred	13	40	917	2	churred
chuted	12	46	1184	2	ch_uted
coacted	12	36	1161	2	coacted
coapted	12	39	1150	2	coapted
coasted	10	40	1595	2	coasted
coated	9	49	2704	2	coa_ted
courted	10	35	1492	2	courted
crafted	13	41	977	2	crafted
crated	9	48	2777	2	cra_ted
curated	10	47	1758	2	curated
darted	8	46	2092	2	_darted
farted	10	51	2178	2	_farted
hafted	13	47	1383	2	_hafted
halted	10	50	1960	2	_halted
hanted	10	41	2431	2	_hanted
hared	9	57	4218	2	_har_ed
harked	14	54	2255	2	_harked
harmed	12	52	1883	2	_harmed
harped	12	44	1840	2	_harped
hasted	10	51	2528	2	_hasted
hated	9	57	3402	2	_ha_ted
hatred	10	48	1433	2	_hatred
hatted	10	49	2151	2	_hatted
hearted	11	33	1402	2	hearted
marted	9	44	2521	2	_marted
parted	9	42	2868	2	_parted
recharted	15	5	756	2	recharted
scarted	10	48	1612	2	scarted
shafted	14	28	881	2	shafted
shared	10	58	2906	2	shar_ed
sharked	15	36	1391	2	sharked
sharped	13	41	1205	2	sharped
shorted	11	36	1440	2	shorted
smarted	10	50	1261	2	smarted
started	8	42	1732	2	started
tarted	7	49	2337	2	_tarted
thwarted	15	3	336	2	thwarted
uncharted	15	3	808	2	uncharted
warted	10	42	2323	2	_warted
wharfed	17	3	441	2	wharfed

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.376	475242.0
2	DLD Change Limit	107671	112	2.953	36461.6
3	Display Results	112	112	0.046	2434.8
	(SQL Overall)	178691	112	3.375	52945.5