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

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

50 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
tramming	13	27	934	(None)
cramming	15	33	943	1	cramming
dramming	14	34	756	1	dramming
ramming	12	31	1506	1	_ramming
tramping	13	27	1127	1	tramping
trimming	13	31	865	1	trimming
bamming	14	46	1181	2	_bamming
brimming	15	19	662	2	brimming
clamming	15	32	937	2	clamming
cramping	15	34	1185	2	cramping
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
scramming	16	3	488	2	scramming
shamming	16	28	941	2	shamming
slamming	13	33	1000	2	slamming
spamming	15	31	760	2	spamming
strumming	14	5	441	2	strumming
taming	9	40	2343	2	t_a_ming
tamping	12	28	1581	2	t_amping
teaming	10	39	1759	2	tea_ming
thrumming	17	4	290	2	thrumming
tomming	12	35	924	2	t_omming
tracing	10	37	2015	2	tra_cing
tracking	15	37	1546	2	tracking
trading	9	35	1797	2	tra_ding
traiking	13	25	1197	2	traiking
trailing	9	29	1609	2	trailing
training	9	30	1586	2	training
trameling	12	4	905	2	trameling
tramline	10	3	1138	2	tramline
trammeling	15	4	402	2	trammeling
trampling	14	3	696	2	trampling
trancing	11	28	1202	2	trancing
trapping	13	29	1139	2	trapping
trashing	12	26	1322	2	trashing
trawling	12	27	1078	2	trawling
trimmings	14	25	445	2	trimmings
tromping	13	31	959	2	tromping
trumping	13	30	873	2	trumping
whamming	19	27	522	2	whamming

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	121059	0.140	1276364.3
2	DLD Change Limit	121059	50	5.140	23552.3
3	Display Results	50	50	0.016	3125.0
	(SQL Overall)	178691	50	5.296	33740.7