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

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

53 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
gemming	13	28	914	(None)
gamming	13	31	1262	1	gamming
gumming	13	38	1019	1	gumming
hemming	15	26	997	1	hemming
lemming	12	26	939	1	lemming
bamming	14	46	1181	2	bamming
beaming	12	36	1880	2	beaming
berming	12	36	1483	2	berming
bumming	14	34	1078	2	bumming
damming	13	38	1274	2	damming
deeming	11	39	1312	2	deeming
demoing	11	3	1175	2	demoing
dimming	13	33	959	2	dimming
gaming	10	46	2204	2	g_aming
gauming	11	31	971	2	gauming
gearing	9	28	1884	2	gearing
gecking	15	41	1136	2	gecking
geeing	8	43	1376	2	ge_eing
gelding	10	39	1179	2	gelding
gelling	9	32	1976	2	gelling
gemmating	15	7	644	2	gemmating
gemmier	12	33	738	2	gemmier
gemmily	15	3	460	2	gemmily
germina	10	3	849	2	germina
getting	9	33	1656	2	getting
gimping	13	37	1076	2	gimping
gleaming	12	27	793	2	gleaming
gliming	11	33	1013	2	gliming
glomming	14	27	592	2	glomming
gorming	11	28	1083	2	gorming
griming	11	36	1249	2	griming
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
lamming	12	30	1458	2	lamming
lemmings	13	25	473	2	lemmings
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
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 8 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.750	238254.7
2	DLD Change Limit	107671	53	6.326	17020.4
3	Display Results	53	53	0.033	1606.1
	(SQL Overall)	178691	53	7.109	25135.9