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

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

51 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
chaffer	18	38	947	(None)
chafer	14	47	1457	1	cha_fer
chaffed	19	38	770	1	chaffed
chaffers	19	37	800	1	chaffers
chaffier	19	3	547	1	chaffier
chamfer	17	39	986	1	chamfer
chaufer	15	34	794	1	chaufer
chauffer	19	26	379	1	chauffer
chuffer	18	33	714	1	chuffer
chafe	13	51	1735	2	cha_fe_
chafed	15	48	1391	2	cha_fed
chafers	15	45	1274	2	cha_fers
chafes	14	50	1791	2	cha_fes
chaff	16	50	1628	2	chaff__
chaffered	21	15	448	2	chaffered
chafferer	20	13	392	2	chafferer
chaffs	17	45	961	2	chaff_s
chaffy	20	45	647	2	chaff_y
chamber	16	40	1106	2	chamber
chamfers	18	40	922	2	chamfers
champer	16	38	1341	2	champer
chancer	14	42	1563	2	chancer
changer	13	42	1554	2	changer
chanter	12	39	1973	2	chanter
chapter	14	42	1385	2	chapter
charger	13	39	1406	2	charger
charier	12	43	1790	2	charier
charmer	14	49	1366	2	charmer
charter	12	39	1830	2	charter
chaser	11	49	1838	2	cha_ser
chaster	12	47	1850	2	chaster
chatter	12	44	1664	2	chatter
chaufers	16	34	730	2	chaufers
chauffers	20	25	344	2	chauffers
chauffeur	20	22	198	2	chauffeur
chawer	14	43	1441	2	cha_wer
cheffed	19	33	586	2	cheffed
chiefer	15	3	686	2	chiefer
chuffed	19	31	664	2	chuffed
chuffier	19	3	454	2	chuffier
coffer	14	41	1286	2	c_offer
crafter	12	41	1133	2	crafter
gaffer	13	43	1013	2	_gaffer
haffet	15	3	1170	2	_haffet
hafter	12	48	1588	2	_hafter
piaffer	15	10	444	2	piaffer
quaffer	22	3	513	2	quaffer
sclaffer	16	11	265	2	sclaffer
staffer	13	29	909	2	staffer
whiffer	19	10	532	2	whiffer
zaffer	21	39	715	2	_zaffer

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	51	3.186	33795.0
3	Display Results	51	51	0.033	1545.5
	(SQL Overall)	178691	51	3.592	49746.9