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

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

137 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
craping	12	40	1871	(None)
carping	12	35	2108	1	carping
cramping	15	34	1185	1	cramping
craning	10	36	2030	1	craning
crapping	15	39	1145	1	crapping
crating	10	37	2520	1	crating
craving	13	40	1573	1	craving
crazing	19	39	1458	1	crazing
creping	12	29	1365	1	creping
draping	11	42	1335	1	draping
raping	9	48	2985	1	_raping
scraping	13	33	1086	1	scraping
aping	8	73	2723	2	__aping
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
caging	10	53	2102	2	c_aging
caking	13	46	2467	2	c_aking
camping	14	31	1897	2	camping
caning	9	41	2862	2	c_aning
capping	14	38	1967	2	capping
carding	11	39	2243	2	carding
caring	9	51	3799	2	c_aring
carking	14	43	2285	2	carking
carling	10	37	2706	2	carling
carpings	13	38	1238	2	carpings
carting	10	42	2828	2	carting
carving	13	39	1677	2	carving
casing	9	48	2910	2	c_asing
caving	12	48	2261	2	c_aving
cawing	12	43	2261	2	c_awing
ceasing	10	41	1826	2	ceasing
chafing	16	39	1149	2	chafing
champing	18	36	1093	2	champing
chapping	18	37	1072	2	chapping
charing	13	37	2132	2	charing
chasing	13	37	1589	2	chasing
chawing	16	48	1303	2	chawing
clamping	15	40	1115	2	clamping
clapping	15	38	1060	2	clapping
clasping	13	33	1026	2	clasping
clawing	13	38	1267	2	clawing
claying	13	36	1430	2	claying
cleping	12	33	1042	2	cleping
coaling	10	37	2282	2	coaling
coaming	12	38	1832	2	coaming
coapting	13	35	1161	2	coapting
coating	10	35	2531	2	coating
coaxing	17	35	1170	2	coaxing
comping	14	35	1859	2	comping
cooping	12	39	1893	2	cooping
coping	11	39	2766	2	c_oping
copping	14	39	1859	2	copping
couping	12	43	1702	2	couping
craaling	11	27	1135	2	craaling
crabbing	15	28	793	2	crabbing
cracking	17	40	1390	2	cracking
cradling	12	24	1145	2	cradling
crafting	14	37	1017	2	crafting
cramming	15	33	943	2	cramming
cranking	15	46	1307	2	cranking
crashing	14	35	1263	2	crashing
cravings	14	42	822	2	cravings
crawling	14	31	1051	2	crawling
creaking	15	34	1412	2	creaking
creaming	13	34	1314	2	creaming
creasing	11	33	1444	2	creasing
creating	11	39	2195	2	creating
creeping	13	33	1010	2	creeping
crewing	13	32	1263	2	crewing
crimping	15	29	978	2	crimping
crisping	13	31	966	2	crisping
croaking	15	37	1216	2	croaking
cropping	15	32	1088	2	cropping
crowing	13	38	1476	2	crowing
crumping	15	31	990	2	crumping
crying	12	36	1228	2	cr_ying
cupping	14	43	1238	2	cupping
curating	11	3	1429	2	curating
drawing	12	38	1205	2	drawing
draying	12	38	1384	2	draying
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
scarping	13	33	1246	2	scarping
scrapings	14	25	517	2	scrapings
scrapping	16	3	574	2	scrapping
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
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	137	3.343	32207.9
3	Display Results	137	137	0.046	2978.3
	(SQL Overall)	178691	137	3.782	47247.8