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

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

62 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
tromped	12	42	1029	(None)
romped	11	45	1365	1	_romped
tramped	12	43	1243	1	tramped
trompe	10	56	1126	1	trompe_
trompes	11	41	1162	1	trompes
trooped	10	40	1072	1	trooped
trouped	10	39	1098	1	trouped
trumped	12	43	971	1	trumped
chomped	17	32	977	2	chomped
clomped	14	39	897	2	clomped
comped	13	59	1987	2	_comped
cramped	14	47	1218	2	cramped
crimped	14	39	1076	2	crimped
cropped	14	38	1206	2	cropped
crumped	14	43	1122	2	crumped
drooped	11	36	843	2	drooped
dropped	13	32	928	2	dropped
groped	10	75	1505	2	gro_ped
grouped	11	41	919	2	grouped
grumped	13	33	733	2	grumped
primped	14	47	915	2	primped
promoed	12	3	1008	2	promoed
prompted	15	3	690	2	prompted
propped	11	33	1195	2	propped
ramped	11	46	1790	2	_ramped
romper	10	42	1368	2	_romper
roped	8	46	3080	2	_ro_ped
rouped	9	57	1735	2	_rouped
stomped	12	41	1053	2	stomped
stropped	13	6	734	2	stropped
tamped	11	43	1704	2	t_amped
temped	11	39	1289	2	t_emped
thumped	15	38	741	2	thumped
tombed	11	38	1213	2	t_ombed
tommed	11	33	1014	2	t_ommed
toped	8	56	3131	2	t_o_ped
topped	11	46	1772	2	t_opped
trammed	12	38	1071	2	trammed
tramper	11	38	1216	2	tramper
trampled	13	24	790	2	trampled
trapped	12	45	1221	2	trapped
trimmed	12	34	893	2	trimmed
tripped	12	39	1169	2	tripped
troaked	12	43	825	2	troaked
trocked	14	43	1224	2	trocked
troked	11	41	1458	2	tro_ked
trolled	8	43	1226	2	trolled
trommel	11	31	536	2	trommel
tromp	9	58	1580	2	tromp__
tromps	10	49	1170	2	tromp_s
trooper	9	42	1036	2	trooper
trope	7	57	2580	2	tro_pe_
tropes	8	48	2435	2	tro_pes
trothed	11	40	1097	2	trothed
trotted	8	37	1128	2	trotted
troupe	8	48	1243	2	troupe_
trouper	9	38	1143	2	trouper
troupes	9	41	1285	2	troupes
trowed	10	47	1465	2	tro_wed
trumpet	11	38	1072	2	trumpet
tumped	11	42	1623	2	t_umped
whomped	18	34	547	2	whomped

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.373	479064.3
2	DLD Change Limit	107671	62	3.003	35854.5
3	Display Results	62	62	0.013	4769.2
	(SQL Overall)	178691	62	3.389	52726.8