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

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

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

267 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
fishery	16	39	773	(None)
fisher	12	49	1714	1	fisher_
fishers	13	47	1472	1	fishers
dithery	14	31	894	2	dithery
fiery	11	47	1479	2	fi__ery
finery	12	45	1289	2	fi_nery
fished	13	43	1631	2	fishe_d
fishes	12	52	2134	2	fishe_s
fisheye	16	4	477	2	fisheye
fishier	13	35	985	2	fishier_
fishily	16	3	764	2	fishily
fishway	19	4	381	2	fishway
fishy	14	60	1166	2	fish__y
misery	11	41	1354	2	mis_ery
pisher	11	43	1775	2	pisher_
pishers	12	38	1575	2	pishers
tushery	13	3	563	2	tushery
wisher	12	36	1706	2	wisher_
wishers	13	32	1521	2	wishers
archery	15	47	806	3	archery
basher	11	51	2381	3	basher_
bashers	12	48	2083	3	bashers
bibbery	13	42	654	3	bibbery
bindery	13	45	983	3	bindery
bioherm	14	3	465	3	bioherm
bister	8	49	2276	3	bister_
bisters	9	39	2261	3	bisters
bitchery	18	23	656	3	bitchery
blistery	13	41	871	3	blistery
busher	11	49	2220	3	busher_
bushers	12	40	1880	3	bushers
cindery	13	42	919	3	cindery
cipher	13	37	1026	3	cipher_
ciphers	14	37	999	3	ciphers
cistern	9	33	1070	3	cistern
cither	11	46	1668	3	cither_
cithern	12	48	991	3	cithern
cithers	12	43	1577	3	cithers
cosher	11	48	1990	3	cosher_
coshers	12	36	1818	3	coshers
dasher	10	43	1898	3	dasher_
dashers	11	50	1686	3	dashers
discern	10	3	849	3	discern
dished	11	43	1871	3	dishe_d
dishelm	13	3	583	3	dishelm
disherit	12	4	1252	3	disherit
dishes	10	46	2265	3	dishe_s
dishier	11	36	1340	3	dishier_
dishy	12	57	1235	3	dish__y
dissert	8	37	2069	3	dissert
dither	10	44	1768	3	dither_
dithers	11	40	1615	3	dithers
either	9	45	1742	3	either_
faery	11	60	1548	3	f__aery
fakery	16	50	926	3	f_akery
fashed	13	67	2025	3	fashe_d
fashes	12	45	2402	3	fashe_s
faster	9	46	2577	3	faster_
father	12	51	1671	3	father_
fatherly	17	4	507	3	fatherly
fathers	13	39	1650	3	fathers
feathery	17	36	807	3	feathery
fernery	13	3	581	3	fernery
fester	9	47	2351	3	fester_
festers	10	41	2139	3	festers
fibber	13	48	1193	3	fibber_
fibbers	14	45	1060	3	fibbers
fiber	10	49	2113	3	fi_ber_
fibers	11	47	1752	3	fi_bers
fibster	12	14	653	3	fibster_
fibsters	13	12	641	3	fibsters
fiche	13	46	1674	3	fiche__
fiches	14	52	1953	3	fiche_s
fidgety	15	38	489	3	fidgety
fifer	11	55	1997	3	fi_fer_
fifers	12	54	1492	3	fi_fers
fighter	14	30	1077	3	fighter_
fighters	15	26	940	3	fighters
filbert	12	4	1164	3	filbert
filcher	15	37	779	3	filcher_
filchers	16	28	686	3	filchers
filer	8	54	3300	3	fi_ler_
filers	9	46	2372	3	fi_lers
filler	9	46	2362	3	filler_
fillers	10	43	2021	3	fillers
filmer	11	41	1240	3	filmer_
filmers	12	42	1129	3	filmers
filter	9	45	1763	3	filter_
filters	10	38	1655	3	filters
finder	10	40	2023	3	finder_
finders	11	37	1787	3	finders
finely	12	30	1156	3	fi_nely
finer	8	54	3156	3	fi_ner_
finger	10	49	2033	3	finger_
fingers	11	34	1843	3	fingers
finisher	14	3	630	3	finisher_
finishers	15	4	535	3	finishers
firer	8	112	2925	3	fi_rer_
firers	9	49	2268	3	fi_rers
firmer	11	47	1244	3	firmer_
firmers	12	47	1144	3	firmers
firry	11	57	1353	3	fi__rry
fish	10	69	2627	3	fish___
fisheries	15	4	864	3	fisheries
fisherman	17	4	273	3	fisherman
fishermen	17	4	343	3	fishermen
fisheyes	17	4	409	3	fisheyes
fishgig	15	4	210	3	fishgig
fishiest	14	3	1045	3	fishiest
fishing	14	39	1386	3	fishing
fishless	14	3	641	3	fishless
fishmeal	16	4	266	3	fishmeal
fishnet	13	4	1034	3	fishnet
fishnets	14	4	563	3	fishnets
fishways	20	4	364	3	fishways
fishworm	19	4	380	3	fishworm
fissure	10	3	678	3	fissure
fisted	10	42	1870	3	fiste_d
fitter	9	41	2003	3	fitter_
fitters	10	45	1775	3	fitters
fiver	11	60	2494	3	fi_ver_
fivers	12	44	2092	3	fi_vers
fixer	15	47	1783	3	fi_xer_
fixers	16	51	1298	3	fi_xers
fizzer	17	36	938	3	fizzer_
fizzers	18	35	700	3	fizzers
flasher	13	39	1406	3	flasher_
flashers	14	39	1265	3	flashers
flesher	13	36	1092	3	flesher_
fleshers	14	33	944	3	fleshers
flickery	20	36	510	3	flickery
flowery	16	32	778	3	flowery
flusher	13	30	1227	3	flusher_
flushers	14	27	973	3	flushers
foolery	13	3	669	3	foolery
foppery	17	38	562	3	foppery
forgery	14	41	930	3	forgery
foster	9	43	2222	3	foster_
fosters	10	42	2010	3	fosters
fresher	13	26	1264	3	fresher_
frippery	18	3	295	3	frippery
frisker	14	38	927	3	frisker_
friskers	15	33	737	3	friskers
fullery	13	33	797	3	fullery
fusser	9	48	1377	3	fusser_
fussers	10	42	1081	3	fussers
gasher	10	43	2037	3	gasher_
gingery	12	36	891	3	gingery
gusher	10	41	1577	3	gusher_
gushers	11	35	1251	3	gushers
higher	13	46	1089	3	higher_
hisser	9	47	1379	3	hisser_
hissers	10	41	1231	3	hissers
history	13	3	942	3	history
hither	12	44	1725	3	hither_
hosiery	13	33	718	3	hosiery
inhere	9	3	1371	3	_inhere
ither	8	46	1760	3	_ither_
jaspery	19	40	525	3	jaspery
jittery	17	34	644	3	jittery
josher	16	43	1296	3	josher_
joshers	17	41	1159	3	joshers
kasher	13	49	1503	3	kasher_
kashers	14	39	1402	3	kashers
kisser	10	42	1245	3	kisser_
kissers	11	42	1129	3	kissers
kosher	13	44	1297	3	kosher_
koshers	14	48	1180	3	koshers
lasher	9	48	2453	3	lasher_
lashers	10	41	2183	3	lashers
lathery	13	39	1112	3	lathery
lechery	15	25	764	3	lechery
lisper	8	41	1443	3	lisper_
lispers	9	45	1432	3	lispers
lister	6	45	2725	3	lister_
listers	7	40	2653	3	listers
lithely	13	5	664	3	lithely
lither	9	45	2095	3	lither_
littery	10	37	1049	3	littery
livery	12	49	1090	3	li_very
lusher	9	38	1876	3	lusher_
masher	11	41	2320	3	masher_
mashers	12	46	2105	3	mashers
mastery	12	42	1432	3	mastery
miser	7	54	3040	3	mis_er_
miserly	12	32	982	3	mis_erly
misers	8	50	2570	3	mis_ers
mishear	12	3	839	3	mishear
misheard	14	4	625	3	misheard
mishears	13	3	832	3	mishears
misrely	12	31	961	3	misrely
mister	8	47	2856	3	mister_
misterm	11	43	1451	3	misterm
misters	9	39	2751	3	misters
mither	11	42	1856	3	mither_
mithers	12	35	1673	3	mithers
mosher	11	47	1979	3	mosher_
moshers	12	40	1784	3	moshers
mothery	15	37	1051	3	mothery
musher	11	38	2057	3	musher_
mushers	12	40	1644	3	mushers
mystery	15	43	652	3	mystery
nigher	10	36	1275	3	nigher_
nitery	9	44	1217	3	ni_tery
nosher	9	46	1636	3	nosher_
noshers	10	36	1433	3	noshers
ochery	14	31	944	3	_ochery
piggery	14	26	619	3	piggery
pinery	11	52	1429	3	pi_nery
piscary	14	3	742	3	piscary
pished	12	48	1706	3	pishe_d
pishes	11	47	2210	3	pishe_s
pisser	8	44	1638	3	pisser_
pissers	9	50	1475	3	pissers
posher	11	50	1816	3	posher_
pusher	11	43	1828	3	pusher_
pushers	12	38	1450	3	pushers
rasher	9	50	2412	3	rasher_
rashers	10	40	2091	3	rashers
richer	11	40	1504	3	richer_
riflery	13	34	580	3	riflery
riser	5	54	3105	3	ris_er_
risers	6	46	2478	3	ris_ers
risker	10	54	1449	3	risker_
riskers	11	40	1199	3	riskers
rosery	9	38	1328	3	ros_ery
rusher	9	40	1965	3	rusher_
rushers	10	38	1610	3	rushers
sherd	9	63	2115	3	__sherd
sherry	12	45	1041	3	__sherry
sigher	10	38	1370	3	sigher_
sighers	11	37	1218	3	sighers
silvery	13	32	809	3	silvery
sister	6	44	2158	3	sister_
sisterly	11	4	633	3	sisterly
sisters	7	37	2159	3	sisters
slithery	14	35	670	3	slithery
smithery	16	32	570	3	smithery
sphery	14	31	888	3	_sphery
swisher	13	36	952	3	swisher_
swishers	14	32	805	3	swishers
timbery	14	25	689	3	timbery
tindery	11	38	936	3	tindery
tither	9	49	2028	3	tither_
tithers	10	42	1673	3	tithers
usher	8	45	1776	3	_usher_
ushers	9	44	1553	3	_ushers
vinery	12	49	1260	3	vi_nery
viscera	12	3	508	3	viscera
washer	12	47	2039	3	washer_
washers	13	45	1752	3	washers
wastery	13	46	1099	3	wastery
whiskery	21	31	455	3	whiskery
whispery	19	28	429	3	whispery
wiggery	15	29	587	3	wiggery
winery	12	50	1428	3	wi_nery
wintery	13	39	975	3	wintery
wisely	12	27	1171	3	wis_ely
wiser	8	55	2280	3	wis_er_
wished	13	44	1751	3	wishe_d
wishes	12	49	2095	3	wishe_s
witchery	19	23	609	3	witchery
wither	12	43	2135	3	wither_
withers	13	44	1775	3	withers
zither	18	38	1308	3	zither_
zithern	19	44	702	3	zithern
zithers	19	39	1197	3	zithers

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	267	5.953	22514.2
3	Display Results	267	267	0.093	2871.0
	(SQL Overall)	178691	267	6.452	27695.4