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

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

39 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
drafting	13	33	941	(None)
crafting	14	37	1017	1	crafting
draftings	14	33	421	1	draftings
dratting	10	38	966	1	dratting
drifting	13	33	873	1	drifting
grafting	13	31	962	1	grafting
rafting	11	38	1575	1	_rafting
crating	10	37	2520	2	cra_ting
daffing	15	36	973	2	d_affing
darting	9	40	2066	2	d_arting
dating	8	53	2648	2	d_a_ting
dauting	9	38	1476	2	d_auting
dawting	12	36	1067	2	d_awting
derating	10	32	2228	2	dera_ting
deratting	11	3	951	2	deratting
doating	9	38	1686	2	doa_ting
drabbing	14	28	680	2	drabbing
draftier	12	8	526	2	draftier
draftily	15	3	441	2	draftily
dragging	12	30	810	2	dragging
draining	10	33	1267	2	draining
dramming	14	34	757	2	dramming
draping	11	42	1335	2	dra_ping
drawing	12	38	1205	2	dra_wing
drawling	13	31	867	2	drawling
draying	12	38	1384	2	dra_ying
granting	10	35	1452	2	granting
grating	9	39	2318	2	gra_ting
grifting	13	29	926	2	grifting
hafting	14	40	1417	2	_hafting
orating	8	35	2032	2	ora_ting
prating	10	34	2445	2	pra_ting
ranting	8	40	2541	2	_ranting
rating	7	49	3870	2	_ra_ting
ratting	8	38	2236	2	_ratting
redrafting	15	4	596	2	redrafting
rifting	11	35	1500	2	_rifting
shafting	15	27	868	2	shafting
wafting	14	39	1166	2	_wafting

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	121059	0.393	454684.5
2	DLD Change Limit	121059	39	3.280	36908.2
3	Display Results	39	39	0.016	2437.5
	(SQL Overall)	178691	39	3.689	48438.9