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

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

544 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
haps	9	64	4346	(None)
baps	8	60	4084	1	baps
caps	8	71	4789	1	caps
chaps	12	53	2606	1	chaps
daps	7	72	3916	1	daps
gaps	7	60	4297	1	gaps
haes	7	76	5102	1	haes
hags	8	67	4084	1	hags
hahs	10	83	3336	1	hahs
hams	9	64	4613	1	hams
hap	8	73	6005	1	hap_
harps	10	59	2687	1	harps
has	6	73	7265	1	ha_s
hasp	9	66	2729	1	hasp
hasps	10	51	1464	1	hasps
hats	7	68	5825	1	hats
haws	10	64	3944	1	haws
hays	10	61	3807	1	hays
heaps	10	52	2322	1	heaps
hips	9	64	3370	1	hips
hops	9	79	4263	1	hops
hyps	12	54	1841	1	hyps
laps	6	68	4887	1	laps
maps	8	61	4105	1	maps
naps	6	62	3858	1	naps
paps	8	64	4345	1	paps
raps	6	62	4773	1	raps
saps	6	53	4637	1	saps
taps	6	60	5067	1	taps
waps	9	66	4208	1	waps
whaps	13	51	1516	1	whaps
yaps	9	59	3352	1	yaps
zaps	15	68	2689	1	zaps
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	_aas
abs	5	93	5607	2	_abs
ads	4	97	5573	2	_ads
ags	4	75	5166	2	_ags
ahis	7	61	3538	2	ahis
ahs	6	86	4482	2	_ahs
ais	3	90	8357	2	_ais
alps	6	55	2924	2	alps
als	3	66	6302	2	_als
amps	8	62	3034	2	amps
ape	5	72	5118	2	_ape
apes	6	60	4743	2	_apes
apo	5	111	4212	2	_apo
apos	6	54	3382	2	_apos
app	7	68	2760	2	_app
apps	8	63	1969	2	apps
apse	6	77	2538	2	_apse
apt	5	73	5254	2	_apt
ars	3	76	7093	2	_ars
as	2	110	8307	2	_a_s
asp	5	72	3534	2	_asp
asps	6	56	2209	2	asps
ass	3	78	4406	2	_ass
ataps	7	64	1483	2	ataps
ays	6	70	5029	2	_ays
baas	6	68	4467	2	baas
bads	7	70	4886	2	bads
bags	7	66	4550	2	bags
bals	6	63	5404	2	bals
bams	8	70	4445	2	bams
bans	6	65	5514	2	bans
bap	7	64	5584	2	bap_
bars	6	65	6409	2	bars
bas	5	86	8175	2	ba_s
bass	6	61	4678	2	bass
bats	6	69	6233	2	bats
bays	9	71	4391	2	bays
bops	8	60	3798	2	bops
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
camps	11	63	3026	2	camps
cams	8	70	4728	2	cams
cans	6	50	5085	2	cans
cap	7	67	5898	2	cap_
cape	8	72	4278	2	cape
capes	9	54	4192	2	capes
caph	11	66	2329	2	caph
caphs	12	45	1537	2	caphs
capo	8	58	2921	2	capo
capos	9	48	2607	2	capos
carps	9	69	3225	2	carps
cars	6	73	6476	2	cars
cats	6	63	5634	2	cats
caws	9	60	3611	2	caws
cays	9	54	3767	2	cays
ceps	8	61	2595	2	ceps
chads	11	61	2223	2	chads
chais	10	75	3031	2	chais
champs	15	49	1568	2	champs
chams	12	60	2850	2	chams
chaos	10	56	2286	2	chaos
chap	11	49	2849	2	chap_
chape	12	52	2114	2	chape
chapes	13	54	2187	2	chapes
chapt	12	58	2764	2	chapt
chars	10	59	3664	2	chars
chats	10	57	3009	2	chats
chaws	13	50	2246	2	chaws
chays	13	53	1974	2	chays
cheaps	13	46	1368	2	cheaps
chips	12	57	2125	2	chips
chops	12	50	1987	2	chops
claps	9	56	2618	2	claps
cops	8	67	5137	2	cops
craps	9	53	2864	2	craps
cups	8	54	3082	2	cups
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
dags	6	66	4260	2	dags
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
daks	9	71	3060	2	daks
dals	5	71	4512	2	dals
damps	10	52	2041	2	damps
dams	7	74	4437	2	dams
dans	5	67	4815	2	dans
dap	6	66	5245	2	dap_
daws	8	66	3824	2	daws
days	8	76	3713	2	days
dhaks	13	47	970	2	dhaks
dhals	9	54	1544	2	dhals
dips	7	55	3691	2	dips
dups	7	59	2951	2	dups
ears	4	63	5659	2	ears
eats	4	70	5487	2	eats
fabs	9	86	3586	2	fabs
fads	8	69	3987	2	fads
fags	8	69	3912	2	fags
fans	7	62	4737	2	fans
fas	6	82	6293	2	fa_s
fats	7	62	5250	2	fats
fays	10	85	3536	2	fays
flaps	10	56	2138	2	flaps
fops	9	65	3268	2	fops
fraps	10	56	2055	2	fraps
gabs	7	67	4042	2	gabs
gads	6	78	4338	2	gads
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gals	5	79	4650	2	gals
gamps	10	53	2371	2	gamps
gams	7	66	4888	2	gams
gap	6	70	5561	2	gap_
gape	7	51	3451	2	gape
gapes	8	60	3082	2	gapes
gapy	10	63	2091	2	gapy
gars	5	57	5074	2	gars
gas	4	88	7025	2	ga_s
gasp	7	62	2733	2	gasp
gasps	8	54	1548	2	gasps
gats	5	67	5344	2	gats
gawps	11	59	1101	2	gawps
gays	8	73	3802	2	gays
ghats	9	58	1861	2	ghats
gips	7	56	3292	2	gips
gyps	10	51	1502	2	gyps
ha	5	102	5994	2	ha__
haaf	10	62	2773	2	haaf
haafs	11	57	1116	2	haafs
haar	7	73	2349	2	haar
haars	8	56	2047	2	haars
habu	9	73	2548	2	habu
habus	10	63	1714	2	habus
hack	13	51	3454	2	hack
hacks	14	49	2871	2	hacks
had	7	76	5876	2	ha_d
hade	8	54	4019	2	hade
hades	9	60	3511	2	hades
hadj	15	58	1867	2	hadj
hadst	9	32	2022	2	hadst
hae	6	73	6400	2	ha_e
haed	8	63	3858	2	haed
haem	9	57	3098	2	haem
haems	10	55	1701	2	haems
haen	7	62	2945	2	haen
haet	7	56	5950	2	haet
haets	8	65	2512	2	haets
haft	10	59	4184	2	haft
hafts	11	62	1946	2	hafts
hag	7	72	5574	2	ha_g
hah	9	106	5522	2	ha_h
haha	10	78	2106	2	haha
hahas	11	71	1844	2	hahas
haik	11	55	2698	2	haik
haiks	12	51	2093	2	haiks
hail	7	48	3906	2	hail
hails	8	52	3164	2	hails
hair	7	63	3014	2	hair
hairs	8	62	2517	2	hairs
haj	13	81	4060	2	ha_j
hajes	15	54	2094	2	hajes
haji	14	85	2019	2	haji
hajis	15	67	1628	2	hajis
hajj	13	83	1247	2	hajj
hake	11	56	3784	2	hake
hakes	12	60	3430	2	hakes
haku	11	69	2389	2	haku
hakus	12	51	1411	2	hakus
hale	7	60	5283	2	hale
hales	8	54	4984	2	hales
half	10	62	3845	2	half
hall	7	57	4116	2	hall
halls	8	56	3378	2	halls
halm	9	58	3497	2	halm
halms	10	52	2521	2	halms
halo	7	64	3732	2	halo
halos	8	52	3025	2	halos
halt	7	60	5630	2	halt
halts	8	52	3010	2	halts
ham	8	63	6328	2	ha_m
hame	9	70	4313	2	hame
hames	10	61	3870	2	hames
hand	8	68	3371	2	hand
hands	9	53	2738	2	hands
hang	8	55	3555	2	hang
hangs	9	57	2672	2	hangs
hank	11	51	3414	2	hank
hanks	12	62	2686	2	hanks
hansa	8	54	1678	2	hansa
hanse	8	57	2279	2	hanse
hant	7	54	6159	2	hant
hants	8	63	3540	2	hants
hao	6	72	5112	2	ha_o
hapax	17	3	932	2	hapax
haply	13	59	1506	2	haply
happy	15	58	1353	2	happy
hard	8	54	4350	2	hard
hards	9	64	3565	2	hards
hare	7	62	5573	2	hare
hares	8	62	5554	2	hares
hark	11	52	3739	2	hark
harks	12	63	3343	2	harks
harl	7	57	4000	2	harl
harls	8	56	3450	2	harls
harm	9	56	3779	2	harm
harms	10	68	2901	2	harms
harp	9	61	3429	2	harp
harpy	13	64	1821	2	harpy
harsh	11	64	1805	2	harsh
hart	7	68	6577	2	hart
harts	8	84	4159	2	harts
hash	10	69	3650	2	hash
hast	7	62	5948	2	hast
hat	6	72	8996	2	ha_t
hate	7	84	5017	2	hate
hates	8	67	4257	2	hates
hath	10	59	3391	2	hath
haul	7	55	3045	2	haul
hauls	8	61	2373	2	hauls
haut	7	59	4973	2	haut
have	10	61	3707	2	have
haves	11	60	3487	2	haves
haw	9	71	5327	2	ha_w
hawk	14	55	2115	2	hawk
hawks	15	54	1570	2	hawks
hawse	11	60	1512	2	hawse
hay	9	73	5877	2	ha_y
haze	16	48	3339	2	haze
hazes	17	49	2832	2	hazes
hazy	19	181	1919	2	hazy
heads	9	51	2711	2	heads
heals	8	57	3345	2	heals
heap	9	64	3289	2	heap_
heapy	13	59	1498	2	heapy
hears	8	67	3737	2	hears
heats	8	58	3840	2	heats
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
hoars	8	59	2555	2	hoars
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	h_os
hots	7	83	4933	2	hots
hows	10	63	4560	2	hows
hoys	10	77	3393	2	hoys
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
jabs	13	58	3009	2	jabs
jags	12	61	3279	2	jags
jams	13	52	3107	2	jams
jape	13	49	2342	2	jape
japes	14	63	2282	2	japes
jars	11	73	3835	2	jars
jaups	14	48	1053	2	jaups
jaws	14	50	2729	2	jaws
jays	14	63	2834	2	jays
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kafs	11	64	2374	2	kafs
kapa	10	60	2129	2	kapa
kapas	11	60	2173	2	kapas
kaph	13	58	1575	2	kaph
kaphs	14	49	1150	2	kaphs
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kays	11	60	3219	2	kays
keps	10	60	2730	2	keps
khafs	15	64	884	2	khafs
khans	12	46	1517	2	khans
khaph	17	39	596	2	khaph
khaphs	18	39	432	2	khaphs
khats	12	53	1601	2	khats
kips	10	64	3051	2	kips
knaps	11	55	1117	2	knaps
kops	10	70	3129	2	kops
labs	6	71	4512	2	labs
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lags	5	65	4622	2	lags
lamps	9	56	2483	2	lamps
lams	6	65	5226	2	lams
lap	5	85	6527	2	lap_
lapis	7	62	2315	2	lapis
lapse	7	49	1768	2	lapse
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lass	4	74	4454	2	lass
lats	4	59	6270	2	lats
lavs	7	67	3415	2	lavs
laws	7	64	4168	2	laws
lays	7	60	4325	2	lays
leaps	7	55	2293	2	leaps
lips	6	71	4144	2	lips
lops	6	60	4335	2	lops
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	ma_s
mass	6	60	4494	2	mass
mats	6	54	6029	2	mats
maws	9	64	3714	2	maws
mays	9	69	4003	2	mays
mips	8	55	3408	2	mips
mops	8	59	4013	2	mops
nabs	6	62	3619	2	nabs
nags	5	54	3602	2	nags
nans	4	61	3940	2	nans
naos	4	74	2973	2	naos
nap	5	67	5320	2	nap_
napa	6	69	2726	2	napa
napas	7	59	2435	2	napas
nape	6	52	3080	2	nape
napes	7	48	2846	2	napes
nays	7	59	3159	2	nays
neaps	7	56	1832	2	neaps
nips	6	58	3092	2	nips
oafs	7	64	2526	2	oafs
oaks	8	65	2790	2	oaks
oars	4	68	4603	2	oars
oats	4	65	5421	2	oats
oops	6	52	3267	2	oops
ops	5	66	4125	2	_ops
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
palps	9	47	1956	2	palps
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pans	6	58	5573	2	pans
pap	7	67	5840	2	pap_
papa	8	58	2714	2	papa
papas	9	49	2749	2	papas
pars	6	75	6079	2	pars
pas	5	87	7574	2	pa_s
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
paws	9	60	3818	2	paws
pays	9	59	4022	2	pays
peps	8	51	3451	2	peps
pips	8	58	3713	2	pips
pops	8	63	4095	2	pops
pups	8	60	3223	2	pups
qats	13	53	3134	2	qats
rads	5	60	4660	2	rads
rags	5	54	4837	2	rags
rais	4	52	5262	2	rais
ramps	9	62	2463	2	ramps
rams	6	59	5077	2	rams
rap	5	62	6196	2	rap_
rape	6	50	4163	2	rape
rapes	7	57	4072	2	rapes
rapt	6	72	4531	2	rapt
ras	3	75	7539	2	ra_s
rasp	6	60	2916	2	rasp
rasps	7	43	1666	2	rasps
rats	4	62	6037	2	rats
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
reaps	7	56	2619	2	reaps
reps	6	59	3795	2	reps
rips	6	62	3743	2	rips
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
sags	5	59	4840	2	sags
salps	7	44	2324	2	salps
sals	4	68	5167	2	sals
samps	9	61	2467	2	samps
sans	4	51	5336	2	sans
sap	5	64	6323	2	sap_
sass	4	50	3562	2	sass
saws	7	58	3948	2	saws
says	7	59	4210	2	says
shads	9	51	2448	2	shads
shags	9	51	2386	2	shags
shahs	11	59	1951	2	shahs
shams	10	58	2941	2	shams
shape	10	51	2511	2	shape
shapes	11	51	2494	2	shapes
sharps	11	55	1608	2	sharps
shaws	11	62	2626	2	shaws
shays	11	60	2143	2	shays
ships	10	51	2377	2	ships
shnaps	11	4	808	2	shnaps
shops	10	42	2290	2	shops
sips	6	57	4010	2	sips
slaps	7	60	2571	2	slaps
snaps	7	47	1956	2	snaps
soaps	7	51	2071	2	soaps
sops	6	52	4456	2	sops
spas	6	70	3672	2	spas
sups	6	48	3443	2	sups
swaps	10	48	1920	2	swaps
tabs	6	68	4298	2	tabs
tads	5	71	4394	2	tads
tags	5	55	4523	2	tags
tamps	9	55	2408	2	tamps
tams	6	72	4793	2	tams
tans	4	61	5482	2	tans
taos	4	55	4100	2	taos
tap	5	76	6387	2	tap_
tapa	6	51	2914	2	tapa
tapas	7	46	2771	2	tapas
tape	6	45	3814	2	tape
tapes	7	58	3860	2	tapes
tapis	7	50	2886	2	tapis
tarps	7	65	2711	2	tarps
tars	4	67	6395	2	tars
tas	3	84	7710	2	ta_s
tass	4	56	4057	2	tass
tats	4	68	5813	2	tats
taus	4	63	4273	2	taus
tavs	7	56	3097	2	tavs
taws	7	56	4159	2	taws
thaws	11	65	1546	2	thaws
tips	6	64	3676	2	tips
tops	6	62	4812	2	tops
traps	7	57	2748	2	traps
tups	6	56	2876	2	tups
umps	8	57	2194	2	umps
upas	6	83	2238	2	upas
ups	5	56	2905	2	_ups
urps	6	69	2047	2	urps
vacs	9	62	2620	2	vacs
vamps	12	54	1548	2	vamps
vans	7	62	3673	2	vans
vars	7	57	4207	2	vars
vas	6	77	5577	2	va_s
vats	7	68	4174	2	vats
vaus	7	59	2892	2	vaus
vavs	10	57	2043	2	vavs
vaws	10	55	2732	2	vaws
wabs	9	73	3723	2	wabs
wads	8	73	4314	2	wads
waes	7	60	4860	2	waes
wags	8	61	4055	2	wags
wans	7	64	5227	2	wans
wap	8	65	5337	2	wap_
warps	10	71	2642	2	warps
wars	7	86	5980	2	wars
was	6	87	6756	2	wa_s
wasp	9	56	2685	2	wasp
wasps	10	67	1469	2	wasps
wats	7	75	5588	2	wats
waws	10	68	3490	2	waws
ways	10	77	3795	2	ways
whams	13	55	1564	2	whams
whap	12	51	1964	2	whap_
whats	11	77	1899	2	whats
whaups	14	40	575	2	whaups
whips	13	49	1708	2	whips
whops	13	50	1393	2	whops
whups	13	42	1000	2	whups
wops	9	66	3415	2	wops
wraps	10	56	1715	2	wraps
yags	8	66	3229	2	yags
yaks	11	60	2520	2	yaks
yams	9	53	3073	2	yams
yap	8	59	4982	2	yap_
yaups	10	59	1074	2	yaups
yawps	13	62	879	2	yawps
yaws	10	55	3121	2	yaws
yays	10	57	2891	2	yays
yeps	9	59	2440	2	yeps
yips	9	52	2670	2	yips
yups	9	61	2160	2	yups
zags	14	68	2668	2	zags
zap	14	58	4069	2	zap_
zas	12	69	4683	2	za_s
zeps	15	60	1934	2	zeps
zips	15	57	2379	2	zips

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.076	2351197.4
2	DLD Change Limit	29872	544	0.783	38150.7
3	Display Results	544	544	0.123	4422.8
	(SQL Overall)	178691	544	0.982	181966.4