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

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

67 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
lemming	12	26	939	(None)
gemming	13	28	914	1	gemming
hemming	15	26	997	1	hemming
lamming	12	30	1458	1	lamming
lemmings	13	25	473	1	lemmings
bamming	14	46	1181	2	bamming
beaming	12	36	1880	2	beaming
berming	12	36	1483	2	berming
bumming	14	34	1078	2	bumming
clamming	15	32	937	2	clamming
damming	13	38	1274	2	damming
deeming	11	39	1312	2	deeming
demoing	11	3	1175	2	demoing
dimming	13	33	959	2	dimming
flamming	16	35	715	2	flamming
gamming	13	31	1262	2	gamming
gleaming	12	27	793	2	gleaming
glomming	14	27	592	2	glomming
gumming	13	38	1019	2	gumming
hamming	15	30	1409	2	hamming
helming	13	37	1200	2	helming
humming	15	33	1067	2	humming
jamming	19	32	979	2	jamming
jemmying	23	3	231	2	jemmying
lambing	12	34	1241	2	lambing
laming	9	45	2836	2	l_aming
lamping	12	31	1600	2	lamping
leading	9	34	1955	2	leading
leafing	11	33	1358	2	leafing
leaking	12	36	1697	2	leaking
leaning	8	37	2120	2	leaning
leaping	10	32	1599	2	leaping
leasing	8	39	2016	2	leasing
leaving	11	42	1685	2	leaving
leching	13	46	1365	2	leching
leering	8	34	1764	2	leering
legging	10	39	1264	2	legging
lekking	11	30	650	2	lekking
lending	9	41	1853	2	lending
lensing	8	40	1510	2	lensing
letting	8	32	1853	2	letting
levying	14	3	587	2	levying
limbing	12	34	1042	2	limbing
liming	9	40	2124	2	l_iming
limning	10	37	1032	2	limning
limping	12	46	1411	2	limping
loaming	10	36	1373	2	loaming
looming	10	28	1485	2	looming
lumping	12	33	1464	2	lumping
mumming	11	40	1002	2	mumming
nimming	12	35	814	2	nimming
perming	12	34	1609	2	perming
ramming	12	31	1506	2	ramming
reaming	10	39	2401	2	reaming
rimming	12	34	1107	2	rimming
seaming	10	32	2211	2	seaming
seeming	10	32	1626	2	seeming
slamming	13	33	1000	2	slamming
slimming	13	28	809	2	slimming
slumming	13	27	838	2	slumming
stemming	13	40	820	2	stemming
summing	12	29	1238	2	summing
teaming	10	39	1759	2	teaming
teeming	10	35	1309	2	teeming
temping	12	27	1069	2	temping
terming	10	40	1600	2	terming
tomming	12	35	924	2	tomming

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.376	475242.0
2	DLD Change Limit	107671	67	3.000	35890.3
3	Display Results	67	67	0.016	4187.5
	(SQL Overall)	178691	67	3.392	52680.1