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

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

77 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
chapter	14	42	1385	(None)
chanter	12	39	1973	1	chanter
chapiter	15	3	660	1	chapiter
chapters	15	40	1213	1	chapters
charter	12	39	1830	1	charter
chaster	12	47	1850	1	chaster
chatter	12	44	1664	1	chatter
adapter	10	3	617	2	adapter
apter	7	61	2020	2	__apter
canter	8	52	3011	2	c_anter
caper	9	48	3162	2	c_ap_er
capper	12	44	2198	2	c_apper
captor	10	49	1460	2	c_aptor
carter	8	49	3227	2	c_arter
caster	8	52	3257	2	c_aster
cater	7	48	4072	2	c_a_ter
chafer	14	47	1457	2	cha_fer
chaffer	18	38	947	2	chaffer
chamber	16	40	1106	2	chamber
chamfer	17	39	986	2	chamfer
champer	16	38	1341	2	champer
chancer	14	42	1563	2	chancer
changer	13	42	1554	2	changer
chanted	13	40	1595	2	chanted
chanters	13	40	1674	2	chanters
chantey	15	41	1254	2	chantey
chantor	12	37	1031	2	chantor
chape	12	52	2114	2	chap_e_
chapel	13	49	1137	2	chap_el
chapes	13	54	2187	2	chap_es
chapiters	16	3	520	2	chapiters
chaplet	14	5	1225	2	chaplet
chapmen	16	3	728	2	chapmen
chapped	17	27	1144	2	chapped
chapt	12	58	2764	2	chapt__
chapteral	16	4	470	2	chapteral
chaptered	17	17	680	2	chaptered
charger	13	39	1406	2	charger
charier	12	43	1790	2	charier
charmer	14	49	1366	2	charmer
charted	13	51	1685	2	charted
charters	13	41	1559	2	charters
chaser	11	49	1838	2	cha_ser
chaste	11	46	1739	2	chaste_
chasten	12	43	1240	2	chasten
chatted	13	34	1189	2	chatted
chattel	12	38	889	2	chattel
chatters	13	42	1395	2	chatters
chattery	16	35	727	2	chattery
chattier	13	3	751	2	chattier
chaufer	15	34	794	2	chaufer
chaunter	13	6	639	2	chaunter
chawer	14	43	1441	2	cha_wer
cheaper	14	40	1058	2	cheap_er
cheater	12	48	1696	2	cheater
chipper	16	39	1258	2	chipper
chitter	12	41	1296	2	chitter
chopper	16	36	1189	2	chopper
chunter	12	39	1148	2	chunter
clapper	13	40	1186	2	clapper
clatter	9	40	1497	2	clatter
coapted	12	39	1151	2	coapted
coaster	9	42	1904	2	coaster
coater	8	43	2957	2	coa_ter
copter	10	98	2201	2	c_opter
crafter	12	41	1133	2	crafter
crapper	13	39	1319	2	crapper
crater	8	50	2664	2	cra_ter
hafter	12	48	1588	2	_hafter
halter	9	44	2088	2	_halter
hapten	11	53	1298	2	_hapten
hater	8	50	3475	2	_ha_ter
hatter	9	47	2487	2	_hatter
phatter	12	38	1020	2	phatter
shaper	11	41	1993	2	shap_er
shatter	10	36	1570	2	shatter
whapper	17	34	827	2	whapper

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.373	479064.3
2	DLD Change Limit	107671	77	2.890	37256.4
3	Display Results	77	77	0.016	4812.5
	(SQL Overall)	178691	77	3.279	54495.6