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

Here are the results of your fuzzy-string dictionary search for “gimleting” with Change Limit: [1] [2] [3] [4]

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.

80 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
gimleting	13	4	386	(None)
billeting	12	3	664	2	billeting
fileting	12	3	930	2	fi_leting
filleting	13	3	585	2	filleting
galleting	11	3	763	2	galleting
gibbeting	15	4	290	2	gibbeting
bulleting	12	3	664	3	bulleting
colleting	12	3	1106	3	colleting
competing	16	37	1246	3	competing
completing	17	4	842	3	completing
deleting	10	33	1442	3	_deleting
depleting	13	7	819	3	depleting
dieting	9	36	1683	3	di__eting
dilating	10	27	1491	3	di_lating
diluting	10	24	898	3	di_luting
fidgeting	15	4	452	3	fidgeting
gantleting	12	4	391	3	gantleting
gelating	10	30	1573	3	g_elating
gemmating	15	7	644	3	gemmating
gibbering	15	3	471	3	gibbering
gibbetting	16	4	231	3	gibbetting
gieing	8	36	1485	3	gi__e_ing
gifting	12	38	1089	3	gi__fting
gilding	10	38	1300	3	gi_l_ding
gilling	9	35	2038	3	gi_l_ling
gillnetting	13	5	154	3	gillnetting
gillying	13	30	681	3	gi_llying
gimbaling	15	13	444	3	gimbaling
gimlet	9	37	1666	3	gimlet___
gimleted	12	4	397	3	gimlet_ed
gimlets	10	33	843	3	gimlet__s
gimping	13	37	1076	3	gim__ping
gingering	12	3	887	3	gingering
girting	9	31	1333	3	gi__rting
gitting	9	32	1570	3	gi__tting
gleeting	10	27	917	3	g_leeting
gleying	12	31	843	3	g__leying
glimmering	16	4	371	3	glimmering
greeting	10	31	1235	3	g_reeting
grommeting	16	4	291	3	grommeting
grummeting	16	4	245	3	grummeting
gusseting	11	7	396	3	gusseting
helmeting	15	4	550	3	helmeting
hilting	11	33	1689	3	hi_l_ting
impeding	14	3	656	3	_impeding
imputing	13	3	685	3	_imputing
inletting	10	8	787	3	_inletting
jilting	15	32	1174	3	ji_l_ting
kilting	12	32	1385	3	ki_l_ting
lilting	8	35	1538	3	li_l_ting
limbering	14	8	879	3	limbering
limiting	11	3	881	3	lim_iting
meeting	10	33	1496	3	__meeting
melting	10	33	1775	3	__melting
meting	9	43	2059	3	__m_eting
milting	10	36	1912	3	mi_l_ting
mimeoing	13	3	614	3	mim_eoing
mismeeting	15	4	624	3	mismeeting
palleting	12	3	874	3	palleting
pelleting	12	3	795	3	pelleting
picketing	18	3	568	3	picketing
piloting	11	3	969	3	pi_loting
remeeting	12	3	1143	3	remeeting
remelting	12	3	1170	3	remelting
riveting	12	13	944	3	ri_veting
signeting	11	3	622	3	signeting
silting	8	33	2048	3	si_l_ting
simmering	14	6	782	3	simmering
simpering	14	4	929	3	simpering
simulating	13	4	761	3	simulating
smelting	11	33	971	3	_smelting
tableting	12	3	635	3	tableting
ticketing	16	3	563	3	ticketing
tillering	10	3	788	3	tillering
tilting	8	34	1710	3	ti_l_ting
timbering	14	11	772	3	timbering
toileting	10	3	626	3	toileting
valeting	12	3	885	3	_valeting
violating	13	3	744	3	violating
wilting	11	35	1591	3	wi_l_ting

Search took 10 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	148641	0.483	369960.7
2	DLD Change Limit	148641	80	9.000	16515.7
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	9.513	18783.9