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

Here are the results of your fuzzy-string dictionary search for “chaff” 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
chaff	16	50	1628	(None)
caff	12	56	3167	1	c_aff
chafe	13	51	1735	1	chafe
chaffs	17	45	961	1	chaffs
chaffy	20	45	647	1	chaffy
chuff	16	48	1249	1	chuff
aff	9	55	3761	2	__aff
baff	12	46	3226	2	_baff
blaff	13	52	1648	2	blaff
cafe	9	52	3032	2	c_afe
caffs	13	54	1737	2	c_affs
calf	9	63	3956	2	c_alf
chad	10	55	2550	2	cha_d
chads	11	61	2223	2	chads
chafed	15	48	1391	2	chafed
chafer	14	47	1457	2	chafer
chafes	14	50	1791	2	chafes
chaffed	19	38	770	2	chaffed
chaffer	18	38	947	2	chaffer
chai	9	59	2990	2	cha_i
chain	10	57	2367	2	chain
chair	10	55	1963	2	chair
chais	10	75	3031	2	chais
chalk	14	48	1460	2	chalk
cham	11	55	3231	2	cha_m
champ	14	50	1796	2	champ
chams	12	60	2850	2	chams
chang	11	54	1856	2	chang
chant	10	59	3269	2	chant
chao	9	57	2731	2	cha_o
chaos	10	56	2286	2	chaos
chap	11	49	2849	2	cha_p
chape	12	52	2114	2	chape
chaps	12	53	2606	2	chaps
chapt	12	58	2764	2	chapt
char	9	51	3215	2	cha_r
chard	11	61	2474	2	chard
chare	10	52	3198	2	chare
chark	14	42	2271	2	chark
charm	12	61	2466	2	charm
charr	10	48	2178	2	charr
chars	10	59	3663	2	chars
chart	10	50	3828	2	chart
chary	13	50	2313	2	chary
chase	10	51	2712	2	chase
chasm	12	55	1879	2	chasm
chat	9	55	4613	2	cha_t
chats	10	57	3009	2	chats
chaw	12	62	2463	2	cha_w
chaws	13	50	2246	2	chaws
chay	12	49	2487	2	cha_y
chays	13	53	1974	2	chays
chef	12	51	2562	2	ch_ef
chefs	13	62	1466	2	chefs
chief	13	44	1947	2	chief
chufa	13	48	911	2	chufa
chuffs	17	42	778	2	chuffs
chuffy	20	44	586	2	chuffy
cliff	13	59	1712	2	cliff
coff	12	69	3078	2	c_off
craft	10	53	2766	2	craft
cuff	12	53	2799	2	c_uff
daff	11	52	2968	2	_daff
draff	12	56	1566	2	draff
gaff	11	48	2815	2	_gaff
haaf	10	62	2773	2	_haaf
haft	10	59	4184	2	_haft
half	10	62	3845	2	_half
huff	13	56	2384	2	_huff
khaf	14	53	1960	2	kha_f
khafs	15	64	884	2	khafs
naff	10	51	2893	2	_naff
quaff	20	13	1135	2	quaff
raff	10	49	3304	2	_raff
sclaff	14	3	831	2	sclaff
shaft	11	57	2525	2	shaft
staff	11	38	1771	2	staff
waff	13	42	2804	2	_waff
wharf	14	3	1582	2	wharf
whiff	17	3	1005	2	whiff
yaff	13	53	2426	2	_yaff

Search took 5 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	53800	0.190	940478.9
2	DLD Change Limit	53800	81	3.763	14297.1
3	Display Results	81	81	0.063	1285.7
	(SQL Overall)	178691	81	4.016	44494.8