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

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

65 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
clamping	15	40	1115	(None)
camping	14	31	1897	1	c_amping
champing	18	36	1093	1	champing
clamming	15	32	937	1	clamming
clapping	15	38	1060	1	clapping
clasping	13	33	1026	1	clasping
clomping	15	32	965	1	clomping
clumping	15	31	988	1	clumping
cramping	15	34	1185	1	cramping
lamping	12	31	1600	1	_lamping
amping	11	43	1757	2	__amping
blaming	12	35	1569	2	blam_ing
calming	12	39	1597	2	calm_ing
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
clacking	17	33	1349	2	clacking
cladding	13	3	714	2	cladding
clagging	13	32	887	2	clagging
claiming	13	27	930	2	claiming
clamoring	14	7	742	2	clamoring
clanging	12	40	1212	2	clanging
clanking	15	43	1306	2	clanking
clashing	14	38	1219	2	clashing
classing	11	32	1179	2	classing
clawing	13	38	1267	2	cla_wing
claying	13	36	1430	2	cla_ying
cleping	12	33	1042	2	cl_eping
climbing	15	20	598	2	climbing
clipping	15	34	915	2	clipping
clopping	15	35	1108	2	clopping
coaming	12	38	1832	2	coam_ing
comping	14	35	1859	2	c_omping
cramming	15	33	943	2	cramming
craping	12	40	1871	2	cra_ping
crapping	15	39	1145	2	crapping
crimping	15	29	978	2	crimping
crumping	15	31	990	2	crumping
damping	13	34	1400	2	_damping
flaming	13	42	1644	2	flam_ing
flamming	16	35	715	2	flamming
flapping	16	29	815	2	flapping
flumping	16	28	758	2	flumping
lambing	12	34	1241	2	_lambing
laming	9	45	2836	2	_lam_ing
lamming	12	30	1458	2	_lamming
lapping	12	41	1702	2	_lapping
limping	12	46	1411	2	_limping
lumping	12	33	1464	2	_lumping
plumping	15	27	763	2	plumping
ramping	12	33	1687	2	_ramping
scamping	15	35	1019	2	scamping
slamming	13	33	1000	2	slamming
slapping	13	35	1083	2	slapping
slumping	13	35	997	2	slumping
stamping	13	33	1096	2	stamping
swamping	16	30	792	2	swamping
tamping	12	28	1581	2	_tamping
tramping	13	27	1127	2	tramping
unclamping	17	4	343	2	unclamping
vamping	15	28	1023	2	_vamping

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	65	3.533	34265.2
3	Display Results	65	65	0.013	5000.0
	(SQL Overall)	178691	65	3.952	45215.3