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

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

105 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
draying	12	38	1384	(None)
braying	13	44	1631	1	braying
draping	11	42	1335	1	draping
drawing	12	38	1205	1	drawing
drying	11	34	1160	1	dr_ying
fraying	14	34	1343	1	fraying
graying	12	41	1588	1	graying
praying	13	37	1732	1	praying
raying	10	50	2719	1	_raying
arraying	12	3	875	2	arraying
baying	12	52	2258	2	_baying
bracing	12	38	1761	2	bracing
braking	14	39	1771	2	braking
braving	13	37	1461	2	braving
brazing	19	37	1511	2	brazing
claying	13	36	1430	2	claying
craning	10	36	2030	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
crying	12	36	1228	2	cr_ying
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
dawing	11	48	1982	2	d_awing
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
decaying	15	23	945	2	decaying
defraying	17	3	585	2	defraying
defying	15	32	882	2	defying
delaying	13	32	1097	2	delaying
denying	12	37	1129	2	denying
derating	10	32	2228	2	derating
dialing	9	43	1817	2	dialing
dirtying	13	3	609	2	dirtying
doating	9	38	1686	2	doating
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
drawings	13	38	628	2	drawings
drawling	13	31	867	2	drawling
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
dying	10	53	1603	2	d__ying
erasing	8	3	1796	2	erasing
faying	13	45	2107	2	_faying
flaying	14	39	1446	2	flaying
foraying	15	3	743	2	foraying
framing	13	30	1479	2	framing
frayings	15	32	599	2	frayings
frying	13	45	1140	2	fr_ying
gracing	11	32	1644	2	gracing
grading	10	39	1871	2	grading
grating	9	39	2318	2	grating
graving	12	31	1456	2	graving
grayling	13	3	800	2	grayling
grazing	18	35	1455	2	grazing
greying	12	41	1089	2	greying
haying	13	44	2061	2	_haying
laying	10	45	2570	2	_laying
maying	12	44	2115	2	_maying
okaying	15	3	483	2	okaying
orating	8	35	2032	2	orating
paying	12	37	2216	2	_paying
playing	13	38	1609	2	playing
prating	10	34	2445	2	prating
preying	13	31	1455	2	preying
prying	12	41	1480	2	pr_ying
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
raxing	14	43	2102	2	_raxing
razing	16	45	2454	2	_razing
saying	10	43	2554	2	_saying
slaying	11	33	1684	2	slaying
spaying	13	30	1462	2	spaying
spraying	14	29	988	2	spraying
staying	11	40	1732	2	staying
straying	12	29	1269	2	straying
swaying	14	36	1064	2	swaying
tracing	10	37	2015	2	tracing
trading	9	35	1797	2	trading
trying	10	42	1407	2	tr_ying
varying	14	2	972	2	varying
wrying	13	37	962	2	wr_ying

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.123	1452772.4
2	DLD Change Limit	107671	105	4.110	26197.3
3	Display Results	105	105	0.186	564.5
	(SQL Overall)	178691	105	4.419	40437.0