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

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

457 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
mops	8	59	4013	(None)
bops	8	60	3798	1	bops
cops	8	67	5137	1	cops
fops	9	65	3268	1	fops
hops	9	79	4263	1	hops
kops	10	70	3129	1	kops
lops	6	60	4335	1	lops
maps	8	61	4105	1	maps
mips	8	55	3408	1	mips
moas	6	55	4534	1	moas
mobs	8	57	3737	1	mobs
mocs	8	58	3490	1	mocs
mods	7	79	4505	1	mods
mogs	7	54	3933	1	mogs
mols	6	59	4857	1	mols
moms	8	65	3948	1	moms
mons	6	81	5226	1	mons
moos	6	60	5130	1	moos
mop	7	69	5082	1	mop_
mope	8	68	3804	1	mope
mopes	9	51	3498	1	mopes
mopy	11	57	2197	1	mopy
mors	6	59	5006	1	mors
mos	5	70	6712	1	mo_s
moss	6	76	4103	1	moss
mots	6	68	5316	1	mots
mows	9	63	4083	1	mows
oops	6	52	3267	1	oops
ops	5	66	4125	1	_ops
pops	8	63	4095	1	pops
sops	6	52	4456	1	sops
tops	6	62	4812	1	tops
wops	9	66	3415	1	wops
alps	6	55	2924	2	alps
amoks	11	4	1355	2	amoks
amps	8	62	3034	2	amps
apos	6	54	3382	2	apos
apps	8	63	1969	2	apps
asps	6	56	2209	2	asps
baps	8	60	4084	2	baps
boas	6	61	5083	2	boas
bobs	8	63	4065	2	bobs
bods	7	62	4471	2	bods
bogs	7	57	4275	2	bogs
boos	6	79	5503	2	boos
bop	7	75	4948	2	bop_
bos	5	79	6681	2	bo_s
boss	6	59	3834	2	boss
bots	6	64	5395	2	bots
bows	9	62	4286	2	bows
boys	9	67	3733	2	boys
caps	8	71	4789	2	caps
ceps	8	61	2595	2	ceps
chops	12	50	1987	2	chops
clops	9	59	2485	2	clops
cobs	8	70	4314	2	cobs
cods	7	68	4810	2	cods
cogs	7	73	4003	2	cogs
cols	6	65	5308	2	cols
comps	11	55	2605	2	comps
cons	6	60	5769	2	cons
coops	9	62	2964	2	coops
coos	6	74	5649	2	coos
cop	7	111	6237	2	cop_
cope	8	68	4738	2	cope
copes	9	77	4710	2	copes
copse	9	56	2393	2	copse
copy	11	62	2980	2	copy
corps	9	59	2704	2	corps
cors	6	66	5644	2	cors
cos	5	102	7039	2	co_s
coss	6	61	4349	2	coss
cots	6	80	5484	2	cots
coups	9	55	2247	2	coups
cows	9	70	4664	2	cows
coys	9	75	3724	2	coys
crops	9	61	2524	2	crops
cups	8	54	3082	2	cups
daps	7	72	3916	2	daps
dips	7	55	3691	2	dips
docs	7	56	3115	2	docs
does	5	65	5447	2	does
dogs	6	64	4015	2	dogs
dols	5	69	4305	2	dols
doms	7	62	3957	2	doms
dons	5	60	4870	2	dons
dopa	7	72	2090	2	dopa
dopas	8	50	1906	2	dopas
dope	7	60	3889	2	dope
dopes	8	49	3504	2	dopes
dopy	10	62	2415	2	dopy
dorps	8	54	1922	2	dorps
dors	5	67	4760	2	dors
dos	4	80	6231	2	do_s
doss	5	62	3504	2	doss
dots	5	56	4766	2	dots
dows	8	59	4105	2	dows
drops	8	57	1950	2	drops
dups	7	59	2951	2	dups
eons	4	66	3871	2	eons
epos	6	67	2373	2	epos
flops	10	59	2014	2	flops
fobs	9	60	3427	2	fobs
foes	7	65	4344	2	foes
fogs	8	70	3500	2	fogs
fons	7	69	4389	2	fons
fop	8	67	4370	2	fop_
foss	7	64	3164	2	foss
foys	10	56	2829	2	foys
gaps	7	60	4297	2	gaps
gips	7	56	3292	2	gips
glops	8	56	1955	2	glops
goas	5	52	3994	2	goas
gobs	7	69	3557	2	gobs
gods	6	54	3804	2	gods
goes	5	56	4409	2	goes
goops	8	66	2096	2	goops
goos	5	76	4491	2	goos
gorps	8	53	1699	2	gorps
gos	4	71	5513	2	go_s
goys	8	63	2841	2	goys
gyps	10	51	1502	2	gyps
haps	9	64	4346	2	haps
hips	9	64	3370	2	hips
hobs	9	70	3898	2	hobs
hods	8	72	3986	2	hods
hoes	7	57	5573	2	hoes
hogs	8	71	3966	2	hogs
hols	7	69	4629	2	hols
hons	7	73	5078	2	hons
hoops	10	56	2107	2	hoops
hop	8	75	5459	2	hop_
hope	9	66	3967	2	hope
hopes	10	58	3564	2	hopes
hos	6	83	6419	2	ho_s
hots	7	83	4933	2	hots
hows	10	63	4560	2	hows
hoys	10	77	3393	2	hoys
hyps	12	54	1841	2	hyps
imps	8	62	2112	2	imps
ions	4	67	3785	2	ions
jobs	13	65	2943	2	jobs
joes	11	66	3589	2	joes
jogs	12	71	2933	2	jogs
joss	11	59	2559	2	joss
jots	11	63	3614	2	jots
jows	14	66	3209	2	jows
joys	14	66	2466	2	joys
keps	10	60	2730	2	keps
kips	10	64	3052	2	kips
knops	11	59	1181	2	knops
koas	8	56	3509	2	koas
kobs	10	58	3108	2	kobs
kois	8	51	2940	2	kois
kop	9	74	4020	2	kop_
koph	13	58	1654	2	koph
kophs	14	50	1093	2	kophs
kors	8	59	3301	2	kors
kos	7	69	4482	2	ko_s
koss	8	52	2481	2	koss
laps	6	68	4887	2	laps
lips	6	71	4144	2	lips
lobs	6	64	4108	2	lobs
logs	5	73	4311	2	logs
loops	7	57	2396	2	loops
loos	4	90	5112	2	loos
lop	5	82	5531	2	lop_
lope	6	59	4192	2	lope
lopes	7	64	3734	2	lopes
loss	4	53	3796	2	loss
lots	4	76	5209	2	lots
loups	7	53	1962	2	loups
lows	7	58	4301	2	lows
macs	8	67	4251	2	macs
mads	7	68	4537	2	mads
maes	6	69	4840	2	maes
mags	7	54	4453	2	mags
mans	6	63	5455	2	mans
map	7	72	5512	2	map_
mars	6	62	6187	2	mars
mas	5	81	7582	2	m_as
mass	6	60	4494	2	mass
mats	6	54	6029	2	mats
maws	9	64	3714	2	maws
mays	9	69	4003	2	mays
meds	7	57	3536	2	meds
megs	7	55	3063	2	megs
mels	6	59	4153	2	mels
mems	8	59	3150	2	mems
meous	7	61	2006	2	meous
meows	10	46	1268	2	meows
mess	6	59	3243	2	mess
mews	9	66	2933	2	mews
mhos	9	55	1777	2	mhos
mibs	8	53	3048	2	mibs
mics	8	74	3515	2	mics
mids	7	65	4179	2	mids
migs	7	69	3532	2	migs
mils	6	60	4533	2	mils
mirs	6	69	4057	2	mirs
mis	5	81	6262	2	m_is
miss	6	53	3942	2	miss
mo	4	91	5848	2	mo__
moa	5	72	4918	2	mo_a
moan	6	58	3202	2	moan
moans	7	46	2437	2	moans
moat	6	63	5203	2	moat
moats	7	58	2764	2	moats
mob	7	86	5192	2	mo_b
moc	7	78	4508	2	mo_c
mock	12	64	2944	2	mock
mocks	13	50	2382	2	mocks
mod	6	90	5440	2	mo_d
mode	7	58	4030	2	mode
modes	8	55	3741	2	modes
modi	7	68	2631	2	modi
modus	8	54	1720	2	modus
mog	6	69	4967	2	mo_g
moil	6	55	3409	2	moil
moils	7	61	2575	2	moils
moist	7	60	3358	2	moist
mojo	13	69	1722	2	mojo
mojos	14	53	1446	2	mojos
moke	10	62	3422	2	moke
mokes	11	46	3103	2	mokes
mol	5	66	5459	2	mo_l
mola	6	60	3563	2	mola
molas	7	51	3209	2	molas
mold	7	60	3433	2	mold
molds	8	53	2483	2	molds
mole	6	62	5183	2	mole
moles	7	47	4792	2	moles
moll	6	67	3570	2	moll
molls	7	51	2978	2	molls
molt	6	63	5616	2	molt
molts	7	60	3209	2	molts
moly	9	60	3191	2	moly
mom	7	88	5316	2	mo_m
mome	8	52	3935	2	mome
momes	9	51	3447	2	momes
momi	8	75	2448	2	momi
momus	9	61	1611	2	momus
mon	5	75	6158	2	mo_n
monas	7	47	3215	2	monas
monk	10	59	2852	2	monk
monks	11	61	2339	2	monks
mono	6	60	3672	2	mono
monos	7	59	3086	2	monos
mony	9	68	3001	2	mony
moo	5	84	6051	2	mo_o
mood	7	63	3206	2	mood
moods	8	52	2462	2	moods
mool	6	75	3386	2	mool
mools	7	60	2717	2	mools
moon	6	71	4081	2	moon
moons	7	53	3100	2	moons
moor	6	66	2855	2	moor
moors	7	49	2314	2	moors
moose	7	63	2719	2	moose
moot	6	76	5362	2	moot
moots	7	58	3166	2	moots
moped	10	54	2473	2	moped
mopeds	11	49	966	2	mopeds
moper	9	49	2592	2	moper
mopers	10	42	2037	2	mopers
mopey	12	48	2182	2	mopey
mopish	13	43	1159	2	mopish
mor	5	68	5500	2	mo_r
mora	6	66	4127	2	mora
moras	7	64	3878	2	moras
more	6	71	5452	2	more
mores	7	62	4964	2	mores
morn	6	62	3756	2	morn
morns	7	55	2744	2	morns
morph	12	17	1251	2	morph
morphs	13	14	943	2	morphs
morse	7	60	3270	2	morse
mort	6	67	5883	2	mort
morts	7	55	3356	2	morts
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
mot	5	72	7942	2	mo_t
mote	6	70	4808	2	mote
motes	7	59	4400	2	motes
moth	9	67	3133	2	moth
moths	10	60	2155	2	moths
mott	6	66	4844	2	mott
motts	7	65	2700	2	motts
moue	6	58	3557	2	moue
moues	7	57	3284	2	moues
mouse	7	71	3300	2	mouse
mousy	10	67	1694	2	mousy
move	9	66	3072	2	move
moves	10	61	2842	2	moves
mow	8	66	5035	2	mo_w
mown	9	54	2444	2	mown
moxa	13	69	1774	2	moxa
moxas	14	50	1440	2	moxas
mozo	15	77	1974	2	mozo
mozos	16	55	1633	2	mozos
muds	7	55	3065	2	muds
mugs	7	62	3204	2	mugs
mumps	11	56	1910	2	mumps
mums	8	57	3277	2	mums
muns	6	55	3592	2	muns
muons	7	58	1617	2	muons
mus	5	59	4675	2	m_us
muss	6	49	3376	2	muss
muts	6	48	3998	2	muts
mycs	11	53	1429	2	mycs
myope	12	40	1097	2	myope
myopes	13	41	996	2	myopes
myopy	15	45	735	2	myopy
naps	6	62	3858	2	naps
nips	6	58	3092	2	nips
nobs	6	64	3690	2	nobs
nods	5	58	3822	2	nods
noes	4	58	4539	2	noes
nogs	5	65	3461	2	nogs
noms	6	56	3640	2	noms
nope	6	59	3419	2	nope
nos	3	88	5932	2	no_s
nous	4	61	3698	2	nous
nows	7	57	3823	2	nows
ods	4	75	4621	2	_ods
oes	3	58	6619	2	_oes
ohs	6	62	3231	2	_ohs
oms	5	63	3751	2	_oms
ons	3	61	4851	2	_ons
oohs	7	52	2069	2	oohs
oots	4	64	4644	2	oots
op	4	58	5016	2	_op_
ope	5	68	4524	2	_ope
opes	6	59	4261	2	_opes
opt	5	75	4554	2	_opt
opts	6	81	2474	2	_opts
opus	6	64	2059	2	_opus
ors	3	57	5011	2	_ors
os	2	113	5988	2	_o_s
paps	8	64	4345	2	paps
peps	8	51	3451	2	peps
pips	8	58	3713	2	pips
plops	9	59	2033	2	plops
pods	7	65	4015	2	pods
pois	6	65	3904	2	pois
pols	6	60	4456	2	pols
pomps	11	53	1619	2	pomps
poms	8	70	3774	2	poms
pons	6	58	5060	2	pons
poops	9	44	2241	2	poops
poos	6	59	4911	2	poos
pop	7	62	5225	2	pop_
pope	8	55	3561	2	pope
popes	9	59	3381	2	popes
popsy	12	57	1340	2	popsy
pots	6	64	5236	2	pots
pows	9	55	3766	2	pows
props	9	57	2688	2	props
pups	8	60	3223	2	pups
qoph	18	59	1194	2	qoph
qophs	19	50	781	2	qophs
raps	6	62	4773	2	raps
reps	6	59	3795	2	reps
rips	6	62	3743	2	rips
robs	6	58	3787	2	robs
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5414	2	roes
romps	9	46	1754	2	romps
roms	6	70	3896	2	roms
rope	6	55	4291	2	rope
ropes	7	59	4006	2	ropes
ropy	9	63	2341	2	ropy
rots	4	64	5409	2	rots
roups	7	51	1890	2	roups
rows	7	59	4175	2	rows
saps	6	53	4637	2	saps
scops	9	58	2019	2	scops
shops	10	42	2290	2	shops
sips	6	57	4010	2	sips
slops	7	50	2601	2	slops
smogs	8	51	1216	2	smogs
soaps	7	51	2071	2	soaps
sobs	6	49	4175	2	sobs
sods	5	49	4021	2	sods
sols	4	54	4816	2	sols
soms	6	62	3937	2	soms
sons	4	60	4955	2	sons
sop	5	75	5786	2	sop_
soph	9	70	2420	2	soph
sophs	10	49	1602	2	sophs
sos	3	77	6160	2	so_s
sots	4	55	5245	2	sots
soups	7	53	2294	2	soups
sous	4	69	4721	2	sous
sows	7	53	4249	2	sows
soys	7	52	3393	2	soys
stops	7	48	2728	2	stops
sups	6	48	3443	2	sups
swops	10	59	1397	2	swops
taps	6	60	5068	2	taps
tips	6	64	3676	2	tips
tods	5	61	4184	2	tods
toes	4	69	5644	2	toes
togs	5	72	4243	2	togs
toms	6	83	4349	2	toms
tons	4	65	5305	2	tons
top	5	105	6068	2	top_
tope	6	59	4638	2	tope
topes	7	69	4176	2	topes
toph	9	63	2687	2	toph
tophs	10	52	2005	2	tophs
topi	6	78	3039	2	topi
topis	7	60	2583	2	topis
topo	6	69	3240	2	topo
topos	7	57	2639	2	topos
tors	4	61	5738	2	tors
toss	4	56	3797	2	toss
tots	4	66	5412	2	tots
tows	7	85	4555	2	tows
toys	7	80	3634	2	toys
tups	6	56	2876	2	tups
umps	8	57	2194	2	umps
ups	5	56	2905	2	_ups
urps	6	69	2048	2	urps
voes	7	54	3282	2	voes
vows	10	66	2694	2	vows
waps	9	66	4208	2	waps
whops	13	50	1393	2	whops
woes	7	64	4066	2	woes
wogs	8	65	3140	2	wogs
woks	11	62	2490	2	woks
wons	7	49	4204	2	wons
woops	10	49	1752	2	woops
woos	7	62	3880	2	woos
wop	8	71	4513	2	wop_
wos	6	69	5353	2	wo_s
wots	7	63	4289	2	wots
wows	10	46	3349	2	wows
yaps	9	59	3352	2	yaps
yeps	9	59	2440	2	yeps
yips	9	52	2670	2	yips
yobs	9	60	2808	2	yobs
yods	8	65	3118	2	yods
yoks	11	62	2374	2	yoks
yous	7	62	3065	2	yous
yows	10	64	3312	2	yows
yups	9	61	2160	2	yups
zaps	15	68	2689	2	zaps
zeps	15	60	1934	2	zeps
zips	15	57	2379	2	zips
zoos	13	58	2880	2	zoos

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.280	638182.1
2	DLD Change Limit	29872	457	0.860	34734.9
3	Display Results	457	457	0.110	4154.5
	(SQL Overall)	178691	457	1.250	142952.8