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

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

92 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
cramped	14	47	1218	(None)
camped	13	47	2023	1	c_amped
champed	17	41	1148	1	champed
clamped	14	40	1204	1	clamped
crammed	14	37	1012	1	crammed
craped	11	61	2052	1	cra_ped
crapped	14	39	1262	1	crapped
crimped	14	39	1076	1	crimped
crumped	14	43	1122	1	crumped
ramped	11	46	1790	1	_ramped
tramped	12	43	1243	1	tramped
amped	10	48	2051	2	__amped
camper	12	47	2221	2	c_amper
caped	10	49	3180	2	c_a_ped
capped	13	47	2185	2	c_apped
carped	11	59	2376	2	c_arped
champer	16	38	1341	2	champer
chapped	17	27	1144	2	chapped
chomped	17	32	977	2	chomped
chumped	17	37	949	2	chumped
clammed	14	36	996	2	clammed
clamper	13	40	1299	2	clamper
clapped	14	35	1117	2	clapped
clasped	12	36	1044	2	clasped
clomped	14	39	897	2	clomped
clumped	14	36	1066	2	clumped
comped	13	59	1987	2	c_omped
craaled	10	33	942	2	craaled
crabbed	14	38	887	2	crabbed
cracked	16	35	1474	2	cracked
cradled	11	34	1081	2	cradled
crafted	13	41	977	2	crafted
cragged	12	47	988	2	cragged
crambe	12	3	907	2	crambe_
crambes	13	3	996	2	crambes
crammer	13	40	1096	2	crammer
cramp	11	51	2069	2	cramp__
crampier	14	28	890	2	crampier
crampit	13	3	886	2	crampit
crampon	13	3	694	2	crampon
cramps	12	56	1556	2	cramp_s
crampy	15	47	1099	2	cramp_y
craned	9	61	2165	2	cra_ned
cranked	14	38	1284	2	cranked
crape	9	61	2844	2	cra_pe_
crapes	10	47	2769	2	cra_pes
crapper	13	39	1319	2	crapper
crashed	13	42	1420	2	crashed
crated	9	48	2777	2	cra_ted
craved	12	54	1777	2	cra_ved
crawled	13	37	1039	2	crawled
crazed	18	47	1445	2	cra_zed
creamed	12	39	1371	2	cream_ed
creeped	12	32	971	2	creeped
creped	11	41	1570	2	cr_eped
crimper	13	65	1042	2	crimper
crimpled	15	36	693	2	crimpled
crisped	12	40	1010	2	crisped
cropped	14	38	1206	2	cropped
crumbed	14	37	847	2	crumbed
crumpet	13	37	1106	2	crumpet
crumpled	15	29	687	2	crumpled
damped	12	43	1558	2	_damped
drammed	13	37	807	2	drammed
draped	10	53	1436	2	dra_ped
framed	12	51	1652	2	fram_ed
frapped	15	31	885	2	frapped
grasped	11	40	906	2	grasped
grumped	13	33	733	2	grumped
lamped	11	40	1754	2	_lamped
primped	14	47	915	2	primped
rammed	11	31	1730	2	_rammed
raped	8	53	3462	2	_ra_ped
rapped	11	41	2268	2	_rapped
rasped	9	47	1520	2	_rasped
romped	11	45	1365	2	_romped
scamped	14	47	1196	2	scamped
scrammed	15	5	500	2	scrammed
scraped	12	43	1313	2	scra_ped
scrapped	15	5	653	2	scrapped
scrimped	15	5	531	2	scrimped
stamped	12	48	1281	2	stamped
swamped	15	49	844	2	swamped
tamped	11	43	1704	2	_tamped
trammed	12	38	1071	2	trammed
tramper	11	38	1216	2	tramper
trampled	13	24	790	2	trampled
trapped	12	45	1221	2	trapped
tromped	12	42	1029	2	tromped
trumped	12	43	971	2	trumped
vamped	14	42	1101	2	_vamped
wrapped	15	33	802	2	wrapped

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	107671	0.140	1276364.3
2	DLD Change Limit	107671	92	3.076	35003.6
3	Display Results	92	92	0.033	2787.9
	(SQL Overall)	178691	92	3.249	54998.8