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

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

380 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
mess	6	59	3243	(None)
cess	6	53	2605	1	cess
ess	3	60	3088	1	_ess
fess	7	65	2916	1	fess
jess	11	60	2203	1	jess
less	4	56	3510	1	less
mass	6	60	4494	1	mass
meds	7	57	3537	1	meds
megs	7	55	3063	1	megs
mels	6	59	4153	1	mels
mems	8	59	3150	1	mems
mesa	6	70	2548	1	mesa
mesas	7	68	2320	1	mesas
mesh	9	68	2300	1	mesh
messy	10	49	1383	1	messy
mews	9	66	2933	1	mews
miss	6	53	3943	1	miss
moss	6	76	4103	1	moss
muss	6	49	3376	1	muss
ness	4	55	2656	1	ness
amass	7	71	1968	2	amass
amens	7	56	2484	2	amens
amiss	7	58	2307	2	amiss
ass	3	78	4406	2	_ass
bass	6	61	4678	2	bass
beds	7	59	3779	2	beds
bees	6	54	5338	2	bees
begs	7	57	3383	2	begs
bels	6	61	4249	2	bels
bens	6	59	4570	2	bens
bes	5	65	5743	2	be_s
beses	7	58	3072	2	beses
best	6	63	5532	2	best
bests	7	59	3261	2	bests
bets	6	70	5144	2	bets
beys	9	138	2955	2	beys
bless	7	59	1781	2	bless
boss	6	59	3834	2	boss
buss	6	51	3491	2	buss
cees	6	59	4159	2	cees
cels	6	55	3497	2	cels
ceps	8	61	2595	2	ceps
chess	10	50	1692	2	chess
coss	6	61	4349	2	coss
cress	7	50	2283	2	cress
cuss	6	54	3061	2	cuss
debs	7	65	3024	2	debs
dees	5	63	5663	2	dees
dels	5	67	4547	2	dels
dens	5	59	4507	2	dens
desk	9	56	1890	2	desk
desks	10	59	1307	2	desks
devs	8	64	2403	2	devs
dews	8	62	3060	2	dews
deys	8	50	2747	2	deys
diss	5	64	3449	2	diss
doss	5	62	3504	2	doss
dress	6	53	1983	2	dress
eds	4	66	3893	2	_eds
eels	4	65	3674	2	eels
efs	6	68	2960	2	_efs
els	3	76	4572	2	_els
emes	6	54	3466	2	emes
emeses	8	61	1496	2	emeses
emesis	8	47	1262	2	emesis
emeus	7	69	1333	2	emeus
ems	5	64	3549	2	_ems
emus	6	68	2168	2	emus
ens	3	72	4592	2	_ens
ers	3	60	4628	2	_ers
es	2	90	4822	2	_e_s
eses	4	53	3610	2	_eses
feds	8	52	3432	2	feds
fees	7	64	5060	2	fees
fehs	10	65	2238	2	fehs
fems	9	64	2870	2	fems
fens	7	61	3976	2	fens
fes	6	65	5167	2	fe_s
fesse	8	61	1633	2	fesse
fest	7	49	4944	2	fest
fests	8	58	2804	2	fests
fets	7	53	4594	2	fets
feus	7	58	3075	2	feus
foss	7	64	3164	2	foss
fuss	7	60	2793	2	fuss
geds	6	67	3082	2	geds
gees	5	56	4788	2	gees
gels	5	68	3610	2	gels
gems	7	53	2911	2	gems
gens	5	57	4007	2	gens
gesso	6	4	960	2	gesso
gest	5	61	4913	2	gest
gests	6	60	2881	2	gests
gets	5	54	4248	2	gets
guess	6	42	1336	2	guess
hehs	10	67	2396	2	hehs
hems	9	55	3494	2	hems
hens	7	56	4257	2	hens
hers	7	58	4487	2	hers
hes	6	66	5420	2	he_s
hest	7	59	5077	2	hest
hests	8	58	2993	2	hests
hets	7	55	4720	2	hets
hews	10	56	3157	2	hews
hiss	7	56	2922	2	hiss
jees	11	59	3854	2	jees
jesse	12	60	1283	2	jesse
jest	11	67	3850	2	jest
jests	12	59	2245	2	jests
jets	11	58	3410	2	jets
jews	14	58	2208	2	jews
joss	11	59	2559	2	joss
keas	8	63	3710	2	keas
kefs	11	59	2275	2	kefs
kegs	9	58	2403	2	kegs
kens	8	54	3524	2	kens
keps	10	60	2731	2	keps
keys	11	63	2217	2	keys
kiss	8	52	2741	2	kiss
koss	8	52	2482	2	koss
lass	4	74	4454	2	lass
leas	4	59	5418	2	leas
lees	4	54	5588	2	lees
legs	5	61	3369	2	legs
leis	4	57	3960	2	leis
leks	8	54	2760	2	leks
lens	4	61	4649	2	lens
les	3	56	6307	2	le_s
leses	5	49	3081	2	leses
lest	4	69	5632	2	lest
lets	4	71	4794	2	lets
leys	7	64	3018	2	leys
loess	5	57	1470	2	loess
loss	4	53	3796	2	loss
macs	8	67	4251	2	macs
mads	7	68	4538	2	mads
maes	6	69	4840	2	maes
mags	7	54	4453	2	mags
mans	6	63	5455	2	mans
maps	8	61	4105	2	maps
mars	6	62	6187	2	mars
mas	5	81	7582	2	m_as
masa	6	50	3472	2	masa
masas	7	56	3041	2	masas
mash	9	60	3940	2	mash
mask	10	52	2736	2	mask
masks	11	53	2053	2	masks
massa	7	55	1892	2	massa
masse	7	51	2529	2	masse
massy	10	45	1896	2	massy
mast	6	59	5996	2	mast
masts	7	70	3576	2	masts
mats	6	54	6029	2	mats
maws	9	64	3714	2	maws
mays	9	69	4003	2	mays
me	4	77	4833	2	me__
mead	7	55	3160	2	mead
meads	8	54	2532	2	meads
meal	6	56	4317	2	meal
meals	7	59	3338	2	meals
mean	6	55	3809	2	mean
means	7	58	3123	2	means
meat	6	63	5960	2	meat
meats	7	50	3405	2	meats
med	6	61	4675	2	me_d
meed	7	49	3470	2	meed
meeds	8	49	2027	2	meeds
meek	10	56	2483	2	meek
meet	6	53	5055	2	meet
meets	7	42	2461	2	meets
meg	6	60	4095	2	me_g
mega	7	76	2087	2	mega
megass	9	21	944	2	megass
mel	5	60	4748	2	me_l
meld	7	58	3047	2	meld
melds	8	48	2238	2	melds
mell	6	49	3561	2	mell
mells	7	50	3133	2	mells
melt	6	57	5289	2	melt
melts	7	49	3010	2	melts
mem	7	79	4347	2	me_m
meme	8	53	3055	2	meme
memes	9	49	2770	2	memes
memo	8	59	2479	2	memo
memos	9	57	1911	2	memos
men	5	92	5285	2	me_n
mend	7	53	3403	2	mend
mends	8	49	2769	2	mends
meno	6	60	3136	2	meno
mensa	7	53	1867	2	mensa
mensas	8	51	1586	2	mensas
mense	7	50	2563	2	mense
menses	8	42	2245	2	menses
mensh	10	54	1356	2	mensh
menu	6	51	3023	2	menu
menus	7	58	2284	2	menus
meou	6	53	2586	2	meou
meous	7	61	2006	2	meous
meow	9	51	1788	2	meow
meows	10	46	1268	2	meows
merc	8	72	2562	2	merc
mercs	9	60	2045	2	mercs
mere	6	72	4444	2	mere
meres	7	51	4357	2	meres
merk	10	60	2794	2	merk
merks	11	47	2240	2	merks
merl	6	58	3097	2	merl
merls	7	74	2390	2	merls
meshes	11	50	1944	2	meshes
meshy	13	56	1278	2	meshy
mesic	9	36	1786	2	mesic
mesne	7	51	1629	2	mesne
mesnes	8	52	1621	2	mesnes
meson	7	41	1831	2	meson
mesons	8	32	1584	2	mesons
messan	8	39	1206	2	messan
messed	9	50	1818	2	messed
messes	8	49	2434	2	messes
met	5	60	7243	2	me_t
meta	6	59	3241	2	meta
mete	6	44	3813	2	mete
metes	7	47	3621	2	metes
meth	9	58	2784	2	meth
meths	10	53	2023	2	meths
metis	7	50	2590	2	metis
mew	8	61	3773	2	me_w
mewl	9	56	1832	2	mewl
mewls	10	58	1323	2	mewls
meze	15	44	2090	2	meze
mezes	16	77	1926	2	mezes
mhos	9	55	1777	2	mhos
mibs	8	53	3049	2	mibs
mics	8	74	3516	2	mics
mids	7	65	4180	2	mids
miens	7	61	1830	2	miens
migs	7	69	3533	2	migs
mils	6	60	4534	2	mils
mips	8	55	3409	2	mips
mirs	6	69	4058	2	mirs
mis	5	81	6263	2	m_is
mise	6	60	4359	2	mise
mises	7	47	4056	2	mises
miso	6	72	2991	2	miso
misos	7	65	2329	2	misos
missy	10	56	1756	2	missy
mist	6	61	5454	2	mist
mists	7	66	3390	2	mists
moas	6	55	4534	2	moas
mobs	8	57	3737	2	mobs
mocs	8	58	3490	2	mocs
mods	7	79	4506	2	mods
mogs	7	54	3933	2	mogs
mols	6	59	4857	2	mols
moms	8	65	3948	2	moms
mons	6	81	5226	2	mons
moos	6	60	5130	2	moos
mops	8	59	4013	2	mops
mors	6	59	5006	2	mors
mos	5	70	6712	2	m_os
mosh	9	52	2760	2	mosh
mosk	10	56	2244	2	mosk
mosks	11	61	1700	2	mosks
mosso	7	47	1518	2	mosso
mossy	10	52	1706	2	mossy
most	6	65	5420	2	most
mosts	7	60	2854	2	mosts
mots	6	68	5316	2	mots
mows	9	63	4083	2	mows
muds	7	55	3066	2	muds
mugs	7	62	3204	2	mugs
mums	8	57	3277	2	mums
muns	6	55	3592	2	muns
mus	5	59	4675	2	m_us
muse	6	71	3603	2	muse
muses	7	51	3430	2	muses
mush	9	49	2912	2	mush
musk	10	45	2619	2	musk
musks	11	61	1964	2	musks
mussy	10	41	1764	2	mussy
must	6	51	4544	2	must
musts	7	55	2744	2	musts
muts	6	48	3998	2	muts
mycs	11	53	1429	2	mycs
nebs	6	61	2498	2	nebs
negs	5	57	2736	2	negs
nest	4	55	4873	2	nest
nests	5	57	2800	2	nests
nets	4	59	4153	2	nets
news	7	61	2737	2	news
oes	3	58	6619	2	oe_s
omens	7	56	1896	2	omens
omers	7	69	2319	2	omers
oses	4	66	4151	2	oses
pass	6	52	3995	2	pass
peas	6	57	5506	2	peas
pecs	8	46	3410	2	pecs
peds	7	58	3525	2	peds
pees	6	52	5737	2	pees
pegs	7	55	3176	2	pegs
pehs	9	56	2576	2	pehs
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
pes	5	72	5978	2	pe_s
peso	6	69	2582	2	peso
pesos	7	72	2162	2	pesos
pest	6	55	5529	2	pest
pests	7	59	3327	2	pests
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
piss	6	50	3334	2	piss
press	7	54	2595	2	press
puss	6	48	3013	2	puss
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4287	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
reps	6	59	3795	2	reps
res	3	55	6504	2	re_s
resh	7	65	2345	2	resh
rest	4	64	5984	2	rest
rests	5	49	3587	2	rests
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
sass	4	50	3562	2	sass
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sels	4	63	4598	2	sels
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
sews	7	58	3602	2	sews
smews	10	46	1229	2	smews
suss	4	52	2930	2	suss
tass	4	56	4057	2	tass
teas	4	58	5149	2	teas
teds	5	49	3258	2	teds
tees	4	53	5358	2	tees
tegs	5	60	3149	2	tegs
tels	4	68	4169	2	tels
tens	4	56	4741	2	tens
test	4	86	5162	2	test
tests	5	65	3019	2	tests
tets	4	58	4746	2	tets
tews	7	64	3164	2	tews
tmeses	8	57	1224	2	tmeses
tmesis	8	52	979	2	tmesis
toss	4	56	3797	2	toss
tress	5	54	2316	2	tress
uses	4	49	3111	2	uses
vees	7	54	3943	2	vees
vest	7	57	4360	2	vest
vests	8	53	2598	2	vests
vets	7	68	3509	2	vets
webs	9	66	2212	2	webs
weds	8	66	2894	2	weds
wees	7	62	4912	2	wees
wens	7	63	3793	2	wens
west	7	57	4808	2	west
wests	8	57	2700	2	wests
wets	7	59	4029	2	wets
wiss	7	56	3055	2	wiss
wuss	7	52	1933	2	wuss
yeas	7	86	3842	2	yeas
yens	7	58	3226	2	yens
yeps	9	59	2440	2	yeps
yes	6	62	5061	2	ye_s
yeses	8	51	1932	2	yeses
yews	10	53	2396	2	yews
zeds	14	58	2181	2	zeds
zees	13	63	3189	2	zees
zeks	17	58	1506	2	zeks
zeps	15	60	1934	2	zeps
zest	13	60	3570	2	zest
zests	14	54	1974	2	zests

Search took 2 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	29872	0.313	570897.8
2	DLD Change Limit	29872	380	0.920	32469.6
3	Display Results	380	380	0.096	3958.3
	(SQL Overall)	178691	380	1.329	134455.2