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

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

78 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
tomming	12	35	924	(None)
tombing	12	33	1053	1	tombing
bamming	14	46	1181	2	bamming
bombing	14	32	1139	2	bombing
booming	12	37	1622	2	booming
bumming	14	34	1078	2	bumming
coaming	12	38	1832	2	coaming
combing	14	37	1473	2	combing
coming	11	42	2545	2	co_ming
comping	14	35	1859	2	comping
damming	13	38	1274	2	damming
dimming	13	33	959	2	dimming
doming	10	42	1839	2	do_ming
dooming	11	31	1253	2	dooming
foaming	13	36	1299	2	foaming
forming	13	36	1573	2	forming
gamming	13	31	1262	2	gamming
gemming	13	28	915	2	gemming
glomming	14	27	592	2	glomming
gorming	11	28	1083	2	gorming
gumming	13	38	1019	2	gumming
hamming	15	30	1409	2	hamming
hemming	15	26	997	2	hemming
homing	12	37	1838	2	ho_ming
humming	15	33	1067	2	humming
jamming	19	32	979	2	jamming
lamming	12	30	1458	2	lamming
lemming	12	26	939	2	lemming
loaming	10	36	1373	2	loaming
looming	10	28	1485	2	looming
mumming	11	40	1002	2	mumming
nimming	12	35	814	2	nimming
ramming	12	31	1506	2	ramming
rimming	12	34	1107	2	rimming
roaming	10	32	1579	2	roaming
romping	12	31	1303	2	romping
rooming	10	41	1704	2	rooming
stemming	13	40	820	2	stemming
stomping	13	30	976	2	stomping
storming	11	20	942	2	storming
stumming	13	34	767	2	stumming
summing	12	29	1238	2	summing
taming	9	40	2343	2	t_aming
tamping	12	28	1581	2	tamping
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	theming
timing	9	36	1930	2	t_iming
toeing	7	44	1847	2	to_eing
togging	10	35	1274	2	togging
toiling	8	32	1902	2	toiling
toiting	8	32	1709	2	toiting
toking	11	44	2072	2	to_king
toling	7	39	2612	2	to_ling
tolling	8	34	1856	2	tolling
tommies	11	38	1298	2	tommies
tonging	9	33	1451	2	tonging
toning	7	40	2579	2	to_ning
tooling	8	29	1831	2	tooling
tooting	8	30	1942	2	tooting
toping	9	41	2299	2	to_ping
topping	12	35	1462	2	topping
tossing	8	36	1256	2	tossing
toting	7	41	2379	2	to_ting
totting	8	28	1684	2	totting
touring	8	29	1519	2	touring
tousing	8	29	1699	2	tousing
touting	8	41	1845	2	touting
towing	10	38	2319	2	to_wing
toying	10	50	1730	2	to_ying
tramming	13	27	934	2	tramming
trimming	13	31	865	2	trimming
tromping	13	31	960	2	tromping
tumping	12	31	1424	2	tumping
worming	13	28	1124	2	worming
zooming	19	26	965	2	zooming

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	78	2.830	38046.3
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	3.233	55271.0