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

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

114 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
draping	11	42	1335	(None)
craping	12	40	1871	1	craping
drawing	12	38	1205	1	drawing
draying	12	38	1384	1	draying
raping	9	48	2985	1	_raping
aping	8	73	2723	2	__aping
bedraping	15	3	538	2	bedraping
bracing	12	38	1761	2	bracing
braking	14	39	1771	2	braking
braving	13	37	1461	2	braving
braying	13	44	1631	2	braying
brazing	19	37	1511	2	brazing
carping	12	35	2108	2	carping
cramping	15	34	1185	2	cramping
craning	10	36	2030	2	craning
crapping	15	39	1145	2	crapping
crating	10	37	2520	2	crating
craving	13	40	1573	2	craving
crazing	19	39	1458	2	crazing
creping	12	29	1365	2	creping
damping	13	34	1400	2	damping
dapping	13	37	1479	2	dapping
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
derating	10	32	2228	2	derating
dialing	9	43	1817	2	dialing
dipping	13	40	1483	2	dipping
doating	9	38	1686	2	doating
doping	10	39	1946	2	d_oping
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
dripping	14	27	803	2	dripping
driving	12	39	1071	2	driving
droning	9	30	1372	2	droning
drooping	12	26	880	2	drooping
dropping	14	30	928	2	dropping
droving	12	37	968	2	droving
drying	11	34	1160	2	dr_ying
dumping	13	37	1291	2	dumping
duping	10	41	1363	2	d_uping
dupping	13	37	1104	2	dupping
erasing	8	3	1796	2	erasing
framing	13	30	1479	2	framing
frapping	16	34	810	2	frapping
fraying	14	34	1343	2	fraying
gaping	10	56	1892	2	_gaping
gracing	11	32	1644	2	gracing
grading	10	39	1871	2	grading
graphing	15	3	853	2	graphing
grasping	12	34	883	2	grasping
grating	9	39	2318	2	grating
graving	12	31	1456	2	graving
graying	12	41	1588	2	graying
grazing	18	35	1455	2	grazing
griping	11	30	1206	2	griping
groping	11	33	1310	2	groping
harping	13	41	1838	2	harping
heaping	13	30	1585	2	heaping
japing	16	50	1357	2	_japing
leaping	10	32	1599	2	leaping
orating	8	35	2032	2	orating
prating	10	34	2445	2	prating
praying	13	37	1732	2	praying
racing	9	50	3053	2	_racing
raging	8	51	2643	2	_raging
raking	11	47	2842	2	_raking
ramping	12	33	1687	2	_ramping
rapine	8	50	2308	2	_rapine
rapini	8	47	1468	2	_rapini
rapping	12	36	1910	2	_rapping
raring	7	43	3287	2	_raring
rasing	7	43	3083	2	_rasing
rasping	10	43	1625	2	_rasping
rating	7	49	3870	2	_rating
raving	10	51	2885	2	_raving
raxing	14	43	2102	2	_raxing
raying	10	50	2719	2	_raying
razing	16	45	2454	2	_razing
reaping	10	36	2121	2	reaping
riping	9	38	2161	2	_riping
roping	9	40	2302	2	_roping
scaping	12	37	1569	2	scaping
scraping	13	33	1086	2	scraping
shaping	13	31	1618	2	shaping
soaping	10	36	1622	2	soaping
taping	9	42	2239	2	_taping
tracing	10	37	2015	2	tracing
trading	9	35	1797	2	trading
tramping	13	27	1127	2	tramping
trapping	13	29	1139	2	trapping
undraping	13	3	733	2	undraping
urping	9	39	1405	2	ur_ping
warping	13	37	1518	2	warping
wrapping	16	29	762	2	wrapping

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.393	454684.5
2	DLD Change Limit	107671	114	2.890	37256.4
3	Display Results	114	114	0.046	2478.3
	(SQL Overall)	178691	114	3.329	53677.1