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

Here are the results of your fuzzy-string dictionary search for “stumpy” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

377 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
stumpy	13	45	813	(None)
stump	9	46	1646	1	stump_
stumps	10	49	1228	1	stumps
bumpy	14	47	1505	2	_bumpy
clumpy	15	40	957	2	clumpy
dumpy	13	54	1475	2	_dumpy
frumpy	16	46	688	2	frumpy
glumpy	14	52	719	2	glumpy
grumpy	14	49	815	2	grumpy
humpy	15	51	1567	2	_humpy
jumpy	19	57	1281	2	_jumpy
lumpy	12	66	1591	2	_lumpy
scummy	15	26	522	2	scummy
shlumpy	17	4	286	2	shlumpy
skimpy	17	47	572	2	skimpy
slummy	13	32	586	2	slummy
slump	9	48	1663	2	slump_
slumps	10	43	1358	2	slumps
soupy	10	61	1540	2	sou_py
spumy	12	46	1036	2	spum_y
stamp	9	52	1736	2	stamp_
stamps	10	56	1402	2	stamps
stemmy	13	41	703	2	stemmy
stimy	10	51	1474	2	stim_y
stomp	9	56	1666	2	stomp_
stomps	10	56	1283	2	stomps
stripy	11	58	1274	2	stripy
stubby	13	4	504	2	stubby
studly	10	39	769	2	studly
study	9	44	1179	2	stu_dy
stuffy	15	31	708	2	stuffy
stum	6	55	2602	2	stum__
stumped	12	42	1015	2	stumped
stumper	11	36	1009	2	stumper
stums	7	53	2008	2	stum_s
stupa	7	41	1231	2	stu_pa
stupe	7	52	1775	2	stu_pe
sturdy	10	3	704	2	sturdy
stymy	13	35	829	2	stym_y
sump	8	63	3153	2	s_ump_
sumps	9	50	2343	2	s_umps
swampy	16	43	723	2	swampy
tummy	12	47	1199	2	_tummy
tump	8	59	2703	2	_tump_
tumps	9	54	2079	2	_tumps
atomy	10	74	1519	3	atom_y
atopy	10	68	1339	3	at_opy
brumby	15	38	595	3	brumby
bump	10	62	2824	3	_bump_
bumph	14	49	1198	3	_bumph
bumps	11	59	2114	3	_bumps
buppy	14	48	1007	3	_buppy
campy	14	51	1618	3	_campy
champy	18	50	961	3	champy
chummy	18	38	589	3	chummy
chump	14	53	1544	3	chump_
chumps	15	43	1382	3	chumps
clump	11	55	1745	3	clump_
clumps	12	153	1464	3	clumps
clumsy	13	32	619	3	clumsy
costumey	15	6	352	3	costumey
crampy	15	47	1099	3	crampy
crimpy	15	48	939	3	crimpy
crumby	15	40	811	3	crumby
crummy	15	36	589	3	crummy
crump	11	56	1642	3	crump_
crumply	16	33	609	3	crumply
crumps	12	45	1434	3	crumps
cuppy	14	47	1038	3	_cuppy
drumly	12	3	570	3	drumly
dumky	15	45	1134	3	_dumky
dummy	13	47	1278	3	_dummy
dump	9	59	2709	3	_dump_
dumps	10	52	2010	3	_dumps
estuary	10	3	468	3	estuary
flump	12	46	1472	3	flump_
flumps	13	51	1250	3	flumps
frump	12	69	1256	3	frump_
frumps	13	47	978	3	frumps
fumy	12	71	1858	3	_fum_y
gimpy	13	52	1223	3	_gimpy
glumly	12	35	662	3	glumly
grump	10	51	1531	3	grump_
grumphy	18	44	362	3	grumphy
grumps	11	45	1057	3	grumps
gulpy	11	46	1276	3	_gulpy
gummy	13	54	1365	3	_gummy
guppy	13	52	1127	3	_guppy
hempy	15	49	1276	3	_hempy
hump	11	62	2872	3	_hump_
humph	15	57	1221	3	_humph
humps	12	63	2280	3	_humps
jimpy	19	52	1082	3	_jimpy
jump	15	66	2172	3	_jump_
jumps	16	51	1649	3	_jumps
lump	8	65	3170	3	_lump_
lumps	9	56	2498	3	_lumps
metump	12	3	571	3	metump_
metumps	13	3	413	3	metumps
mummy	11	49	1362	3	_mummy
mump	10	54	2572	3	_mump_
mumps	11	56	1910	3	_mumps
ostomy	11	3	783	3	ostom_y
plummy	15	37	566	3	plummy
plump	11	53	1526	3	plump_
plumply	16	3	422	3	plumply
plumps	12	46	1261	3	plumps
plumy	12	42	1323	3	plum_y
pulpy	12	46	1236	3	_pulpy
pump	10	57	2685	3	_pump_
pumps	11	55	2060	3	_pumps
puppy	11	49	1241	3	_puppy
roupy	10	61	1271	3	rou_py
rummy	12	42	1241	3	_rummy
rump	8	67	2908	3	_rump_
rumply	13	34	857	3	_rumply
rumps	9	59	2229	3	_rumps
samp	8	57	3359	3	s_amp_
samps	9	61	2467	3	s_amps
sappy	12	54	1347	3	s_appy
satrapy	12	49	793	3	satrapy
saucy	10	46	1516	3	sau_cy
saughy	13	50	746	3	saughy
saury	8	43	1722	3	sau_ry
scamp	11	57	1731	3	scamp_
scampi	12	46	910	3	scampi
scamps	12	50	1417	3	scamps
schlumpy	20	4	187	3	schlumpy
scrimpy	16	48	613	3	scrimpy
sculp	9	53	1484	3	sculp_
sculps	10	46	1175	3	sculps
sculpt	10	44	1269	3	sculpt
scum	8	59	2452	3	scum__
scums	9	50	1742	3	scum_s
scup	8	48	2238	3	scu_p_
scups	9	53	1665	3	scu_ps
scurfy	14	33	876	3	scurfy
scurry	11	41	959	3	scurry
scurvy	14	38	610	3	scurvy
scuzzy	19	3	308	3	scuzzy
seamy	10	59	2127	3	seam_y
seemly	11	3	843	3	seemly
seepy	10	47	1797	3	s_eepy
setup	7	39	1582	3	setu_p_
setups	8	39	1046	3	setu_ps
shammy	16	38	850	3	shammy
shamoy	14	37	991	3	shamoy
sharpy	14	52	1103	3	sharpy
shimmy	16	30	641	3	shimmy
shlump	13	4	571	3	shlump_
shlumps	14	3	414	3	shlumps
shrimpy	17	41	540	3	shrimpy
simp	8	52	2877	3	s_imp_
simply	13	30	1052	3	s_imply
simps	9	47	1976	3	s_imps
sirupy	11	37	705	3	sirupy
situp	7	44	1406	3	situ_p_
situps	8	53	878	3	situ_ps
skimp	13	54	1132	3	skimp_
skimps	14	48	804	3	skimps
skunky	12	43	616	3	skunky
sleepy	11	47	941	3	sleepy
slimly	11	40	890	3	slimly
slimpsy	14	6	333	3	slimpsy
slimsy	11	40	772	3	slimsy
slimy	10	54	1742	3	slim_y
slippy	13	7	584	3	slippy
sloppy	13	9	530	3	sloppy
sludgy	11	36	625	3	sludgy
sluicy	11	6	648	3	sluicy
slum	6	54	3051	3	slum__
slumped	12	37	1015	3	slumped
slums	7	46	2343	3	slum_s
slurp	7	40	1498	3	slurp_
slurps	8	44	1000	3	slurps
slurry	9	37	860	3	slurry
slushy	12	41	722	3	slushy
slutty	9	24	800	3	slutty
smudgy	13	29	413	3	smudgy
smugly	12	7	483	3	smugly
smutty	11	26	632	3	smutty
snappy	13	6	610	3	snappy
snippy	13	7	484	3	snippy
snoopy	11	44	947	3	snoopy
snubby	13	4	453	3	snubby
snuffy	15	35	624	3	snuffy
snugly	10	5	566	3	snugly
soapy	10	61	1478	3	s_oapy
soppy	12	51	1352	3	s_oppy
soup	6	62	3291	3	sou_p_
soups	7	53	2294	3	sou_ps
sourly	9	36	1221	3	sourly
spume	9	58	1731	3	spum_e
spumed	11	47	1154	3	spumed
spumes	10	213	1488	3	spumes
spunky	15	42	716	3	spunky
spurry	11	42	912	3	spurry
spy	8	60	2374	3	s___py
stably	11	33	1412	3	stably
stagey	10	59	1558	3	stagey
staggy	11	55	1039	3	staggy
stagy	9	66	1889	3	st_agy
stalky	13	49	930	3	stalky
stamen	8	41	1594	3	stamen
stamped	12	48	1281	3	stamped
stamper	11	37	1440	3	stamper
staph	10	43	1465	3	st_aph
starry	9	49	1167	3	starry
stay	7	83	3372	3	st__ay
steady	10	35	1020	3	steady
steamy	11	51	1237	3	steamy
steely	9	36	1257	3	steely
steep	7	60	2070	3	steep_
steeply	12	3	629	3	steeply
steeps	8	52	1519	3	steeps
stem	6	106	2825	3	stem__
stemma	10	32	813	3	stemma
stems	7	52	1995	3	stem_s
step	6	71	2629	3	st_ep_
steppe	10	31	987	3	steppe
steps	7	66	1988	3	st_eps
stewy	11	61	1206	3	st_ewy
stey	7	62	2441	3	st__ey
sticky	15	47	1134	3	sticky
stilly	9	37	1409	3	stilly
stime	7	65	2180	3	stim_e
stimes	8	59	2057	3	stimes
stingy	10	52	1320	3	stingy
stinky	13	46	1107	3	stinky
stipe	7	65	2337	3	st_ipe
stirp	7	68	1550	3	stirp_
stirps	8	50	1182	3	stirps
stithy	12	39	821	3	stithy
stocky	15	36	915	3	stocky
stodgy	11	41	573	3	stodgy
stogey	10	58	1154	3	stogey
stogy	9	54	1408	3	st_ogy
stoma	7	59	1827	3	stom_a
stomal	8	52	1331	3	stomal
stomas	8	48	1632	3	stomas
stomped	12	41	1053	3	stomped
stomper	11	41	1123	3	stomper
stoney	9	62	1735	3	stoney
stony	8	58	1864	3	st_ony
stoop	7	58	2154	3	stoop_
stoops	8	59	1789	3	stoops
stop	6	65	3203	3	st_op_
stope	7	47	2724	3	st_ope
stops	7	48	2728	3	st_ops
stopt	7	65	2835	3	st_opt
storey	9	52	1761	3	storey
stormy	11	55	1073	3	stormy
story	8	67	2303	3	st_ory
stoup	7	55	1707	3	stoup_
stoups	8	53	1327	3	stoups
stoury	9	52	994	3	stoury
stoutly	10	3	583	3	stoutly
stowp	10	56	1423	3	stowp_
stowps	11	57	1058	3	stowps
strap	7	79	2526	3	strap_
strappy	14	20	526	3	strappy
straps	8	77	2178	3	straps
strawy	12	103	1282	3	strawy
stray	8	85	2557	3	st_ray
strep	7	71	2085	3	strep_
streps	8	62	1806	3	streps
strip	7	75	2434	3	strip_
stripe	8	58	2244	3	stripe
strips	8	57	1965	3	strips
stript	8	52	2219	3	stript
strop	7	74	2224	3	strop_
stroppy	14	20	509	3	stroppy
strops	8	62	2038	3	strops
stroy	8	77	2039	3	st_roy
strum	7	56	1945	3	strum__
struma	8	43	1327	3	strum_a
strumae	9	36	809	3	strumae
strumas	9	41	983	3	strumas
strumpet	12	5	603	3	strumpet
strums	8	47	1645	3	strum_s
stub	6	62	2184	3	stu__b
stubbly	14	4	447	3	stubbly
stubs	7	50	1607	3	stu_bs
stucco	10	4	425	3	stucco
stuck	11	45	1577	3	stu_ck
stud	5	62	2009	3	stu__d
studio	7	24	713	3	studio
studs	6	44	1587	3	stu_ds
stuff	11	38	1705	3	stu_ff
stuffs	12	38	1022	3	stuffs
stull	5	49	1627	3	stu_ll
stulls	6	39	1298	3	stulls
stumble	11	4	755	3	stumble
stummed	12	34	855	3	stummed
stumpage	13	4	330	3	stumpage
stumpers	12	31	831	3	stumpers
stumpier	12	5	588	3	stumpier
stumping	13	28	908	3	stumping
stun	4	56	2345	3	stu__n
stung	6	54	1715	3	stu_ng
stunk	9	46	1629	3	stu_nk
stuns	5	47	1949	3	stu_ns
stunt	5	53	2817	3	stu_nt
stunts	6	56	1525	3	stunts
stupas	8	39	1088	3	stupas
stupefy	15	4	290	3	stupefy
stupes	8	41	1695	3	stupes
stupid	9	3	759	3	stupid
stupor	8	3	601	3	stupor
sturt	5	60	2896	3	stu_rt
sturts	6	39	1514	3	sturts
sty	6	62	2731	3	st___y
stymie	11	3	762	3	stymie
sucky	14	44	1550	3	s_ucky
sudsy	9	50	1068	3	s_udsy
suety	8	53	1849	3	s_uety
sulky	12	47	1536	3	s_ulky
sully	8	46	2290	3	s_ully
sum	5	63	4601	3	s_um__
sumac	9	95	1488	3	s_umac
summa	9	47	1331	3	s_umma
sumo	6	73	2631	3	s_um_o
sumos	7	57	2009	3	s_umos
sums	6	58	3758	3	s_um_s
sunny	8	49	1774	3	s_unny
sup	5	70	4194	3	s_u_p_
supe	6	59	3276	3	s_u_pe
supply	13	4	689	3	s_upply
sups	6	48	3443	3	s_u_ps
surfy	11	53	1947	3	s_urfy
surgy	9	51	1852	3	s_urgy
surly	8	51	2443	3	s_urly
swamp	12	50	1532	3	swamp_
swamps	13	59	1026	3	swamps
swamy	13	67	1440	3	swam_y
sweepy	14	44	745	3	sweepy
swimmy	16	23	435	3	swimmy
swoopy	14	48	728	3	swoopy
swum	9	64	1682	3	swum__
syrupy	14	28	582	3	syrupy
tammy	12	40	1322	3	_tammy
tamp	8	61	3300	3	_tamp_
tamps	9	55	2408	3	_tamps
temp	8	53	2333	3	_temp_
tempi	9	49	1220	3	_tempi
tempo	9	52	1497	3	_tempo
temps	9	54	1713	3	_temps
tempt	9	51	2484	3	_tempt
thump	12	62	1157	3	thump_
thumps	13	44	935	3	thumps
tippy	12	54	1179	3	_tippy
tommy	12	47	1223	3	_tommy
trampy	13	49	925	3	trampy
trump	9	56	1512	3	trump_
trumps	10	46	1188	3	trumps
tubby	12	45	1140	3	_tubby
tufty	11	48	1041	3	_tufty
tumefy	14	3	422	3	_tumefy
tumid	8	41	1402	3	_tumid
tumor	7	11	1069	3	_tumor
tumped	11	42	1623	3	_tumped
tunny	8	65	1503	3	_tunny
tup	5	60	3754	3	_tu_p_
tups	6	56	2876	3	_tu_ps
turfy	11	43	1540	3	_turfy
turps	7	49	1873	3	_turps
tushy	11	42	1299	3	_tushy
tutty	8	52	1702	3	_tutty
typy	12	60	1304	3	_t_ypy
ump	7	61	3044	3	__ump_
umps	8	57	2194	3	__umps
vampy	15	53	940	3	_vampy
whump	15	49	1004	3	whump_
whumps	16	42	709	3	whumps
wimpy	15	59	1192	3	_wimpy
yummy	15	42	915	3	_yummy
yuppy	15	48	791	3	_yuppy

Search took 6 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	112716	0.373	479064.3
2	DLD Change Limit	112716	377	4.906	22975.1
3	Display Results	377	377	0.110	3427.3
	(SQL Overall)	178691	377	5.389	33158.5