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

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

349 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
ups	5	56	2905	(None)
cups	8	54	3082	1	cups
dups	7	59	2951	1	dups
ops	5	66	4125	1	ops
pups	8	60	3223	1	pups
pus	5	55	4784	1	pus
sups	6	48	3443	1	sups
tups	6	56	2876	1	tups
umps	8	57	2194	1	umps
uns	3	59	3675	1	uns
up	4	78	3282	1	up_
upas	6	83	2238	1	upas
upo	5	89	2586	1	upo
urps	6	69	2047	1	urps
us	2	69	3743	1	u_s
uts	3	55	3437	1	uts
yups	9	61	2160	1	yups
aas	3	109	7539	2	aas
abs	5	93	5607	2	abs
ads	4	97	5573	2	ads
ags	4	75	5166	2	ags
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	_as
asp	5	72	3534	2	asp
asps	6	56	2209	2	asps
ass	3	78	4406	2	ass
auks	8	55	2526	2	auks
ays	6	70	5029	2	ays
baps	8	60	4084	2	baps
bas	5	86	8175	2	bas
bes	5	65	5743	2	bes
bis	5	68	6065	2	bis
bops	8	60	3798	2	bops
bos	5	79	6681	2	bos
bubs	8	62	3549	2	bubs
buds	7	52	3517	2	buds
bugs	7	60	3591	2	bugs
bumps	11	59	2114	2	bumps
bums	8	59	3459	2	bums
buns	6	62	4372	2	buns
burps	9	42	2017	2	burps
burs	6	58	4742	2	burs
bus	5	69	5097	2	bus
buss	6	51	3491	2	buss
buts	6	72	4769	2	buts
buys	9	57	2679	2	buys
bys	8	52	2946	2	bys
caps	8	71	4789	2	caps
ceps	8	61	2595	2	ceps
cis	5	77	4803	2	cis
cops	8	67	5137	2	cops
cos	5	102	7039	2	cos
coups	9	55	2247	2	coups
cubs	8	58	3238	2	cubs
cuds	7	67	3047	2	cuds
cues	6	54	3898	2	cues
cup	7	67	3824	2	cup_
curs	6	56	4554	2	curs
cusp	8	60	2106	2	cusp
cusps	9	49	1367	2	cusps
cuss	6	54	3061	2	cuss
cuts	6	58	4115	2	cuts
daps	7	72	3916	2	daps
dips	7	55	3691	2	dips
dis	4	64	5989	2	dis
dos	4	80	6231	2	dos
dubs	7	84	3219	2	dubs
duds	6	55	3014	2	duds
dues	5	60	4550	2	dues
dugs	6	148	3228	2	dugs
dumps	10	52	2010	2	dumps
duns	5	51	4043	2	duns
duos	5	67	2813	2	duos
dup	6	76	3788	2	dup_
dupe	7	66	3060	2	dupe
dupes	8	64	2593	2	dupes
eds	4	66	3892	2	eds
efs	6	68	2960	2	efs
els	3	76	4572	2	els
ems	5	64	3549	2	ems
ens	3	72	4592	2	ens
epos	6	67	2373	2	epos
ers	3	60	4628	2	ers
es	2	90	4822	2	_es
ess	3	60	3088	2	ess
fas	6	82	6293	2	fas
fes	6	65	5167	2	fes
fops	9	65	3268	2	fops
fubs	9	63	2879	2	fubs
fuds	8	65	2856	2	fuds
fugs	8	57	3069	2	fugs
funs	7	52	3573	2	funs
furs	7	67	3504	2	furs
fuss	7	60	2793	2	fuss
gaps	7	60	4297	2	gaps
gas	4	88	7025	2	gas
gips	7	56	3292	2	gips
gos	4	71	5513	2	gos
gulps	8	47	1507	2	gulps
guls	5	59	3085	2	guls
gums	7	50	3094	2	gums
guns	5	55	3348	2	guns
guts	5	66	3725	2	guts
guvs	8	58	1681	2	guvs
guys	8	50	1964	2	guys
gyps	10	51	1502	2	gyps
haps	9	64	4346	2	haps
has	6	73	7265	2	has
hes	6	66	5420	2	hes
hips	9	64	3370	2	hips
his	6	63	5950	2	his
hops	9	79	4263	2	hops
hos	6	83	6419	2	hos
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
hyps	12	54	1841	2	hyps
ids	4	75	3546	2	ids
ifs	6	71	2424	2	ifs
imps	8	62	2111	2	imps
ins	3	59	4560	2	ins
is	2	70	4821	2	_is
its	3	55	3883	2	its
jaups	14	48	1053	2	jaups
jugs	12	55	2560	2	jugs
jumps	16	51	1649	2	jumps
jupe	13	49	2100	2	jupe
jupes	14	52	1855	2	jupes
jus	10	69	3022	2	jus
juts	11	59	3016	2	juts
kas	7	70	5858	2	kas
keps	10	60	2730	2	keps
kips	10	64	3051	2	kips
kis	7	80	5147	2	kis
kops	10	70	3129	2	kops
kos	7	69	4482	2	kos
kues	8	64	2677	2	kues
laps	6	68	4887	2	laps
las	3	72	8147	2	las
les	3	56	6307	2	les
lips	6	71	4144	2	lips
lis	3	71	6227	2	lis
lops	6	60	4335	2	lops
loups	7	53	1962	2	loups
lues	4	59	4355	2	lues
lugs	5	52	3352	2	lugs
lumps	9	56	2498	2	lumps
lums	6	57	3424	2	lums
lupus	7	45	1252	2	lupus
luvs	7	58	1850	2	luvs
maps	8	61	4104	2	maps
mas	5	81	7581	2	mas
mips	8	55	3407	2	mips
mis	5	81	6261	2	mis
mops	8	59	4013	2	mops
mos	5	70	6712	2	mos
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	3591	2	muns
mus	5	59	4675	2	mus
muss	6	49	3376	2	muss
muts	6	48	3998	2	muts
naps	6	62	3858	2	naps
nips	6	58	3092	2	nips
nos	3	88	5932	2	nos
nubs	6	59	2714	2	nubs
nuns	4	52	2823	2	nuns
nus	3	79	3939	2	nus
nuts	4	50	3267	2	nuts
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
oops	6	52	3267	2	oops
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	_os
ouds	5	64	3010	2	ouds
ouph	9	56	1837	2	ouph
ouphs	10	43	1127	2	ouphs
ours	4	72	3756	2	ours
outs	4	57	4696	2	outs
pa	4	104	5648	2	_pa
paps	8	64	4345	2	paps
pas	5	87	7574	2	pas
pe	4	76	4903	2	_pe
peps	8	51	3451	2	peps
pes	5	72	5978	2	pes
pi	4	81	4536	2	_pi
pips	8	58	3713	2	pips
pis	5	63	6203	2	pis
pops	8	63	4095	2	pops
psi	5	66	2162	2	_psi
pst	5	79	3251	2	_pst
pub	7	60	3769	2	pub
pubs	8	50	2921	2	pubs
pud	6	58	3665	2	pud
puds	7	56	3051	2	puds
pug	6	53	3718	2	pug
pugs	7	63	3277	2	pugs
pul	5	61	3806	2	pul
pulps	9	51	1648	2	pulps
puls	6	54	3756	2	puls
pumps	11	55	2060	2	pumps
pun	5	88	4651	2	pun
puns	6	66	4148	2	puns
pup	7	63	3988	2	pup
pupa	8	54	2281	2	pupa
pupas	9	52	1928	2	pupas
pupu	8	76	2071	2	pupu
pupus	9	46	1404	2	pupus
pur	5	68	4055	2	pur
purs	6	56	4104	2	purs
push	9	55	2662	2	push
puss	6	48	3013	2	puss
put	5	57	5907	2	put
puts	6	56	4175	2	puts
qis	12	69	3438	2	qis
quips	16	47	1337	2	quips
raps	6	62	4773	2	raps
ras	3	75	7539	2	ras
reps	6	59	3795	2	reps
res	3	55	6504	2	res
rips	6	62	3743	2	rips
roups	7	51	1890	2	roups
rubs	6	61	3349	2	rubs
rues	4	60	4448	2	rues
rugs	5	60	3368	2	rugs
rumps	9	59	2229	2	rumps
rums	6	48	3347	2	rums
runs	4	64	3807	2	runs
ruts	4	45	4149	2	ruts
saps	6	53	4637	2	saps
scups	9	53	1665	2	scups
sips	6	57	4010	2	sips
sis	3	73	6054	2	sis
sops	6	52	4456	2	sops
sos	3	77	6160	2	sos
soups	7	53	2294	2	soups
spa	5	57	3081	2	spa
spas	6	70	3672	2	spas
spy	8	60	2374	2	spy
subs	6	60	3712	2	subs
suds	5	61	3529	2	suds
sues	4	62	4765	2	sues
suks	8	59	2712	2	suks
sumps	9	50	2343	2	sumps
sums	6	58	3758	2	sums
suns	4	58	4190	2	suns
sup	5	70	4194	2	sup_
supe	6	59	3276	2	supe
supes	7	56	2830	2	supes
suqs	13	43	1965	2	suqs
suss	4	52	2930	2	suss
taps	6	60	5067	2	taps
tas	3	84	7710	2	tas
tips	6	64	3676	2	tips
tis	3	70	5664	2	tis
tops	6	62	4812	2	tops
tubs	6	54	3006	2	tubs
tugs	5	62	3167	2	tugs
tuis	4	48	2964	2	tuis
tumps	9	54	2079	2	tumps
tuns	4	51	3866	2	tuns
tup	5	60	3754	2	tup_
turps	7	49	1873	2	turps
tuts	4	58	3845	2	tuts
udo	4	90	2730	2	udo
udos	5	66	1990	2	udos
ugh	7	65	2068	2	ugh
ughs	8	54	1097	2	ughs
uh	5	74	2985	2	u_h
uke	7	57	2729	2	uke
ukes	8	61	2281	2	ukes
ulu	3	60	2870	2	ulu
ulus	4	56	2256	2	ulus
um	4	73	3883	2	u_m
umm	7	119	2126	2	umm
ump	7	61	3044	2	ump
un	2	83	4113	2	u_n
upby	11	3	906	2	upby
updo	7	67	1288	2	updo
updos	8	38	951	2	updos
upon	6	58	1758	2	upon
upset	7	32	2259	2	upset
urb	5	57	3110	2	urb
urbs	6	59	2205	2	urbs
urd	4	64	2704	2	urd
urds	5	59	2242	2	urds
urn	3	57	3146	2	urn
urns	4	63	2389	2	urns
urp	5	64	2639	2	urp
ursa	4	41	1690	2	ursa
urus	4	64	2613	2	urus
use	3	68	3516	2	use
uses	4	49	3111	2	uses
ut	2	86	4703	2	u_t
uta	3	74	2558	2	uta
utas	4	59	2495	2	utas
ute	3	53	3588	2	ute
utes	4	59	3088	2	utes
vas	6	77	5577	2	vas
vis	6	67	4761	2	vis
vugs	8	70	2287	2	vugs
waps	9	66	4208	2	waps
was	6	87	6756	2	was
whups	13	42	1000	2	whups
wis	6	65	5233	2	wis
wops	9	66	3415	2	wops
wos	6	69	5353	2	wos
wuss	7	52	1933	2	wuss
xis	10	69	3533	2	xis
yaps	9	59	3352	2	yaps
yaups	10	59	1074	2	yaups
yeps	9	59	2440	2	yeps
yes	6	62	5061	2	yes
yips	9	52	2669	2	yips
yuks	11	64	1802	2	yuks
yup	8	60	3170	2	yup_
zaps	15	68	2689	2	zaps
zas	12	69	4683	2	zas
zeps	15	60	1934	2	zeps
zips	15	57	2379	2	zips

Search took 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	349	0.466	30223.2
3	Display Results	349	349	0.076	4592.1
	(SQL Overall)	178691	349	0.605	295357.0