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

Here are the results of your fuzzy-string dictionary search for “wisher” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

126 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
wisher	12	36	1706	(None)
fisher	12	49	1714	1	fisher
pisher	11	43	1775	1	pisher
swisher	13	36	952	1	swisher
washer	12	47	2039	1	washer
wiser	8	55	2280	1	wis_er
wished	13	44	1751	1	wished
wishers	13	32	1521	1	wishers
wishes	12	49	2095	1	wishes
wither	12	43	2135	1	wither
basher	11	51	2381	2	basher
bister	8	49	2276	2	bister
busher	11	49	2220	2	busher
cipher	13	37	1026	2	cipher
cither	11	46	1668	2	cither
cosher	11	48	1990	2	cosher
dasher	10	43	1898	2	dasher
dished	11	43	1871	2	dished
dishes	10	46	2265	2	dishes
dishier	11	36	1340	2	dishier
dither	10	44	1768	2	dither
either	9	45	1742	2	either
fished	13	43	1631	2	fished
fishers	13	47	1472	2	fishers
fishery	16	39	773	2	fishery
fishes	12	52	2134	2	fishes
fishier	13	35	985	2	fishier
gasher	10	43	2037	2	gasher
gusher	10	41	1577	2	gusher
higher	13	46	1089	2	higher
hisser	9	47	1379	2	hisser
hither	12	44	1725	2	hither
ither	8	46	1760	2	_ither
josher	16	43	1296	2	josher
kasher	13	49	1503	2	kasher
kisser	10	42	1245	2	kisser
kosher	13	44	1297	2	kosher
lasher	9	48	2453	2	lasher
lisper	8	41	1443	2	lisper
lister	6	45	2725	2	lister
lither	9	45	2095	2	lither
lusher	9	38	1876	2	lusher
masher	11	41	2320	2	masher
miser	7	54	3040	2	mis_er
mishear	12	3	839	2	mishear
mister	8	47	2856	2	mister
mither	11	42	1856	2	mither
mosher	11	47	1979	2	mosher
musher	11	38	2057	2	musher
nigher	10	36	1275	2	nigher
nosher	9	46	1636	2	nosher
pished	12	48	1706	2	pished
pishers	12	38	1575	2	pishers
pishes	11	47	2210	2	pishes
pisser	8	44	1638	2	pisser
posher	11	50	1816	2	posher
pusher	11	43	1828	2	pusher
rasher	9	50	2412	2	rasher
richer	11	40	1504	2	richer
riser	5	54	3105	2	ris_er
risker	10	54	1449	2	risker
rusher	9	40	1965	2	rusher
sigher	10	38	1370	2	sigher
sister	6	44	2158	2	sister
swasher	13	40	1151	2	swasher
swished	14	41	884	2	swished
swishers	14	32	805	2	swishers
swishes	13	34	1137	2	swishes
swishier	14	3	456	2	swishier
swither	13	37	1099	2	swither
tither	9	49	2028	2	tither
twister	10	30	895	2	twister
usher	8	45	1776	2	_usher
waister	10	38	1238	2	waister
washed	13	55	2150	2	washed
washers	13	45	1752	2	washers
washes	12	44	2549	2	washes
washier	13	36	1115	2	washier
waster	9	52	2894	2	waster
weigher	14	13	634	2	weigher
welsher	13	37	744	2	welsher
wester	9	42	2289	2	wester
wether	12	33	1539	2	wether
whished	17	42	802	2	whished
whishes	16	30	944	2	whishes
whisker	17	36	793	2	whisker
whisper	15	29	801	2	whisper
whither	16	35	1025	2	whither
wiches	14	44	1875	2	wiches
wicker	15	45	1867	2	wicker
widder	11	29	1397	2	widder
wider	9	48	2635	2	wi_der
wiener	9	45	1354	2	wiener
wilder	10	36	1647	2	wilder
wilier	9	32	1707	2	wilier
willer	9	40	2106	2	willer
wincer	11	50	1819	2	wincer
wincher	15	34	1065	2	wincher
winder	10	40	2526	2	winder
winger	10	41	2544	2	winger
winier	9	45	2245	2	winier
winker	13	42	2029	2	winker
winner	9	42	1993	2	winner
winter	9	42	2280	2	winter
wiper	10	54	2129	2	wi_per
wirer	8	51	2495	2	wi_rer
wirier	9	42	1555	2	wirier
wise	7	57	3734	2	wis_e_
wised	9	51	2334	2	wis_ed
wises	8	56	3319	2	wis_es
wish	10	72	2873	2	wish__
wisha	11	49	1085	2	wish_a
wisped	12	34	1189	2	wisped
wispier	12	24	940	2	wispier
wissed	10	41	1464	2	wissed
wisses	9	46	1960	2	wisses
wisted	10	41	2027	2	wisted
withe	11	52	2023	2	withe_
withed	13	44	1623	2	withed
withers	13	44	1775	2	withers
withes	12	46	2084	2	withes
withier	13	29	1049	2	withier
wiver	11	59	2451	2	wi_ver
writher	13	40	1085	2	writher
wuther	12	45	1161	2	wuther
zither	18	38	1308	2	zither

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	126	2.203	37472.1
3	Display Results	126	126	0.046	2739.1
	(SQL Overall)	178691	126	2.592	68939.4