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

Here are the results of your fuzzy-string dictionary search for “drawing” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

111 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
drawing	12	38	1205	(None)
dawing	11	48	1982	1	d_awing
draping	11	42	1335	1	draping
drawings	13	38	628	1	drawings
drawling	13	31	867	1	drawling
draying	12	38	1384	1	draying
awing	9	68	2732	2	__awing
blawing	13	40	1275	2	blawing
bracing	12	38	1761	2	bracing
braking	14	39	1771	2	braking
braving	13	37	1461	2	braving
brawling	14	32	1004	2	brawling
braying	13	44	1631	2	braying
brazing	19	37	1511	2	brazing
brewing	13	34	1115	2	brewing
cawing	12	43	2261	2	_cawing
chawing	16	48	1303	2	chawing
clawing	13	38	1267	2	clawing
craning	10	36	2030	2	craning
craping	12	40	1871	2	craping
crating	10	37	2520	2	crating
craving	13	40	1573	2	craving
crawling	14	31	1051	2	crawling
crazing	19	39	1458	2	crazing
crewing	13	32	1263	2	crewing
crowing	13	38	1476	2	crowing
daring	8	49	2868	2	d_aring
darking	13	42	1734	2	darking
darling	9	34	1836	2	darling
darning	9	38	1733	2	darning
darting	9	40	2066	2	darting
dating	8	53	2648	2	d_ating
dawning	12	41	1101	2	d_awning
dawting	12	36	1067	2	d_awting
dazing	17	55	1651	2	d_azing
dealing	9	43	2323	2	dealing
deaning	9	40	2047	2	deaning
deaving	12	38	1475	2	deaving
derating	10	32	2228	2	derating
dewing	11	41	1570	2	d_ewing
dialing	9	43	1817	2	dialing
doating	9	38	1686	2	doating
dowing	11	42	2151	2	d_owing
drabbing	14	28	680	2	drabbing
drafting	13	33	940	2	drafting
dragging	12	30	810	2	dragging
drain	6	52	2289	2	dra_in_
draining	10	33	1267	2	draining
drains	7	37	1940	2	dra_ins
dramming	14	34	756	2	dramming
dratting	10	38	965	2	dratting
drawn	9	56	1424	2	draw_n_
dreading	11	37	1280	2	dreading
dreaming	12	40	1106	2	dreaming
dreeing	9	43	1118	2	dreeing
driving	12	39	1071	2	driving
droning	9	30	1372	2	droning
droving	12	37	968	2	droving
drowning	13	29	836	2	drowning
drowsing	13	28	777	2	drowsing
drying	11	34	1160	2	dr_ying
erasing	8	3	1796	2	erasing
flawing	14	38	1256	2	flawing
framing	13	30	1479	2	framing
fraying	14	34	1343	2	fraying
gnawing	12	37	790	2	gnawing
gracing	11	32	1644	2	gracing
grading	10	39	1871	2	grading
grating	9	39	2318	2	grating
graving	12	31	1456	2	graving
graying	12	41	1588	2	graying
grazing	18	35	1455	2	grazing
growing	12	35	1247	2	growing
hawing	13	43	2235	2	_hawing
jawing	17	44	1496	2	_jawing
lawing	10	46	2528	2	_lawing
mawing	12	40	2080	2	_mawing
orating	8	35	2032	2	orating
parawing	14	3	1058	2	parawing
pawing	12	45	1955	2	_pawing
prating	10	34	2445	2	prating
prawning	14	4	696	2	prawning
praying	13	37	1732	2	praying
racing	9	50	3053	2	_racing
raging	8	51	2643	2	_raging
raking	11	47	2842	2	_raking
raping	9	48	2985	2	_raping
raring	7	43	3287	2	_raring
rasing	7	43	3083	2	_rasing
rating	7	49	3870	2	_rating
raving	10	51	2885	2	_raving
rawin	8	55	2147	2	_rawin_
rawins	9	56	1762	2	_rawins
raxing	14	43	2102	2	_raxing
raying	10	50	2719	2	_raying
razing	16	45	2454	2	_razing
redrawing	14	3	721	2	redrawing
rowing	10	36	2330	2	_rowing
sawing	10	43	2381	2	_sawing
shawing	14	35	1488	2	shawing
snawing	11	36	1248	2	snawing
strawing	12	24	1162	2	strawing
tawing	10	45	2155	2	_tawing
thawing	14	37	868	2	thawing
thrawing	15	3	596	2	thrawing
tracing	10	37	2015	2	tracing
trading	9	35	1797	2	trading
trawling	12	27	1078	2	trawling
trowing	11	34	1370	2	trowing
undrawing	14	3	690	2	undrawing
yawing	13	42	1561	2	_yawing

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	107671	0.393	454684.5
2	DLD Change Limit	107671	111	3.593	29966.9
3	Display Results	111	111	0.046	2413.0
	(SQL Overall)	178691	111	4.032	44318.2