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

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

26 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
joshed	17	46	1090	1	joshed
josher	16	43	1296	1	josher
joshes	16	51	1485	1	joshes
boshes	11	47	2188	2	boshes
bosket	12	49	1922	2	bosket
coset	7	57	4884	2	cos_et
coshed	12	42	1755	2	coshed
cosher	11	48	1990	2	cosher
coshes	11	50	2278	2	coshes
cosset	8	41	2586	2	cosset
josh	14	51	1761	2	josh__
joshers	17	41	1159	2	joshers
josses	13	51	1768	2	josses
kosher	13	44	1297	2	kosher
moshed	12	45	1749	2	moshed
mosher	11	47	1979	2	mosher
moshes	11	52	2287	2	moshes
noshed	10	44	1351	2	noshed
nosher	9	46	1636	2	nosher
noshes	9	66	1823	2	noshes
posher	11	50	1816	2	posher
poshest	12	3	1242	2	poshest
posset	8	49	2325	2	posset
rochet	11	54	2300	2	rochet
roset	5	59	4524	2	ros_et
toshes	9	45	2010	2	toshes

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.343	520965.0
2	DLD Change Limit	82551	26	2.376	34743.7
3	Display Results	26	26	0.000
	(SQL Overall)	178691	26	2.719	65719.4