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

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

363 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
tups	6	56	2876	(None)
cups	8	54	3082	1	cups
dups	7	59	2951	1	dups
pups	8	60	3223	1	pups
sups	6	48	3443	1	sups
taps	6	60	5067	1	taps
tips	6	64	3676	1	tips
tops	6	62	4812	1	tops
tubs	6	54	3006	1	tubs
tugs	5	62	3167	1	tugs
tuis	4	48	2964	1	tuis
tumps	9	54	2079	1	tumps
tuns	4	51	3866	1	tuns
tup	5	60	3754	1	tup_
turps	7	49	1873	1	turps
tuts	4	58	3845	1	tuts
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
ataps	7	64	1483	2	ataps
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
cutups	10	3	681	2	cutups
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
etuis	5	40	1313	2	etuis
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
getups	9	34	685	2	getups
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
letups	8	31	768	2	letups
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
saps	6	53	4637	2	saps
scups	9	53	1665	2	scups
setups	8	39	1046	2	setups
sips	6	57	4010	2	sips
situps	8	53	878	2	situps
sops	6	52	4456	2	sops
soups	7	53	2294	2	soups
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
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
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	t_as
tass	4	56	4057	2	tass
tats	4	68	5813	2	tats
taupe	7	3	1416	2	taupe
taupes	8	2	1267	2	taupes
taus	4	63	4273	2	taus
tauts	5	61	2551	2	tauts
tavs	7	56	3097	2	tavs
taws	7	56	4159	2	taws
teas	4	58	5149	2	teas
teds	5	49	3257	2	teds
tees	4	53	5358	2	tees
tegs	5	60	3149	2	tegs
tels	4	68	4169	2	tels
temps	9	54	1713	2	temps
tens	4	56	4741	2	tens
tepa	6	60	2168	2	tepa
tepas	7	65	2168	2	tepas
tets	4	58	4746	2	tets
tews	7	64	3164	2	tews
this	7	60	2738	2	this
thuds	9	51	1013	2	thuds
thugs	9	56	1199	2	thugs
thumps	13	44	935	2	thumps
thus	7	67	2147	2	thus
tics	6	57	2963	2	tics
ties	4	52	4831	2	ties
tils	4	57	3961	2	tils
tins	4	52	5130	2	tins
tip	5	65	5122	2	tip_
tipi	6	99	2443	2	tipi
tipis	7	60	1992	2	tipis
tipsy	10	60	1050	2	tipsy
tis	3	70	5664	2	t_is
tits	4	61	4504	2	tits
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
tours	5	53	2589	2	tours
touts	5	48	3039	2	touts
tows	7	85	4555	2	tows
toys	7	80	3634	2	toys
traps	7	57	2748	2	traps
tres	4	65	4290	2	tres
trips	7	49	2336	2	trips
trues	5	49	2532	2	trues
trugs	6	55	1680	2	trugs
trumps	10	46	1188	2	trumps
truss	5	49	1692	2	truss
tsks	8	64	1066	2	tsks
tub	5	56	4003	2	tu_b
tuba	6	54	2236	2	tuba
tubas	7	51	1958	2	tubas
tube	6	58	2866	2	tube
tubes	7	48	2645	2	tubes
tuck	10	46	2657	2	tuck
tucks	11	47	2112	2	tucks
tufa	7	50	1661	2	tufa
tufas	8	53	1438	2	tufas
tuff	10	45	2852	2	tuff
tuffs	11	51	1826	2	tuffs
tuft	7	69	2951	2	tuft
tufts	8	57	1327	2	tufts
tug	4	59	3740	2	tu_g
tui	3	70	3402	2	tu_i
tule	4	57	3587	2	tule
tules	5	45	3279	2	tules
tulips	8	13	725	2	tulips
tump	8	59	2703	2	tump
tun	3	58	4519	2	tu_n
tuna	4	51	2784	2	tuna
tunas	5	42	2412	2	tunas
tune	4	56	3586	2	tune
tunes	5	53	3219	2	tunes
tung	5	53	2816	2	tung
tungs	6	55	2062	2	tungs
tupik	11	4	900	2	tupik
tupiks	12	3	549	2	tupiks
turd	5	60	2762	2	turd
turds	6	50	2169	2	turds
turf	7	53	3405	2	turf
turfs	8	46	2044	2	turfs
turk	8	61	2586	2	turk
turks	9	53	2082	2	turks
turn	4	63	3039	2	turn
turns	5	56	2324	2	turns
tush	7	45	2390	2	tush
tusk	8	56	2163	2	tusk
tusks	9	49	1553	2	tusks
tut	3	67	5809	2	tu_t
tutu	4	84	2317	2	tutu
tutus	5	52	1481	2	tutus
tux	10	54	2657	2	tu_x
tuxes	12	43	1604	2	tuxes
twas	7	68	2408	2	twas
twos	7	67	1802	2	twos
tyes	7	64	3337	2	tyes
type	9	62	2374	2	type
types	10	57	2106	2	types
typo	9	54	1812	2	typo
typos	10	60	1581	2	typos
typp	11	58	1278	2	typp
typps	12	54	930	2	typps
typy	12	60	1304	2	typy
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
utas	4	59	2495	2	utas
utes	4	59	3088	2	utes
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.283	631417.0
2	DLD Change Limit	29872	363	0.750	39829.3
3	Display Results	363	363	0.093	3903.2
	(SQL Overall)	178691	363	1.126	158695.4