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

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

56 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
cramming	15	33	943	(None)
clamming	15	32	937	1	clamming
cramping	15	34	1185	1	cramping
dramming	14	34	757	1	dramming
ramming	12	31	1506	1	_ramming
scramming	16	3	488	1	scramming
tramming	13	27	934	1	tramming
bamming	14	46	1181	2	_bamming
brimming	15	19	662	2	brimming
calming	12	39	1597	2	c_alming
camping	14	31	1897	2	c_amping
caroming	13	33	1296	2	caroming
chammying	22	4	335	2	chammying
champing	18	36	1093	2	champing
charming	16	30	1203	2	charming
chumming	18	36	620	2	chumming
claiming	13	27	930	2	claiming
clamping	15	40	1115	2	clamping
coaming	12	38	1832	2	coa_ming
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
craning	10	36	2030	2	cra_ning
cranking	15	46	1307	2	cranking
craping	12	40	1871	2	cra_ping
crapping	15	39	1145	2	crapping
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	creaming
crimping	15	29	978	2	crimping
crumbing	15	26	781	2	crumbing
crumping	15	31	990	2	crumping
damming	13	38	1274	2	_damming
drumming	14	26	578	2	drumming
flamming	16	35	715	2	flamming
framing	13	30	1479	2	fra_ming
gamming	13	31	1262	2	_gamming
hamming	15	30	1409	2	_hamming
jamming	19	32	979	2	_jamming
lamming	12	30	1458	2	_lamming
primming	15	26	817	2	primming
ramping	12	33	1687	2	_ramping
rimming	12	34	1107	2	_rimming
scamming	15	32	854	2	scamming
scrumming	16	5	402	2	scrumming
shamming	16	28	941	2	shamming
slamming	13	33	1000	2	slamming
spamming	15	31	760	2	spamming
tramping	13	27	1127	2	tramping
trimming	13	31	865	2	trimming
whamming	19	27	522	2	whamming

Search took 7 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.780	229091.0
2	DLD Change Limit	121059	56	6.096	19858.8
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	6.906	25874.7