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

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

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
josher	16	43	1296	(None)
cosher	11	48	1990	1	cosher
joshed	17	46	1090	1	joshed
joshers	17	41	1159	1	joshers
joshes	16	51	1485	1	joshes
kosher	13	44	1297	1	kosher
mosher	11	47	1979	1	mosher
nosher	9	46	1636	1	nosher
posher	11	50	1816	1	posher
basher	11	51	2381	2	basher
boshes	11	47	2188	2	boshes
bosker	12	38	1365	2	bosker
bother	11	52	1806	2	bother
busher	11	49	2220	2	busher
coshed	12	42	1754	2	coshed
coshers	12	36	1817	2	coshers
coshes	11	50	2278	2	coshes
cosier	8	44	2375	2	cosier
coster	8	43	3129	2	coster
dasher	10	43	1898	2	dasher
doser	6	62	2856	2	dos_er
dosser	7	44	1797	2	dosser
fisher	12	49	1714	2	fisher
foster	9	43	2222	2	foster
gasher	10	43	2037	2	gasher
gopher	12	3	918	2	gopher
gusher	10	41	1577	2	gusher
hoser	8	115	2976	2	hos_er
hosier	9	42	1961	2	hosier
jasper	15	46	1038	2	jasper
jester	13	43	1915	2	jester
jobber	17	38	1335	2	jobber
jogger	15	47	1316	2	jogger
joiner	13	41	1413	2	joiner
joker	16	57	1589	2	jo_ker
jokier	17	61	875	2	jokier
jolter	13	35	1309	2	jolter
josh	14	51	1761	2	josh__
josses	13	51	1768	2	josses
jostler	14	28	822	2	jostler
jotter	13	43	1563	2	jotter
jouster	14	33	1104	2	jouster
juster	13	46	1701	2	juster
kasher	13	49	1503	2	kasher
koshers	14	48	1180	2	koshers
lasher	9	48	2453	2	lasher
loser	5	47	2867	2	los_er
lusher	9	38	1876	2	lusher
masher	11	41	2320	2	masher
moshed	12	45	1749	2	moshed
moshers	12	40	1784	2	moshers
moshes	11	52	2287	2	moshes
mosser	8	46	1827	2	mosser
mother	11	37	1864	2	mother
musher	11	38	2057	2	musher
noshed	10	44	1350	2	noshed
noshers	10	36	1432	2	noshers
noshes	9	66	1823	2	noshes
nosier	6	37	1632	2	nosier
nother	9	38	1596	2	nother
ocher	10	45	1610	2	_ocher
osier	5	35	1801	2	_osier
other	8	42	1910	2	_other
pisher	11	43	1775	2	pisher
poser	7	51	2877	2	pos_er
poster	8	41	2917	2	poster
pother	11	38	1885	2	pother
pusher	11	43	1828	2	pusher
rasher	9	50	2411	2	rasher
rosier	6	42	2126	2	rosier
roster	6	43	2908	2	roster
rusher	9	40	1965	2	rusher
tocher	11	40	1491	2	tocher
toshes	9	45	2010	2	toshes
tosser	6	42	1566	2	tosser
tother	9	41	1714	2	tother
usher	8	45	1776	2	_usher
washer	12	47	2039	2	washer
wisher	12	36	1706	2	wisher
zoster	15	37	1585	2	zoster

Search took 3 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.126	1418182.5
2	DLD Change Limit	82551	80	2.576	32046.2
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	2.735	65334.9