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

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

101 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
chafer	14	47	1457	(None)
chafe	13	51	1735	1	chafe_
chafed	15	48	1391	1	chafed
chafers	15	45	1274	1	chafers
chafes	14	50	1791	1	chafes
chaffer	18	38	947	1	chaffer
chamfer	17	39	986	1	chamfer
chaser	11	49	1838	1	chaser
chaufer	15	34	794	1	chaufer
chawer	14	43	1441	1	chawer
caber	9	51	2683	2	c_aber
cafe	9	52	3032	2	c_afe_
cafes	10	64	2692	2	c_afes
cager	8	52	2922	2	c_ager
cahier	11	36	1577	2	cahier
caner	7	53	3477	2	c_aner
caper	9	48	3162	2	c_aper
carer	7	49	4233	2	c_arer
cater	7	48	4072	2	c_ater
caver	10	56	2906	2	c_aver
chadar	12	3	935	2	chadar
chador	12	3	867	2	chador
chaff	16	50	1628	2	chaf_f
chaffed	19	38	770	2	chaffed
chaffers	19	37	800	2	chaffers
chaffier	19	3	547	2	chaffier
chaffs	17	45	961	2	chaffs
chaffy	20	45	647	2	chaffy
chair	10	55	1963	2	cha_ir
chaleh	14	37	1199	2	chaleh
chalet	11	38	2599	2	chalet
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
chape	12	52	2114	2	chape_
chapel	13	49	1137	2	chapel
chapes	13	54	2187	2	chapes
chapter	14	42	1385	2	chapter
char	9	51	3215	2	cha__r
chare	10	52	3198	2	chare_
chared	12	54	2369	2	chared
chares	11	56	3180	2	chares
charger	13	39	1406	2	charger
charier	12	43	1790	2	charier
charmer	14	49	1366	2	charmer
charr	10	48	2178	2	cha_rr
charter	12	39	1830	2	charter
chase	10	51	2712	2	chase_
chased	12	50	1929	2	chased
chasers	12	37	1492	2	chasers
chases	11	51	2823	2	chases
chaster	12	47	1850	2	chaster
chatter	12	44	1664	2	chatter
chaufers	16	34	730	2	chaufers
chauffer	19	26	379	2	chauffer
chawed	15	52	1460	2	chawed
chawers	15	44	1205	2	chawers
cheaper	14	40	1058	2	cheaper
cheater	12	48	1696	2	cheater
cheder	12	51	1349	2	cheder
cheer	10	54	2038	2	ch_eer
chefed	15	50	1056	2	chefed
chewer	14	55	1262	2	chewer
chicer	13	45	1360	2	chicer
chider	12	51	1605	2	chider
chiefer	15	3	686	2	chiefer
chimer	13	55	1720	2	chimer
choker	15	43	1437	2	choker
choler	11	37	1715	2	choler
chuffer	18	33	714	2	chuffer
claver	11	38	1697	2	claver
clawer	11	45	1278	2	clawer
coaler	8	41	2171	2	coaler
coater	8	43	2957	2	coater
coaxer	15	39	1279	2	coaxer
coffer	14	41	1286	2	coffer
confer	11	40	1868	2	confer
crafter	12	41	1133	2	crafter
crater	8	50	2664	2	crater
craver	11	46	1847	2	craver
deafer	10	41	1481	2	deafer
hafter	12	48	1588	2	_hafter
haler	8	50	3353	2	_haler
hater	8	50	3475	2	_hater
haver	11	51	2446	2	_haver
hayer	11	46	2024	2	_hayer
hazer	17	48	2023	2	_hazer
loafer	9	36	1094	2	loafer
safer	8	47	2181	2	_safer
shader	10	42	1876	2	shader
shaker	13	43	1946	2	shaker
shaper	11	41	1993	2	shaper
sharer	9	50	2548	2	sharer
shaver	12	37	1891	2	shaver
thaler	9	46	1310	2	thaler
thawer	12	48	934	2	thawer
wafer	11	44	1765	2	_wafer
whaler	12	46	1198	2	whaler

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	101	2.530	32628.9
3	Display Results	101	101	0.030	3366.7
	(SQL Overall)	178691	101	2.903	61553.9