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

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

70 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
dishy	12	57	1235	(None)
dashy	12	56	1238	1	dashy
dish	8	63	2833	1	dish_
fishy	14	60	1166	1	fishy
ashy	10	77	1735	2	_ashy
bushy	13	54	1668	2	bushy
cissy	10	48	1107	2	cissy
cushy	13	44	1232	2	cushy
daisy	9	59	1531	2	dais_y
dash	8	70	3163	2	dash_
dashi	9	50	1311	2	dashi
diary	9	50	1697	2	diary
dicey	11	48	1933	2	dicey
dicky	15	48	1624	2	dicky
dicty	11	51	1629	2	dicty
didy	9	91	2150	2	di_dy
dight	10	40	2700	2	dight
dikey	13	51	1642	2	dikey
dilly	9	49	2378	2	dilly
dimly	11	49	1348	2	dimly
dinghy	14	47	696	2	dinghy
dingy	10	57	2126	2	dingy
dinky	13	58	1937	2	dinky
dippy	13	51	1154	2	dippy
dirty	9	56	1780	2	dirty
dis	4	64	5989	2	dis__
disc	7	61	2323	2	dis_c
disci	8	58	1502	2	disci
disco	8	56	1607	2	disco
discs	8	53	1626	2	discs
dished	11	43	1871	2	dished
dishes	10	46	2265	2	dishes
disk	9	66	2583	2	dis_k
disks	10	54	1747	2	disks
dismay	12	22	947	2	dismay
disme	8	57	1624	2	disme
diss	5	64	3448	2	dis_s
ditsy	9	56	1256	2	ditsy
ditty	9	50	1929	2	ditty
ditzy	18	65	1328	2	ditzy
divvy	15	35	648	2	divvy
dizzy	17	74	1085	2	dizzy
duchy	14	43	1087	2	duchy
dusky	13	52	1304	2	dusky
dusty	9	60	1832	2	dusty
fish	10	69	2627	2	fish_
gushy	12	52	1312	2	gushy
hissy	11	61	1212	2	hissy
kissy	12	55	1031	2	kissy
mashy	13	60	1650	2	mashy
meshy	13	56	1278	2	meshy
missy	10	56	1756	2	missy
misty	10	61	2045	2	misty
mushy	13	53	1663	2	mushy
pish	9	61	2791	2	pish_
pithy	13	56	1446	2	pithy
pushy	13	46	1435	2	pushy
rishi	8	3	1125	2	rishi
risky	12	63	1152	2	risky
rushy	11	54	1481	2	rushy
shy	9	67	2819	2	__shy
sissy	8	58	1207	2	sissy
swishy	15	36	584	2	swishy
tushy	11	42	1299	2	tushy
vichy	16	3	904	2	vichy
washy	14	59	1184	2	washy
wish	10	72	2873	2	wish_
wisha	11	49	1085	2	wisha
wispy	13	72	1097	2	wispy
withy	14	48	1376	2	withy

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	53800	0.653	273646.2
2	DLD Change Limit	53800	70	2.953	18218.8
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	3.639	49104.4