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

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

70 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
hemming	15	26	997	(None)
gemming	13	28	915	1	gemming
hamming	15	30	1409	1	hamming
helming	13	37	1200	1	helming
humming	15	33	1067	1	humming
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
chumming	18	36	620	2	chumming
damming	13	38	1274	2	damming
deeming	11	39	1312	2	deeming
demoing	11	3	1175	2	demoing
dimming	13	33	959	2	dimming
gamming	13	31	1262	2	gamming
gumming	13	38	1019	2	gumming
harming	13	37	1793	2	harming
heading	12	29	1911	2	heading
healing	11	39	2296	2	healing
heaping	13	30	1585	2	heaping
hearing	11	33	2416	2	hearing
heating	11	40	2432	2	heating
heaving	14	41	1476	2	heaving
hedging	13	34	895	2	hedging
heeding	12	35	1506	2	heeding
heeling	11	36	1851	2	heeling
heezing	20	34	987	2	heezing
hefting	14	45	1091	2	hefting
heiling	11	36	1636	2	heiling
heiring	11	33	1290	2	heiring
helling	11	46	2322	2	helling
helping	13	35	1222	2	helping
helving	14	40	1113	2	helving
hemin	10	36	2093	2	he_min_
hemins	11	34	1757	2	he_mins
hemline	12	3	1107	2	hemline
henting	11	37	1965	2	henting
herding	12	29	1512	2	herding
herring	11	36	1588	2	herring
hewing	13	45	1424	2	he_wing
hexing	17	42	1051	2	he_xing
homing	12	37	1838	2	h_oming
humping	15	32	1307	2	humping
hymning	16	3	518	2	hymning
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
rehemming	17	3	474	2	rehemming
rimming	12	34	1107	2	rimming
seaming	10	32	2211	2	seaming
seeming	10	32	1626	2	seeming
shamming	16	28	941	2	shamming
shimming	16	27	825	2	shimming
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
theming	13	36	1047	2	the_ming
tomming	12	35	924	2	tomming
whamming	19	27	522	2	whamming
whelming	17	30	492	2	whelming

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	70	3.280	32826.5
3	Display Results	70	70	0.016	4375.0
	(SQL Overall)	178691	70	3.669	48702.9