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

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

81 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
chafers	15	45	1274	(None)
chafer	14	47	1457	1	chafer_
chafes	14	50	1791	1	chafe_s
chaffers	19	37	800	1	chaffers
chamfers	18	40	922	1	chamfers
chasers	12	37	1492	1	chasers
chaufers	16	34	730	1	chaufers
chawers	15	44	1205	1	chawers
cabers	10	50	2392	2	c_abers
cafes	10	64	2692	2	c_afe_s
cagers	9	56	2419	2	c_agers
cahiers	12	35	1067	2	cahiers
caners	8	46	2920	2	c_aners
capers	10	54	2814	2	c_apers
carers	8	51	3396	2	c_arers
caters	8	53	3650	2	c_aters
cavers	11	50	2684	2	c_avers
chadars	13	3	829	2	chadars
chadors	13	3	875	2	chadors
chafe	13	51	1735	2	chafe__
chafed	15	48	1391	2	chafe_d
chaffer	18	38	947	2	chaffer_
chaffs	17	45	961	2	chaf_fs
chairs	11	49	1618	2	cha_irs
chalehs	15	26	880	2	chalehs
chalets	12	28	1347	2	chalets
chambers	17	34	1062	2	chambers
chamfer	17	39	986	2	chamfer_
champers	17	33	1162	2	champers
chancers	15	43	1349	2	chancers
changers	14	43	1320	2	changers
chanters	13	40	1674	2	chanters
chapels	14	42	915	2	chapels
chapes	13	54	2187	2	chape_s
chapters	15	40	1213	2	chapters
chares	11	56	3180	2	chare_s
chargers	14	40	1132	2	chargers
charmers	15	42	1133	2	charmers
charrs	11	52	1919	2	cha_rrs
chars	10	59	3664	2	cha__rs
charters	13	41	1558	2	charters
chaser	11	49	1838	2	chaser_
chases	11	51	2823	2	chase_s
chatters	13	42	1395	2	chatters
chaufer	15	34	794	2	chaufer_
chauffers	20	25	344	2	chauffers
chawer	14	43	1441	2	chawer_
cheaters	13	36	1351	2	cheaters
cheders	13	45	1239	2	cheders
cheers	11	45	1891	2	ch_eers
chewers	15	41	1114	2	chewers
chiders	13	53	1294	2	chiders
chimers	14	45	1514	2	chimers
chokers	16	43	1152	2	chokers
cholers	12	42	1520	2	cholers
clavers	12	43	1490	2	clavers
clawers	12	39	1097	2	clawers
coalers	9	44	1935	2	coalers
coaters	9	35	2579	2	coaters
coaxers	16	43	1108	2	coaxers
coffers	15	41	1269	2	coffers
confers	12	41	2009	2	confers
crafters	13	41	995	2	crafters
craters	9	50	2189	2	craters
cravers	12	44	1656	2	cravers
hafters	13	46	1433	2	_hafters
halers	9	49	2691	2	_halers
haters	9	49	3040	2	_haters
havers	12	47	2148	2	_havers
hayers	12	44	1594	2	_hayers
hazers	18	46	1595	2	_hazers
loafers	10	34	946	2	loafers
shaders	11	59	1555	2	shaders
shakers	14	40	1556	2	shakers
shapers	12	40	1689	2	shapers
sharers	10	47	2062	2	sharers
shavers	13	41	1509	2	shavers
thalers	10	62	1226	2	thalers
thawers	13	42	848	2	thawers
wafers	12	43	1614	2	_wafers
whalers	13	52	970	2	whalers

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	81	3.513	30649.3
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	3.936	45399.1