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

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

95 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
gamming	13	31	1262	(None)
bamming	14	46	1181	1	bamming
damming	13	38	1274	1	damming
gaming	10	46	2204	1	ga_ming
gauming	11	31	971	1	gauming
gemming	13	28	915	1	gemming
gumming	13	38	1019	1	gumming
hamming	15	30	1409	1	hamming
jamming	19	32	979	1	jamming
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	757	2	dramming
faming	12	49	2297	2	fa_ming
farming	13	35	1508	2	farming
flamming	16	35	715	2	flamming
gabbing	13	35	1203	2	gabbing
gabling	11	35	1454	2	gabling
gadding	11	34	1145	2	gadding
gaeing	8	46	1722	2	ga_eing
gaffing	15	37	973	2	gaffing
gagging	9	30	1353	2	gagging
gaging	9	47	1840	2	ga_ging
gaining	9	40	1566	2	gaining
gaiting	9	37	1658	2	gaiting
galling	9	39	2196	2	galling
gambling	14	21	896	2	gambling
gamin	8	44	2300	2	ga_min_
gamine	9	46	2015	2	ga_mine
gamings	11	46	1091	2	ga_mings
gamins	9	44	2005	2	ga_mins
gammier	12	37	1119	2	gammier
gammon	11	3	890	2	gammon_
gammoning	15	4	506	2	gammoning
gammons	12	3	797	2	gammons
ganging	10	32	1619	2	ganging
gaoling	9	33	1465	2	gaoling
gaping	10	56	1892	2	ga_ping
gapping	13	42	1478	2	gapping
garbing	11	36	1327	2	garbing
garring	9	31	1671	2	garring
gashing	12	51	1923	2	gashing
gasking	13	44	1591	2	gasking
gasping	11	37	1436	2	gasping
gassing	9	42	1633	2	gassing
gasting	9	50	2276	2	gasting
gating	8	48	2695	2	ga_ting
gauging	10	33	996	2	gauging
gawking	16	39	882	2	gawking
gawping	14	41	846	2	gawping
gazing	17	47	1717	2	ga_zing
gimping	13	37	1076	2	gimping
gliming	11	33	1013	2	gliming
glomming	14	27	592	2	glomming
gorming	11	28	1083	2	gorming
griming	11	36	1249	2	griming
harming	13	37	1793	2	harming
hemming	15	26	997	2	hemming
humming	15	33	1067	2	humming
jambing	19	32	853	2	jambing
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
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	95	3.343	32207.9
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	3.749	47663.6