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

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

80 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
cramping	15	34	1185	(None)
camping	14	31	1897	1	c_amping
champing	18	36	1093	1	champing
clamping	15	40	1115	1	clamping
cramming	15	33	943	1	cramming
craping	12	40	1871	1	cra_ping
crapping	15	39	1145	1	crapping
crimping	15	29	978	1	crimping
crumping	15	31	990	1	crumping
ramping	12	33	1687	1	_ramping
tramping	13	27	1127	1	tramping
amping	11	43	1757	2	__amping
campings	15	40	1020	2	c_ampings
campong	14	31	812	2	c_ampong
capping	14	38	1967	2	c_apping
carping	12	35	2108	2	c_arping
chapping	18	37	1072	2	chapping
chomping	18	33	988	2	chomping
chumping	18	34	906	2	chumping
clamming	15	32	937	2	clamming
clapping	15	38	1060	2	clapping
clasping	13	33	1026	2	clasping
clomping	15	32	965	2	clomping
clumping	15	31	988	2	clumping
coaming	12	38	1832	2	coam_ing
comping	14	35	1859	2	c_omping
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
crampier	14	28	890	2	crampier
crampit	13	3	886	2	crampi_t
crampits	14	3	627	2	crampits
crampon	13	3	694	2	crampon_
crampons	14	3	664	2	crampons
craning	10	36	2030	2	cra_ning
cranking	15	46	1307	2	cranking
crashing	14	35	1263	2	crashing
crating	10	37	2520	2	cra_ting
craving	13	40	1573	2	cra_ving
crawling	14	31	1051	2	crawling
crazing	19	39	1458	2	cra_zing
creaming	13	34	1314	2	cream_ing
creeping	13	33	1010	2	creeping
creping	12	29	1365	2	cr_eping
crimpling	16	4	534	2	crimpling
crisping	13	31	966	2	crisping
cropping	15	32	1088	2	cropping
crumbing	15	26	781	2	crumbing
crumpling	16	4	532	2	crumpling
damping	13	34	1400	2	_damping
dramming	14	34	756	2	dramming
draping	11	42	1335	2	dra_ping
framing	13	30	1479	2	fram_ing
frapping	16	34	810	2	frapping
grasping	12	34	883	2	grasping
grumping	14	26	690	2	grumping
lamping	12	31	1600	2	_lamping
primping	15	33	889	2	primping
ramming	12	31	1506	2	_ramming
raping	9	48	2985	2	_ra_ping
rapping	12	36	1910	2	_rapping
rasping	10	43	1625	2	_rasping
romping	12	31	1303	2	_romping
scamping	15	35	1019	2	scamping
scramming	16	3	488	2	scramming
scraping	13	33	1086	2	scra_ping
scrapping	16	3	574	2	scrapping
scrimping	16	3	495	2	scrimping
stamping	13	33	1096	2	stamping
swamping	16	30	792	2	swamping
tamping	12	28	1581	2	_tamping
tramming	13	27	934	2	tramming
trampling	14	3	697	2	trampling
trapping	13	29	1139	2	trapping
tromping	13	31	960	2	tromping
trumping	13	30	873	2	trumping
vamping	15	28	1023	2	_vamping
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	121059	0.393	454684.5
2	DLD Change Limit	121059	80	3.406	35542.9
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.829	46667.8