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

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

375 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
sups	6	48	3443	(None)
cups	8	54	3082	1	cups
dups	7	59	2951	1	dups
pups	8	60	3223	1	pups
saps	6	53	4637	1	saps
scups	9	53	1665	1	scups
sips	6	57	4010	1	sips
sops	6	52	4456	1	sops
soups	7	53	2294	1	soups
subs	6	60	3712	1	subs
suds	5	61	3529	1	suds
sues	4	62	4765	1	sues
suks	8	59	2712	1	suks
sumps	9	50	2343	1	sumps
sums	6	58	3758	1	sums
suns	4	58	4190	1	suns
sup	5	70	4194	1	sup_
supe	6	59	3276	1	supe
supes	7	56	2830	1	supes
suqs	13	43	1965	1	suqs
suss	4	52	2930	1	suss
tups	6	56	2876	1	tups
ups	5	56	2905	1	_ups
yups	9	61	2160	1	yups
alps	6	55	2924	2	alps
amps	8	62	3034	2	amps
apps	8	63	1969	2	apps
asps	6	56	2209	2	asps
auks	8	55	2526	2	auks
baps	8	60	4084	2	baps
bops	8	60	3798	2	bops
bubs	8	62	3550	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	bu_s
buss	6	51	3491	2	buss
buts	6	72	4769	2	buts
buys	9	57	2679	2	buys
caps	8	71	4789	2	caps
ceps	8	61	2595	2	ceps
cops	8	67	5137	2	cops
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
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
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
gips	7	56	3292	2	gips
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
hips	9	64	3370	2	hips
hops	9	79	4263	2	hops
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
imps	8	62	2112	2	imps
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	ju_s
juts	11	59	3016	2	juts
keps	10	60	2730	2	keps
kips	10	64	3052	2	kips
kops	10	70	3129	2	kops
kues	8	64	2677	2	kues
laps	6	68	4887	2	laps
lips	6	71	4144	2	lips
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	4105	2	maps
mips	8	55	3408	2	mips
mops	8	59	4013	2	mops
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
mus	5	59	4675	2	mu_s
muss	6	49	3376	2	muss
muts	6	48	3998	2	muts
naps	6	62	3858	2	naps
nips	6	58	3092	2	nips
nubs	6	59	2714	2	nubs
nuns	4	52	2823	2	nuns
nus	3	79	3939	2	nu_s
nuts	4	50	3267	2	nuts
oops	6	52	3267	2	oops
ops	5	66	4125	2	_ops
opus	6	64	2059	2	opus
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
paps	8	64	4345	2	paps
peps	8	51	3451	2	peps
pips	8	58	3713	2	pips
pops	8	63	4095	2	pops
pubs	8	50	2921	2	pubs
puds	7	56	3051	2	puds
pugs	7	63	3277	2	pugs
pulps	9	51	1648	2	pulps
puls	6	54	3756	2	puls
pumps	11	55	2060	2	pumps
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
purs	6	56	4104	2	purs
pus	5	55	4784	2	pu_s
puss	6	48	3013	2	puss
puts	6	56	4175	2	puts
quips	16	47	1337	2	quips
raps	6	62	4773	2	raps
reps	6	59	3795	2	reps
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	3808	2	runs
ruts	4	45	4149	2	ruts
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
sauls	5	51	2812	2	sauls
saws	7	58	3948	2	saws
says	7	59	4210	2	says
scaups	10	54	1193	2	scaups
scops	9	58	2019	2	scops
scuds	8	51	1624	2	scuds
sculps	10	46	1175	2	sculps
scums	9	50	1742	2	scums
scup	8	48	2238	2	scup_
scuts	7	45	2252	2	scuts
seas	4	57	5527	2	seas
secs	6	50	3389	2	secs
seeps	7	48	2875	2	seeps
sees	4	53	6105	2	sees
segs	5	49	3388	2	segs
seis	4	55	4239	2	seis
sels	4	63	4598	2	sels
sept	6	58	4436	2	sept
septs	7	54	2060	2	septs
sers	4	57	4665	2	sers
sets	4	55	4950	2	sets
setups	8	39	1046	2	setups
sews	7	58	3602	2	sews
shes	7	57	3435	2	shes
ships	10	51	2377	2	ships
shops	10	42	2290	2	shops
shuls	8	53	1971	2	shuls
shuns	8	50	1814	2	shuns
shuts	8	56	2248	2	shuts
sibs	6	59	3354	2	sibs
sics	6	52	3409	2	sics
simps	9	47	1976	2	simps
sims	6	57	3717	2	sims
sins	4	67	5527	2	sins
sip	5	76	5601	2	sip_
sipe	6	73	4104	2	sipe
sipes	7	60	3695	2	sipes
sirs	4	43	3833	2	sirs
sirups	8	37	1053	2	sirups
sis	3	73	6054	2	s_is
sits	4	50	5020	2	sits
situps	8	53	878	2	situps
skas	8	53	2571	2	skas
skeps	11	56	1425	2	skeps
skips	11	56	1660	2	skips
skis	8	48	2529	2	skis
skuas	9	56	1173	2	skuas
slaps	7	60	2571	2	slaps
slips	7	60	2372	2	slips
slops	7	50	2601	2	slops
slubs	7	47	1953	2	slubs
slues	5	45	2717	2	slues
slugs	6	46	1856	2	slugs
slumps	10	43	1358	2	slumps
slums	7	46	2343	2	slums
slurps	8	44	1000	2	slurps
slurs	5	41	2337	2	slurs
sluts	5	45	2398	2	sluts
smuts	7	54	1571	2	smuts
snaps	7	47	1956	2	snaps
snips	7	58	1801	2	snips
snubs	7	54	1255	2	snubs
snugs	6	49	1302	2	snugs
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	s_os
sots	4	55	5245	2	sots
souks	9	48	2052	2	souks
souls	5	51	2736	2	souls
soup	6	62	3291	2	soup_
soupy	10	61	1540	2	soupy
sours	5	52	3050	2	sours
sous	4	69	4721	2	sous
sows	7	53	4249	2	sows
soys	7	52	3393	2	soys
spa	5	57	3081	2	s_pa
spas	6	70	3672	2	spas
spud	7	58	1849	2	spud
spuds	8	51	1367	2	spuds
spue	6	60	2552	2	spue
spues	7	50	2538	2	spues
spun	6	62	2146	2	spun
spur	6	53	2119	2	spur
spurs	7	46	2152	2	spurs
spy	8	60	2374	2	s_py
sris	4	54	3415	2	sris
steps	7	66	1988	2	steps
stops	7	48	2728	2	stops
stoups	8	53	1327	2	stoups
stubs	7	50	1607	2	stubs
studs	6	44	1587	2	studs
stumps	10	49	1228	2	stumps
stums	7	53	2008	2	stums
stuns	5	47	1949	2	stuns
stupa	7	41	1231	2	stupa
stupas	8	39	1088	2	stupas
stupe	7	52	1775	2	stupe
stupes	8	41	1695	2	stupes
sub	5	54	4555	2	su_b
suba	6	49	2660	2	suba
subas	7	47	2407	2	subas
such	9	64	2481	2	such
suck	10	61	3173	2	suck
sucks	11	45	2307	2	sucks
sudd	6	47	1977	2	sudd
sudds	7	55	1359	2	sudds
sudsy	9	50	1068	2	sudsy
sue	3	56	5146	2	su_e
sued	5	65	3793	2	sued
suer	4	53	3403	2	suer
suers	5	51	2848	2	suers
suet	4	67	5482	2	suet
suets	5	51	2610	2	suets
sugh	8	64	2344	2	sugh
sughs	9	53	1332	2	sughs
suit	4	56	4987	2	suit
suits	5	50	2805	2	suits
suk	7	56	3297	2	su_k
sulk	8	53	2665	2	sulk
sulks	9	48	1846	2	sulks
sulu	4	51	2842	2	sulu
sulus	5	48	2188	2	sulus
sum	5	63	4601	2	su_m
sumo	6	73	2631	2	sumo
sumos	7	57	2009	2	sumos
sump	8	63	3153	2	sump
sun	3	71	4903	2	su_n
sung	5	58	3217	2	sung
sunk	8	50	3181	2	sunk
sunn	4	54	2359	2	sunn
sunns	5	50	1735	2	sunns
sunups	8	3	726	2	sunups
super	7	49	2448	2	super
supers	8	46	2240	2	supers
supra	7	36	1425	2	supra
suq	12	62	2899	2	su_q
sura	4	57	4029	2	sura
suras	5	53	3633	2	suras
surd	5	64	3381	2	surd
surds	6	56	2466	2	surds
sure	4	54	4741	2	sure
surf	7	60	3931	2	surf
surfs	8	50	2254	2	surfs
swaps	10	48	1920	2	swaps
swops	10	59	1397	2	swops
syph	12	54	1327	2	syph
syphs	13	51	945	2	syphs
syrups	11	27	795	2	syrups
taps	6	60	5067	2	taps
tips	6	64	3676	2	tips
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
umps	8	57	2194	2	umps
uns	3	59	3676	2	_uns
up	4	78	3282	2	_up_
upas	6	83	2238	2	_upas
upo	5	89	2586	2	_upo
urps	6	69	2048	2	urps
us	2	69	3743	2	_u_s
uses	4	49	3111	2	uses
usurps	8	10	507	2	usurps
uts	3	55	3437	2	_uts
vugs	8	70	2287	2	vugs
waps	9	66	4208	2	waps
whups	13	42	1000	2	whups
wops	9	66	3415	2	wops
wuss	7	52	1933	2	wuss
yaps	9	59	3352	2	yaps
yaups	10	59	1074	2	yaups
yeps	9	59	2440	2	yeps
yips	9	52	2670	2	yips
yuks	11	64	1802	2	yuks
yup	8	60	3170	2	yup_
zaps	15	68	2689	2	zaps
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.296	603685.8
2	DLD Change Limit	29872	375	0.920	32469.6
3	Display Results	375	375	0.096	3906.3
	(SQL Overall)	178691	375	1.312	136197.4