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

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

91 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
gimping	13	37	1076	(None)
gipping	13	38	1312	1	gipping
imping	11	43	1535	1	_imping
limping	12	46	1411	1	limping
pimping	14	38	1212	1	pimping
wimping	15	39	1101	1	wimping
aiming	9	43	2084	2	aim_ing
amping	11	43	1757	2	_amping
bumping	14	38	1249	2	bumping
camping	14	31	1897	2	camping
comping	14	35	1859	2	comping
crimping	15	29	978	2	crimping
damping	13	34	1400	2	damping
dimming	13	33	959	2	dimming
dimpling	14	19	902	2	dimpling
dipping	13	40	1483	2	dipping
dumping	13	37	1291	2	dumping
gaming	10	46	2204	2	gam_ing
gamming	13	31	1262	2	gamming
gaping	10	56	1892	2	g_aping
gapping	13	42	1478	2	gapping
gasping	11	37	1436	2	gasping
gawping	14	41	846	2	gawping
gemming	13	28	914	2	gemming
gibbing	13	33	937	2	gibbing
gibing	10	37	1235	2	gi_bing
gieing	8	36	1485	2	gi_eing
gifting	12	38	1089	2	gifting
gigging	9	33	1177	2	gigging
gilding	10	38	1300	2	gilding
gilling	9	35	2038	2	gilling
gimpier	12	24	794	2	gimpier
ginning	9	33	1398	2	ginning
girding	10	36	1188	2	girding
girning	9	32	1069	2	girning
girting	9	31	1333	2	girting
gitting	9	32	1570	2	gitting
giving	11	43	1388	2	gi_ving
gliming	11	33	1013	2	glim_ing
glimpsing	15	4	259	2	glimpsing
griming	11	36	1249	2	grim_ing
griping	11	30	1206	2	griping
gripping	14	27	754	2	gripping
groping	11	33	1310	2	groping
grumping	14	26	690	2	grumping
gulping	11	30	975	2	gulping
gumming	13	38	1019	2	gumming
gypping	16	30	584	2	gypping
hipping	15	39	1510	2	hipping
humping	15	32	1307	2	humping
impinge	12	42	750	2	_impinge
impings	12	34	855	2	_impings
jumping	19	31	980	2	jumping
kipping	16	33	1187	2	kipping
lamping	12	31	1600	2	lamping
limbing	12	34	1042	2	limbing
liming	9	40	2124	2	lim_ing
limning	10	37	1032	2	limning
lipping	12	30	1607	2	lipping
lisping	10	34	1275	2	lisping
lumping	12	33	1464	2	lumping
miming	11	43	1726	2	mim_ing
mumping	14	34	1163	2	mumping
nimming	12	35	814	2	nimming
nipping	12	34	1287	2	nipping
piping	11	40	1745	2	pi_ping
pipping	11	34	1474	2	pipping
primping	15	33	889	2	primping
pumping	14	42	1355	2	pumping
ramping	12	33	1687	2	ramping
riming	9	33	2222	2	rim_ing
rimming	12	34	1107	2	rimming
rimpling	13	21	966	2	rimpling
riping	9	38	2161	2	ri_ping
ripping	12	33	1574	2	ripping
romping	12	31	1303	2	romping
siping	9	42	2063	2	si_ping
sipping	12	31	1743	2	sipping
skimping	17	30	624	2	skimping
tamping	12	28	1581	2	tamping
temping	12	27	1069	2	temping
timing	9	36	1930	2	tim_ing
tipping	12	28	1497	2	tipping
tumping	12	31	1424	2	tumping
umping	11	48	1533	2	_umping
vamping	15	28	1023	2	vamping
wimpling	16	20	748	2	wimpling
wiping	12	39	1671	2	wi_ping
wisping	13	37	1194	2	wisping
yipping	15	27	1068	2	yipping
zipping	21	29	1057	2	zipping

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.360	496363.9
2	DLD Change Limit	107671	91	2.780	38730.6
3	Display Results	91	91	0.033	2757.6
	(SQL Overall)	178691	91	3.173	56316.1