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

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

466 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
hops	9	79	4263	(None)
bops	8	60	3798	1	bops
chops	12	50	1987	1	chops
cops	8	67	5137	1	cops
fops	9	65	3268	1	fops
haps	9	64	4346	1	haps
hips	9	64	3370	1	hips
hobs	9	70	3898	1	hobs
hods	8	72	3986	1	hods
hoes	7	57	5573	1	hoes
hogs	8	71	3966	1	hogs
hols	7	69	4629	1	hols
hons	7	73	5078	1	hons
hoops	10	56	2107	1	hoops
hop	8	75	5459	1	hop_
hope	9	66	3967	1	hope
hopes	10	58	3564	1	hopes
hos	6	83	6419	1	ho_s
hots	7	83	4933	1	hots
hows	10	63	4560	1	hows
hoys	10	77	3393	1	hoys
hyps	12	54	1841	1	hyps
kops	10	70	3129	1	kops
lops	6	60	4335	1	lops
mops	8	59	4013	1	mops
oops	6	52	3267	1	oops
ops	5	66	4125	1	_ops
pops	8	63	4095	1	pops
shops	10	42	2290	1	shops
sops	6	52	4456	1	sops
tops	6	62	4812	1	tops
whops	13	50	1393	1	whops
wops	9	66	3415	1	wops
alps	6	55	2924	2	alps
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
chaps	12	53	2606	2	chaps
chips	12	57	2125	2	chips
chomps	15	51	1222	2	chomps
chop	11	60	2492	2	chop_
chows	13	56	1820	2	chows
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	2392	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	2523	2	crops
cups	8	54	3082	2	cups
daps	7	72	3916	2	daps
dhows	12	59	1122	2	dhows
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
haes	7	76	5102	2	haes
hags	8	67	4084	2	hags
hahs	10	83	3336	2	hahs
hams	9	64	4613	2	hams
hap	8	73	6005	2	hap_
harps	10	59	2687	2	harps
has	6	73	7265	2	h_as
hasp	9	66	2729	2	hasp
hasps	10	51	1464	2	hasps
hats	7	68	5825	2	hats
haws	10	64	3944	2	haws
hays	10	61	3807	2	hays
heaps	10	52	2322	2	heaps
hehs	10	67	2396	2	hehs
helps	10	52	1934	2	helps
hemps	12	69	1733	2	hemps
hems	9	55	3494	2	hems
hens	7	56	4257	2	hens
hep	8	66	4414	2	hep_
hers	7	58	4487	2	hers
hes	6	66	5420	2	h_es
hets	7	55	4720	2	hets
hews	10	56	3157	2	hews
hies	7	48	4283	2	hies
hims	9	52	3097	2	hims
hins	7	64	4799	2	hins
hip	8	67	5043	2	hip_
his	6	63	5950	2	h_is
hiss	7	56	2921	2	hiss
hits	7	55	4513	2	hits
ho	5	102	5827	2	ho__
hoar	7	67	2916	2	hoar
hoars	8	59	2555	2	hoars
hoax	14	77	1829	2	hoax
hob	8	75	5092	2	ho_b
hobo	9	70	2608	2	hobo
hobos	10	63	2135	2	hobos
hock	13	60	3130	2	hock
hocks	14	49	2549	2	hocks
hocus	10	47	1520	2	hocus
hod	7	68	5246	2	ho_d
hoe	6	75	6272	2	ho_e
hoed	8	78	3798	2	hoed
hoer	7	65	3398	2	hoer
hoers	8	57	2492	2	hoers
hog	7	80	4906	2	ho_g
hogg	9	66	1753	2	hogg
hoggs	10	72	1246	2	hoggs
hoise	8	52	2477	2	hoise
hoist	8	64	3321	2	hoist
hoke	11	59	3593	2	hoke
hokes	12	62	3164	2	hokes
hold	8	62	3506	2	hold
holds	9	46	2324	2	holds
hole	7	75	5339	2	hole
holes	8	47	4865	2	holes
holk	11	60	2794	2	holk
holks	12	47	2056	2	holks
holm	9	56	2811	2	holm
holms	10	51	1780	2	holms
holp	9	57	2755	2	holp
holt	7	78	5258	2	holt
holts	8	56	2791	2	holts
holy	10	63	3343	2	holy
home	9	80	4244	2	home
homes	10	69	3881	2	homes
homo	9	61	2647	2	homo
homos	10	59	2178	2	homos
homy	12	66	2322	2	homy
hon	6	77	5938	2	ho_n
hone	7	75	4932	2	hone
hones	8	81	4449	2	hones
hong	8	58	3395	2	hong
hongs	9	51	2620	2	hongs
honk	11	69	3119	2	honk
honks	12	51	2452	2	honks
hood	8	51	3233	2	hood
hoods	9	51	2408	2	hoods
hoof	10	60	3658	2	hoof
hoofs	11	57	2104	2	hoofs
hook	11	61	3328	2	hook
hooks	12	50	2712	2	hooks
hoop	9	61	2998	2	hoop
hoot	7	57	5210	2	hoot
hoots	8	48	3025	2	hoots
hoped	11	56	2818	2	hoped
hoper	10	58	2914	2	hoper
hopers	11	42	2297	2	hopers
hoppy	15	49	1235	2	hoppy
hora	7	61	3656	2	hora
horas	8	63	3310	2	horas
horn	7	67	3561	2	horn
horns	8	61	2533	2	horns
horse	8	61	3265	2	horse
horst	8	58	3351	2	horst
horsy	11	63	1839	2	horsy
hose	7	65	4724	2	hose
hoses	8	54	4317	2	hoses
host	7	78	5283	2	host
hosts	8	55	2670	2	hosts
hot	6	77	7606	2	ho_t
hour	7	58	2731	2	hour
hours	8	54	2239	2	hours
house	8	91	3142	2	house
hove	10	71	3222	2	hove
how	9	72	5243	2	ho_w
howe	10	67	3410	2	howe
howes	11	47	3026	2	howes
howf	13	61	2720	2	howf
howfs	14	48	1450	2	howfs
howk	14	52	2196	2	howk
howks	15	50	1685	2	howks
howl	10	76	2569	2	howl
howls	11	62	1922	2	howls
hoy	9	74	4791	2	ho_y
hoya	10	74	1837	2	hoya
hoyas	11	50	1616	2	hoyas
hubs	9	60	2714	2	hubs
hues	7	52	3523	2	hues
hugs	8	61	2975	2	hugs
humps	12	63	2280	2	humps
hums	9	68	3142	2	hums
huns	7	61	3693	2	huns
hup	8	64	3781	2	hup_
huts	7	67	3744	2	huts
hyp	11	78	2246	2	hyp_
hype	12	55	1981	2	hype
hypes	13	58	1867	2	hypes
hypo	12	75	1635	2	hypo
hypos	13	120	1474	2	hypos
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
maps	8	61	4105	2	maps
mhos	9	55	1777	2	mho_s
mips	8	55	3408	2	mips
moas	6	55	4534	2	moas
mobs	8	57	3737	2	mobs
mocs	8	58	3490	2	mocs
mods	7	79	4505	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
mop	7	69	5082	2	mop_
mope	8	68	3804	2	mope
mopes	9	51	3498	2	mopes
mopy	11	57	2197	2	mopy
mors	6	59	5006	2	mors
mos	5	70	6712	2	mo_s
moss	6	76	4103	2	moss
mots	6	68	5316	2	mots
mows	9	63	4083	2	mows
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
ohms	9	55	1403	2	ohms
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
phons	10	52	2114	2	phons
phots	10	54	1850	2	phots
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
rhos	7	63	1906	2	rho_s
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
ships	10	51	2377	2	ships
shoes	8	54	2966	2	shoes
shogs	9	53	1971	2	shogs
shoos	8	42	2636	2	shoos
shop	9	56	2984	2	shop_
shots	8	47	3085	2	shots
shows	11	53	2458	2	shows
sips	6	57	4010	2	sips
slops	7	50	2601	2	slops
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	5067	2	taps
thorps	11	36	1089	2	thorps
thous	8	60	1726	2	thous
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
whaps	13	51	1516	2	whaps
whips	13	49	1708	2	whips
whomps	16	45	760	2	whomps
whoops	14	48	786	2	whoops
whop	12	55	2092	2	whop_
whups	13	42	1000	2	whups
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.263	679433.5
2	DLD Change Limit	29872	466	0.876	34100.5
3	Display Results	466	466	0.110	4236.4
	(SQL Overall)	178691	466	1.249	143067.3