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

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

84 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
chafing	16	39	1149	(None)
chaffing	20	3	632	1	chaffing
charing	13	37	2132	1	charing
chasing	13	37	1589	1	chasing
chawing	16	48	1303	1	chawing
chefing	16	35	904	1	chefing
caging	10	53	2102	2	c_aging
caking	13	46	2467	2	c_aking
caning	9	41	2863	2	c_aning
caring	9	51	3799	2	c_aring
casing	9	48	2910	2	c_asing
caving	12	48	2261	2	c_aving
cawing	12	43	2261	2	c_awing
ceasing	10	41	1826	2	ceasing
chain	10	57	2367	2	cha_in_
chaine	11	51	1922	2	cha_ine
chaining	14	28	1079	2	chaining
chains	11	48	1970	2	cha_ins
chairing	14	31	1077	2	chairing
chalking	18	33	1006	2	chalking
champing	18	36	1093	2	champing
chancing	16	28	1028	2	chancing
chang	11	54	1856	2	cha__ng
changing	15	32	1151	2	changing
chanting	14	34	1353	2	chanting
chapping	18	37	1072	2	chapping
charging	15	29	1077	2	charging
charking	18	35	1261	2	charking
charming	16	30	1203	2	charming
charring	14	29	1316	2	charring
charting	14	26	1419	2	charting
chasings	14	31	825	2	chasings
chatting	14	28	1014	2	chatting
cheating	14	40	1452	2	cheating
cheffing	20	3	446	2	cheffing
chewing	16	39	1115	2	chewing
chiding	14	39	1159	2	chiding
chiming	15	33	1183	2	chiming
chining	13	33	1685	2	chining
choking	17	39	1194	2	choking
choring	13	36	1766	2	choring
chowing	16	44	1277	2	chowing
chuffing	20	5	504	2	chuffing
chuting	13	29	1073	2	chuting
clawing	13	38	1267	2	clawing
claying	13	36	1430	2	claying
coaling	10	37	2283	2	coaling
coaming	12	38	1833	2	coaming
coating	10	35	2532	2	coating
coaxing	17	35	1171	2	coaxing
coffing	16	38	1126	2	coffing
coifing	13	32	1390	2	coifing
crafting	14	37	1017	2	crafting
craning	10	36	2031	2	craning
craping	12	40	1871	2	craping
crating	10	37	2520	2	crating
craving	13	40	1573	2	craving
crazing	19	39	1458	2	crazing
cuffing	16	32	1025	2	cuffing
hading	11	39	2294	2	_hading
haeing	10	41	1892	2	_haeing
hafting	14	40	1417	2	_hafting
haling	10	42	2978	2	_haling
haring	10	42	3300	2	_haring
hating	10	49	2971	2	_hating
having	13	42	2037	2	_having
hawing	13	43	2235	2	_hawing
haying	13	44	2061	2	_haying
hazing	19	42	1855	2	_hazing
leafing	11	33	1358	2	leafing
loafing	11	31	979	2	loafing
phasing	13	32	1167	2	phasing
shading	12	31	1556	2	shading
shafting	15	27	868	2	shafting
shaking	15	33	1725	2	shaking
shaming	13	30	1674	2	shaming
shaping	13	31	1618	2	shaping
sharing	11	37	2324	2	sharing
shaving	14	34	1433	2	shaving
shawing	14	35	1488	2	shawing
sheafing	15	32	948	2	sheafing
thawing	14	37	868	2	thawing
whaling	14	39	1077	2	whaling
wharfing	18	3	468	2	wharfing

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	84	3.173	33933.5
3	Display Results	84	84	0.033	2545.5
	(SQL Overall)	178691	84	3.579	49927.6