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

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

57 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
chaffed	19	38	770	(None)
chafed	15	48	1391	1	cha_fed
chaffer	18	38	947	1	chaffer
cheffed	19	33	586	1	cheffed
chuffed	19	31	664	1	chuffed
baffed	15	48	1217	2	_baffed
chafe	13	51	1735	2	cha_fe_
chafer	14	47	1457	2	cha_fer
chafes	14	50	1791	2	cha_fes
chaff	16	50	1628	2	chaff__
chaffered	21	15	448	2	chaffered
chaffers	19	37	800	2	chaffers
chaffier	19	3	547	2	chaffier
chaffs	17	45	961	2	chaff_s
chaffy	20	45	647	2	chaff_y
chained	13	38	1269	2	chained
chaired	13	42	1124	2	chaired
chalked	17	44	986	2	chalked
chamfer	17	39	986	2	chamfer
champed	17	41	1148	2	champed
chanced	15	41	1321	2	chanced
changed	14	42	1414	2	changed
chanted	13	40	1595	2	chanted
chapped	17	27	1144	2	chapped
chared	12	54	2369	2	cha_red
charged	14	46	1402	2	charged
charked	17	48	1401	2	charked
charmed	15	47	1425	2	charmed
charred	13	46	1449	2	charred
charted	13	51	1685	2	charted
chased	12	50	1929	2	cha_sed
chasmed	15	47	1017	2	chasmed
chassed	13	47	1213	2	chassed
chatted	13	34	1189	2	chatted
chaufer	15	34	794	2	chaufer
chauffer	19	26	379	2	chauffer
chawed	15	52	1460	2	cha_wed
chefed	15	50	1056	2	ch_efed
chuffer	18	33	714	2	chuffer
coiffed	16	3	541	2	coiffed
crafted	13	41	977	2	crafted
cuffed	15	43	1121	2	c_uffed
daffed	14	42	949	2	_daffed
gaffed	14	42	1020	2	_gaffed
haffet	15	3	1170	2	_haffet
hafted	13	47	1383	2	_hafted
huffed	16	37	1015	2	_huffed
naffed	13	40	833	2	_naffed
piaffed	16	9	375	2	piaffed
quaffed	23	3	425	2	quaffed
sclaffed	17	10	267	2	sclaffed
shafted	14	28	881	2	shafted
staffed	14	29	828	2	staffed
waffed	16	45	979	2	_waffed
wharfed	17	3	442	2	wharfed
whiffed	20	6	447	2	whiffed
yaffed	16	45	732	2	_yaffed

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	57	3.423	31455.2
3	Display Results	57	57	0.016	3562.5
	(SQL Overall)	178691	57	3.829	46667.8