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

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

51 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
drawling	13	31	867	(None)
brawling	14	32	1004	1	brawling
crawling	14	31	1051	1	crawling
drawing	12	38	1205	1	draw_ing
trawling	12	27	1078	1	trawling
bawling	13	38	1386	2	_bawling
brailing	11	35	1479	2	brailing
craaling	11	27	1135	2	craaling
cradling	12	24	1145	2	cradling
darkling	14	3	748	2	darkling
darling	9	34	1836	2	d_arling
dartling	10	3	956	2	dartling
dawdling	14	23	637	2	d_awdling
dawing	11	48	1982	2	d_aw_ing
dawning	12	41	1101	2	d_awning
dawting	12	36	1067	2	d_awting
dealing	9	43	2323	2	dea_ling
derailing	11	20	1131	2	derailing
dialing	9	43	1817	2	dia_ling
dialling	10	3	1078	2	dialling
drabbing	14	28	680	2	drabbing
drabbling	15	4	455	2	drabbling
drafting	13	33	940	2	drafting
dragging	12	30	810	2	dragging
draggling	13	5	461	2	draggling
dragline	10	3	684	2	dragline
draining	10	33	1267	2	draining
dramming	14	34	756	2	dramming
draping	11	42	1335	2	dra_ping
dratting	10	38	965	2	dratting
drawings	13	38	628	2	draw_ings
drawlier	12	22	525	2	drawlier
drawlingly	18	4	329	2	drawlingly
draying	12	38	1384	2	dra_ying
drilling	10	33	1198	2	drilling
drolling	10	35	1076	2	drolling
drooling	10	26	1042	2	drooling
drowning	13	29	836	2	drowning
drowsing	13	28	777	2	drowsing
grayling	13	3	800	2	grayling
growling	13	4	816	2	growling
kraaling	13	18	666	2	kraaling
prawning	14	4	696	2	prawning
prowling	14	4	999	2	prowling
railing	8	33	2564	2	_railing
scrawling	15	19	558	2	scrawling
shawling	15	5	822	2	shawling
sprawling	15	17	512	2	sprawling
trailing	9	29	1609	2	trailing
wawling	14	38	1096	2	_wawling
yawling	14	36	918	2	_yawling

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	121059	0.390	458182.1
2	DLD Change Limit	121059	51	3.670	32986.1
3	Display Results	51	51	0.033	1545.5
	(SQL Overall)	178691	51	4.093	43657.7