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

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

76 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
jamming	19	32	979	(None)
bamming	14	46	1181	1	bamming
damming	13	38	1274	1	damming
gamming	13	31	1262	1	gamming
hamming	15	30	1409	1	hamming
jambing	19	32	853	1	jambing
lamming	12	30	1458	1	lamming
ramming	12	31	1506	1	ramming
aiming	9	43	2084	2	_aiming
ammine	10	3	1449	2	_ammine
ammino	10	6	988	2	_ammino
amping	11	43	1757	2	_amping
arming	9	47	1980	2	_arming
bumming	14	34	1078	2	bumming
calming	12	39	1597	2	calming
camping	14	31	1897	2	camping
clamming	15	32	937	2	clamming
cramming	15	33	943	2	cramming
damning	11	42	1163	2	damning
damping	13	34	1400	2	damping
dimming	13	33	959	2	dimming
dramming	14	34	756	2	dramming
faming	12	49	2297	2	fa_ming
farming	13	35	1508	2	farming
flamming	16	35	715	2	flamming
gaming	10	46	2204	2	ga_ming
gauming	11	31	971	2	gauming
gemming	13	28	914	2	gemming
gumming	13	38	1019	2	gumming
harming	13	37	1793	2	harming
hemming	15	26	997	2	hemming
humming	15	33	1067	2	humming
jabbing	19	31	941	2	jabbing
jacking	21	45	1526	2	jacking
jading	15	42	1402	2	ja_ding
jagging	17	33	1199	2	jagging
jailing	15	34	1584	2	jailing
jammier	18	40	802	2	jammier
jammies	18	36	1129	2	jammies
japing	16	50	1357	2	ja_ping
jarring	15	36	1319	2	jarring
jasmin	15	3	807	2	jasmin_
jasmine	16	3	664	2	jasmine
jasmins	16	3	708	2	jasmins
jauking	19	41	832	2	jauking
jauping	17	30	719	2	jauping
jawing	17	44	1496	2	ja_wing
jazzing	23	3	388	2	jazzing
jemmying	23	3	231	2	jemmying
jimminy	21	3	337	2	jimminy
jimmying	23	4	238	2	jimmying
jumping	19	31	980	2	jumping
lambing	12	34	1241	2	lambing
laming	9	45	2836	2	la_ming
lamping	12	31	1600	2	lamping
lemming	12	26	939	2	lemming
maiming	12	29	1272	2	maiming
mumming	11	40	1002	2	mumming
naming	9	39	1789	2	na_ming
nimming	12	35	814	2	nimming
palming	12	39	1401	2	palming
ramping	12	33	1687	2	ramping
rimming	12	34	1107	2	rimming
scamming	15	32	854	2	scamming
shamming	16	28	941	2	shamming
slamming	13	33	1000	2	slamming
spamming	15	31	760	2	spamming
summing	12	29	1238	2	summing
taming	9	40	2343	2	ta_ming
tamping	12	28	1581	2	tamping
tomming	12	35	924	2	tomming
tramming	13	27	934	2	tramming
unjamming	21	4	304	2	unjamming
vamping	15	28	1023	2	vamping
warming	13	35	1508	2	warming
whamming	19	27	522	2	whamming

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	76	2.890	37256.4
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	3.296	54214.5