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

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

74 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
champing	18	36	1093	(None)
camping	14	31	1897	1	c_amping
chapping	18	37	1072	1	chapping
chomping	18	33	988	1	chomping
chumping	18	34	906	1	chumping
clamping	15	40	1115	1	clamping
cramping	15	34	1185	1	cramping
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
chaffing	20	3	632	2	chaffing
chafing	16	39	1149	2	cha_fing
chaining	14	28	1078	2	chaining
chairing	14	31	1077	2	chairing
chalking	18	33	1006	2	chalking
chammying	22	4	335	2	chammying
champaign	19	4	247	2	champaign
champion	17	27	635	2	champion
champions	18	87	578	2	champions
chancing	16	28	1028	2	chancing
changing	15	32	1151	2	changing
chanting	14	34	1353	2	chanting
charging	15	29	1077	2	charging
charing	13	37	2132	2	cha_ring
charking	18	35	1261	2	charking
charming	16	30	1203	2	charming
charring	14	29	1316	2	charring
charting	14	26	1419	2	charting
chasing	13	37	1589	2	cha_sing
chatting	14	28	1014	2	chatting
chawing	16	48	1303	2	cha_wing
cheeping	16	32	955	2	cheeping
chiming	15	33	1183	2	chim_ing
chipping	18	38	979	2	chipping
chirping	16	27	886	2	chirping
chopping	18	37	1026	2	chopping
chumming	18	36	620	2	chumming
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
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
hamming	15	30	1409	2	_hamming
happing	15	38	1723	2	_happing
harping	13	41	1838	2	_harping
hasping	13	44	1490	2	_hasping
humping	15	32	1307	2	_humping
lamping	12	31	1600	2	_lamping
ramping	12	33	1687	2	_ramping
scamping	15	35	1019	2	scamping
shaming	13	30	1674	2	sham_ing
shamming	16	28	941	2	shamming
shaping	13	31	1618	2	sha_ping
sharping	14	30	1137	2	sharping
stamping	13	33	1096	2	stamping
swamping	16	30	792	2	swamping
tamping	12	28	1581	2	_tamping
thumping	16	29	671	2	thumping
tramping	13	27	1127	2	tramping
vamping	15	28	1023	2	_vamping
whamming	19	27	522	2	whamming
whapping	19	31	711	2	whapping
whomping	19	28	594	2	whomping
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	74	3.203	37795.5
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	3.639	49104.4