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

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

77 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
tramped	12	43	1243	(None)
cramped	14	47	1218	1	cramped
ramped	11	46	1790	1	_ramped
tamped	11	43	1704	1	t_amped
trammed	12	38	1071	1	trammed
tramper	11	38	1216	1	tramper
trampled	13	24	790	1	trampled
trapped	12	45	1221	1	trapped
tromped	12	42	1029	1	tromped
trumped	12	43	971	1	trumped
amped	10	48	2051	2	__amped
camped	13	47	2023	2	_camped
champed	17	41	1148	2	champed
clamped	14	40	1204	2	clamped
crammed	14	37	1012	2	crammed
craped	11	61	2053	2	cra_ped
crapped	14	39	1263	2	crapped
crimped	14	39	1076	2	crimped
crumped	14	43	1122	2	crumped
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
stamped	12	48	1281	2	stamped
strapped	13	5	782	2	strapped
swamped	15	49	844	2	swamped
tamed	8	55	2851	2	t_am_ed
tamper	10	46	1851	2	t_amper
taped	8	53	2742	2	t_a_ped
tapped	11	38	2005	2	t_apped
teamed	9	54	1859	2	team_ed
temped	11	39	1289	2	t_emped
thumped	15	38	741	2	thumped
traced	9	48	2158	2	tra_ced
tracked	14	37	1613	2	tracked
traded	8	57	1768	2	tra_ded
traiked	12	33	1045	2	traiked
trailed	8	34	1567	2	trailed
trained	8	41	1720	2	trained
traipsed	11	3	475	2	traipsed
tramel	8	41	1371	2	tram_el
trameled	11	30	907	2	trameled
trammel	11	35	766	2	trammel
tramp	9	63	1977	2	tramp__
trampers	12	32	1039	2	trampers
trampier	12	31	824	2	trampier
trample	11	29	970	2	trample
trampler	12	27	801	2	trampler
tramples	12	26	1020	2	tramples
tramps	10	51	1445	2	tramp_s
trampy	13	49	925	2	tramp_y
tranced	10	44	1417	2	tranced
trapes	8	50	2446	2	tra_pes
trapper	11	39	1280	2	trapper
trashed	11	35	1470	2	trashed
trawled	11	34	1152	2	trawled
trimmed	12	34	893	2	trimmed
tripped	12	39	1169	2	tripped
trompe	10	56	1126	2	trompe_
trompes	11	41	1162	2	trompes
trooped	10	40	1072	2	trooped
trouped	10	39	1098	2	trouped
trumpet	11	38	1072	2	trumpet
tumped	11	42	1623	2	t_umped
vamped	14	42	1101	2	_vamped
wrapped	15	33	802	2	wrapped

Search took 6 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.373	479064.3
2	DLD Change Limit	107671	77	5.440	19792.5
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	5.843	30582.1