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

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

55 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
crumping	15	31	990	(None)
chumping	18	34	906	1	chumping
clumping	15	31	988	1	clumping
cramping	15	34	1185	1	cramping
crimping	15	29	978	1	crimping
crumbing	15	26	781	1	crumbing
crumpling	16	4	532	1	crumpling
grumping	14	26	690	1	grumping
trumping	13	30	873	1	trumping
bumping	14	38	1249	2	_bumping
camping	14	31	1897	2	c_amping
champing	18	36	1093	2	champing
chomping	18	33	988	2	chomping
chumming	18	36	620	2	chumming
clamping	15	40	1115	2	clamping
clomping	15	32	965	2	clomping
comping	14	35	1859	2	c_omping
couping	12	43	1702	2	cou_ping
cramming	15	33	943	2	cramming
craping	12	40	1871	2	cr_aping
crapping	15	39	1145	2	crapping
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	1089	2	cropping
crudding	13	3	572	2	crudding
cruising	11	26	1015	2	cruising
crumbling	16	5	508	2	crumbling
crushing	14	30	1005	2	crushing
crusting	11	36	1279	2	crusting
cupping	14	43	1238	2	c_upping
drumming	14	26	578	2	drumming
dumping	13	37	1291	2	_dumping
flumping	16	28	758	2	flumping
humping	15	32	1307	2	_humping
jumping	19	31	980	2	_jumping
lumping	12	33	1464	2	_lumping
mumping	14	34	1163	2	_mumping
plumping	15	27	763	2	plumping
primping	15	33	889	2	primping
pumping	14	42	1355	2	_pumping
ramping	12	33	1687	2	_ramping
romping	12	31	1303	2	_romping
rumpling	13	17	876	2	_rumpling
scrimping	16	3	495	2	scrimping
scrumming	16	5	402	2	scrumming
slumping	13	35	997	2	slumping
stumping	13	28	908	2	stumping
thumping	16	29	671	2	thumping
tramping	13	27	1127	2	tramping
tromping	13	31	960	2	tromping
tumping	12	31	1424	2	_tumping
umping	11	48	1533	2	__umping
whumping	19	32	540	2	whumping

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.406	440125.6
2	DLD Change Limit	121059	55	3.513	34460.3
3	Display Results	55	55	0.016	3437.5
	(SQL Overall)	178691	55	3.935	45410.7