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

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

63 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
crimping	15	29	978	(None)
cramping	15	34	1185	1	cramping
crimpling	16	4	534	1	crimpling
crisping	13	31	966	1	crisping
crumping	15	31	990	1	crumping
primping	15	33	889	1	primping
scrimping	16	3	495	1	scrimping
brimming	15	19	662	2	brimming
camping	14	31	1897	2	c_amping
champing	18	36	1093	2	champing
chiming	15	33	1183	2	chim_ing
chipping	18	38	979	2	chipping
chirping	16	27	886	2	chirping
chomping	18	33	988	2	chomping
chumping	18	34	906	2	chumping
clamping	15	40	1115	2	clamping
climbing	15	20	598	2	climbing
clipping	15	34	915	2	clipping
clomping	15	32	965	2	clomping
clumping	15	31	988	2	clumping
comping	14	35	1859	2	c_omping
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
cribbing	15	27	684	2	cribbing
cricking	17	34	1265	2	cricking
crimine	11	24	1347	2	crim_ine
crimini	11	25	888	2	crim_ini
criminy	14	26	845	2	crim_iny
crimpier	14	28	732	2	crimpier
cringing	12	33	1138	2	cringing
crippling	16	4	409	2	crippling
cropping	15	32	1088	2	cropping
crumbing	15	26	781	2	crumbing
crumpling	16	4	532	2	crumpling
dripping	14	27	803	2	dripping
gimping	13	37	1076	2	_gimping
griming	11	36	1249	2	grim_ing
griping	11	30	1206	2	gri_ping
gripping	14	27	754	2	gripping
grumping	14	26	690	2	grumping
imping	11	43	1535	2	__imping
limping	12	46	1411	2	_limping
pimping	14	38	1212	2	_pimping
priming	12	34	1737	2	prim_ing
primming	15	26	817	2	primming
ramping	12	33	1687	2	_ramping
riming	9	33	2222	2	_rim_ing
rimming	12	34	1107	2	_rimming
rimpling	13	21	966	2	_rimpling
riping	9	38	2161	2	_ri_ping
ripping	12	33	1574	2	_ripping
romping	12	31	1303	2	_romping
shrimping	17	3	406	2	shrimping
skimping	17	30	624	2	skimping
tramping	13	27	1127	2	tramping
trimming	13	31	865	2	trimming
tripping	13	32	1092	2	tripping
tromping	13	31	960	2	tromping
trumping	13	30	873	2	trumping
wimping	15	39	1101	2	_wimping

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.390	458182.1
2	DLD Change Limit	121059	63	3.360	36029.5
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	3.780	47272.8