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

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

51 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
tromping	13	31	959	(None)
romping	12	31	1303	1	_romping
tramping	13	27	1127	1	tramping
trooping	11	27	1027	1	trooping
trouping	11	24	950	1	trouping
trumping	13	30	873	1	trumping
chomping	18	33	988	2	chomping
clomping	15	32	965	2	clomping
comping	14	35	1859	2	_comping
cramping	15	34	1185	2	cramping
crimping	15	29	978	2	crimping
cropping	15	32	1088	2	cropping
crumping	15	31	990	2	crumping
drooping	12	26	880	2	drooping
dropping	14	30	928	2	dropping
groping	11	33	1310	2	gro_ping
grouping	12	30	853	2	grouping
grumping	14	26	690	2	grumping
primping	15	33	889	2	primping
promoing	13	3	1046	2	promoing
prompting	16	3	719	2	prompting
propping	12	28	1167	2	propping
ramping	12	33	1687	2	_ramping
roping	9	40	2302	2	_ro_ping
rouping	10	37	1579	2	_rouping
stomping	13	30	976	2	stomping
stropping	14	3	693	2	stropping
tamping	12	28	1581	2	t_amping
temping	12	27	1069	2	t_emping
thumping	16	29	671	2	thumping
tombing	12	33	1053	2	t_ombing
tomming	12	35	924	2	t_omming
toping	9	41	2299	2	t_o_ping
topping	12	35	1462	2	t_opping
tramming	13	27	934	2	tramming
trampling	14	3	696	2	trampling
trapping	13	29	1139	2	trapping
trimming	13	31	865	2	trimming
tripping	13	32	1092	2	tripping
troaking	13	33	1097	2	troaking
trocking	15	36	1242	2	trocking
troking	12	35	1410	2	tro_king
trolling	9	32	1249	2	trolling
tropin	8	33	1675	2	tro_pin_
tropine	9	31	1665	2	tro_pine
tropins	9	31	1630	2	tro_pins
trothing	12	24	1084	2	trothing
trotting	9	25	1091	2	trotting
trowing	11	34	1370	2	tro_wing
tumping	12	31	1424	2	t_umping
whomping	19	28	594	2	whomping

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.140	1276364.3
2	DLD Change Limit	121059	51	3.783	32000.8
3	Display Results	51	51	0.030	1700.0
	(SQL Overall)	178691	51	3.953	45203.9