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

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

99 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
gusher	10	41	1577	(None)
busher	11	49	2220	1	busher
gasher	10	43	2037	1	gasher
gushed	11	48	1624	1	gushed
gushers	11	35	1251	1	gushers
gushes	10	47	1903	1	gushes
gushier	11	31	1007	1	gushier
lusher	9	38	1876	1	lusher
musher	11	38	2057	1	musher
pusher	11	43	1828	1	pusher
rusher	9	40	1965	1	rusher
usher	8	45	1776	1	_usher
basher	11	51	2381	2	basher
blusher	12	41	1311	2	blusher
brusher	12	38	1300	2	brusher
bushed	12	48	2238	2	bushed
bushel	11	45	1394	2	bushel
bushers	12	40	1880	2	bushers
bushes	11	52	2611	2	bushes
bushier	12	37	1281	2	bushier
busier	8	52	1972	2	busier
busker	12	55	1783	2	busker
buster	8	47	2649	2	buster
cosher	11	48	1990	2	cosher
crusher	12	44	1232	2	crusher
cushier	12	36	1083	2	cushier
cusser	8	60	1609	2	cusser
dasher	10	43	1898	2	dasher
duster	7	49	1972	2	duster
fisher	12	49	1714	2	fisher
flusher	13	30	1227	2	flusher
fusser	9	48	1377	2	fusser
gashed	11	63	2197	2	gashed
gashes	10	57	2515	2	gashes
gasper	9	45	1554	2	gasper
gasser	7	50	1777	2	gasser
gaster	7	50	2735	2	gaster
gather	10	41	1585	2	gather
gaucher	13	3	723	2	gaucher
gopher	12	3	918	2	gopher
guesser	8	16	654	2	guesser
guider	8	43	1352	2	guider
gulper	9	34	1021	2	gulper
gummer	11	46	1545	2	gummer
gunner	7	38	1398	2	gunner
gurshes	11	22	1003	2	gurshes
gush	8	54	2400	2	gush__
gushy	12	52	1312	2	gush_y
gusset	7	3	1643	2	gusset
gusted	8	43	1672	2	gusted
gustier	8	38	1386	2	gustier
gutsier	8	38	982	2	gutsier
gutter	7	38	1771	2	gutter
hushed	13	44	1667	2	hushed
hushes	12	47	1859	2	hushes
husker	13	42	1270	2	husker
josher	16	43	1296	2	josher
juster	13	46	1701	2	juster
kasher	13	49	1503	2	kasher
kosher	13	44	1297	2	kosher
lasher	9	48	2453	2	lasher
lushed	10	42	1872	2	lushed
lushes	9	40	2274	2	lushes
luster	6	40	2367	2	luster
masher	11	41	2320	2	masher
mosher	11	47	1979	2	mosher
muser	7	60	2412	2	mus_er
mushed	12	44	2084	2	mushed
mushers	12	40	1644	2	mushers
mushes	11	41	2456	2	mushes
mushier	12	38	1359	2	mushier
muster	8	47	2452	2	muster
nosher	9	46	1636	2	nosher
ouster	6	42	2373	2	ouster
pisher	11	43	1775	2	pisher
plusher	12	40	1038	2	plusher
posher	11	50	1816	2	posher
pushed	12	50	1746	2	pushed
pushers	12	38	1450	2	pushers
pushes	11	46	2166	2	pushes
pushier	12	36	1109	2	pushier
quasher	19	19	862	2	quasher
rasher	9	50	2412	2	rasher
rushed	10	44	1986	2	rushed
rushee	9	38	1877	2	rushee
rushers	10	38	1610	2	rushers
rushes	9	47	2436	2	rushes
rushier	10	34	1197	2	rushier
shusher	13	28	811	2	shusher
tushed	10	46	1589	2	tushed
tushery	13	3	563	2	tushery
tushes	9	43	1947	2	tushes
tusker	10	42	1219	2	tusker
tusser	6	46	1583	2	tusser
user	4	50	2300	2	_us_er
ushers	9	44	1553	2	_ushers
washer	12	47	2039	2	washer
wisher	12	36	1706	2	wisher
wuther	12	45	1161	2	wuther

Search took 6 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	82551	0.236	757165.3
2	DLD Change Limit	82551	99	4.860	16985.8
3	Display Results	99	99	0.060	1650.0
	(SQL Overall)	178691	99	5.156	34656.9