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

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

282 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
frumpy	16	46	688	(None)
frump	12	69	1256	1	frump_
frumps	13	47	978	1	frumps
grumpy	14	49	815	1	grumpy
brumby	15	38	595	2	brumby
bumpy	14	47	1505	2	_bumpy
clumpy	15	40	957	2	clumpy
crampy	15	47	1099	2	crampy
crimpy	15	48	939	2	crimpy
crumby	15	40	811	2	crumby
crummy	15	36	589	2	crummy
crump	11	56	1642	2	crump_
crumply	16	33	609	2	crumply
crumps	12	45	1434	2	crumps
drumly	12	3	570	2	drumly
dumpy	13	54	1475	2	_dumpy
flump	12	46	1472	2	flump_
flumps	13	51	1250	2	flumps
fruity	12	42	969	2	fruity
frumpily	18	4	332	2	frumpily
fumy	12	71	1858	2	f_um_y
glumpy	14	52	719	2	glumpy
grump	10	51	1531	2	grump_
grumphy	18	44	362	2	grumphy
grumps	11	45	1057	2	grumps
humpy	15	51	1567	2	_humpy
jumpy	19	57	1281	2	_jumpy
lumpy	12	66	1591	2	_lumpy
rummy	12	42	1241	2	_rummy
rump	8	67	2908	2	_rump_
rumply	13	34	857	2	_rumply
rumps	9	59	2229	2	_rumps
stumpy	13	45	813	2	stumpy
trampy	13	49	925	2	trampy
trump	9	56	1512	2	trump_
trumps	10	46	1188	2	trumps
army	9	66	2418	3	ar_m_y
arum	6	61	2903	3	arum__
arums	7	55	1783	3	arum_s
brumal	10	4	950	3	brumal
brume	9	58	1798	3	brum_e
brumes	10	64	1707	3	brumes
brushy	14	46	826	3	brushy
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
cramp	11	51	2069	3	cramp_
cramps	12	56	1556	3	cramps
crappy	15	44	680	3	crappy
creepy	13	41	880	3	creepy
crepy	12	48	1270	3	cr_epy
crimp	11	56	1580	3	crimp_
crimps	12	46	1345	3	crimps
crispy	13	47	856	3	crispy
croupy	13	45	873	3	croupy
cruddy	13	3	419	3	cruddy
crumb	11	43	1359	3	crum_b
crumbly	16	34	752	3	crumbly
crumbs	12	40	923	3	crumbs
crumped	14	43	1122	3	crumped
crumpet	13	37	1106	3	crumpet
crumple	13	36	836	3	crumple
crusty	11	49	1134	3	crusty
cuppy	14	47	1038	3	_cuppy
drippy	14	44	565	3	drippy
droopy	12	45	824	3	droopy
druggy	12	34	474	3	druggy
drum	7	65	2159	3	drum__
drums	8	54	1587	3	drum_s
drupe	8	50	1299	3	dru_pe
dumky	15	45	1134	3	_dumky
dummy	13	47	1278	3	_dummy
dump	9	59	2709	3	_dump_
dumps	10	52	2010	3	_dumps
erupt	7	42	2006	3	eru_pt
faulty	12	42	936	3	faulty
filmy	13	61	1404	3	film_y
firmly	14	3	666	3	firmly
flamy	13	52	1747	3	flam_y
flappy	16	5	448	3	flappy
flimsy	14	34	556	3	flimsy
flippy	16	5	461	3	flippy
floppy	16	5	487	3	floppy
fluffy	14	31	578	3	fluffy
flukey	16	45	981	3	flukey
fluky	15	45	1229	3	flu_ky
flume	10	60	2117	3	flum_e
flumed	12	49	1526	3	flumed
flumes	11	51	1973	3	flumes
flumped	15	37	771	3	flumped
flunky	16	40	809	3	flunky
flurry	12	39	711	3	flurry
flutey	12	52	1252	3	flutey
fluty	11	44	1564	3	flu_ty
foamy	13	53	1320	3	foam_y
forum	10	83	1876	3	forum__
forums	11	46	1184	3	forum_s
foully	12	3	901	3	foully
frame	10	58	2180	3	fram_e
framed	12	51	1652	3	framed
framer	11	48	1744	3	framer
frames	11	51	1986	3	frames
frap	9	59	2581	3	fr_ap_
frappe	13	28	695	3	frappe
fraps	10	56	2055	3	fr_aps
fray	10	54	2890	3	fr__ay
freaky	16	43	923	3	freaky
freely	12	3	1096	3	freely
fremd	11	50	1032	3	frem_d
frenzy	21	3	588	3	frenzy
fretty	12	4	922	3	fretty
friary	12	40	1009	3	friary
frilly	12	41	1144	3	frilly
fringy	13	30	926	3	fringy
frisky	16	40	667	3	frisky
frizzy	20	55	583	3	frizzy
froggy	14	3	449	3	froggy
from	9	69	2392	3	from__
frosty	12	47	1063	3	frosty
frothy	15	57	837	3	frothy
frouzy	21	39	528	3	frouzy
frowsy	15	49	827	3	frowsy
frowzy	24	48	579	3	frowzy
frug	8	65	1710	3	fru__g
frugal	10	3	639	3	frugal
frugs	9	61	1428	3	fru_gs
fruit	8	51	2222	3	fru_it
fruits	9	45	1249	3	fruits
frumenty	16	4	457	3	frumenty
frumpier	15	3	417	3	frumpier
frumpish	18	4	350	3	frumpish
frusta	9	3	745	3	frusta
fry	9	62	2650	3	fr___y
fubsy	13	58	927	3	f_ubsy
fuddy	13	52	1115	3	f_uddy
fuggy	13	54	1167	3	f_uggy
fully	11	48	2086	3	f_ully
fume	9	67	2763	3	f_um_e
fumed	11	61	1882	3	f_umed
fumer	10	59	1823	3	f_umer
fumes	10	52	2470	3	f_umes
fumet	10	56	3022	3	f_umet
funky	15	43	1513	3	f_unky
funny	11	46	1483	3	f_unny
furmety	15	3	481	3	furmety
furmity	15	3	518	3	furmity
furry	11	67	1928	3	f_urry
fury	10	77	2797	3	f_u_ry
furzy	20	101	1606	3	f_urzy
fussy	11	56	1395	3	f_ussy
fusty	11	50	1651	3	f_usty
fuzzy	19	298	1451	3	f_uzzy
gimpy	13	52	1223	3	_gimpy
glumly	12	35	662	3	glumly
gramp	10	62	1832	3	gramp_
grampa	11	50	1017	3	grampa
gramps	11	41	1427	3	gramps
grapy	11	54	1643	3	gr_apy
gremmy	14	5	447	3	gremmy
grimly	12	45	993	3	grimly
grimy	11	43	1260	3	grim_y
grippy	14	44	776	3	grippy
gripy	11	51	1525	3	gr_ipy
grubby	14	32	450	3	grubby
gruffy	16	39	601	3	gruffy
grum	7	56	2508	3	grum__
grumbly	15	35	540	3	grumbly
grume	8	62	1816	3	grum_e
grumes	9	44	1555	3	grumes
grumped	13	33	733	3	grumped
grumpily	16	4	346	3	grumpily
grungy	11	34	597	3	grungy
gulpy	11	46	1276	3	_gulpy
gummy	13	54	1365	3	_gummy
guppy	13	52	1127	3	_guppy
harumph	17	4	293	3	harumph
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
mummy	11	49	1362	3	_mummy
mump	10	54	2572	3	_mump_
mumps	11	56	1910	3	_mumps
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
preppy	12	3	552	3	preppy
primly	13	43	962	3	primly
primp	11	56	1592	3	primp_
primps	12	47	1182	3	primps
prompt	12	3	1301	3	prompt
pulpy	12	46	1236	3	_pulpy
pump	10	57	2685	3	_pump_
pumps	11	55	2060	3	_pumps
puppy	11	49	1241	3	_puppy
rammy	12	43	1249	3	_rammy
ramp	8	59	3400	3	_ramp_
ramps	9	62	2463	3	_ramps
raspy	10	65	1170	3	_raspy
rimy	9	66	2128	3	_rim_y
romp	8	59	2657	3	_romp_
romps	9	46	1754	3	_romps
ropy	9	63	2341	3	_r_opy
roupy	10	61	1271	3	_roupy
rubby	12	44	1386	3	_rubby
ruby	9	78	1994	3	_ru_by
ruddy	10	45	1175	3	_ruddy
rugby	11	44	813	3	_rugby
ruly	7	63	2314	3	_ru_ly
rum	5	66	4464	3	_rum__
rumba	9	36	1251	3	_rumba
rumbly	13	44	1216	3	_rumbly
rumen	7	44	1950	3	_rumen
rumor	7	10	1132	3	_rumor
rumple	10	39	1301	3	_rumple
rumpus	10	45	889	3	_rumpus
rums	6	48	3347	3	_rum_s
runny	8	46	1348	3	_runny
runty	8	61	1904	3	_runty
rushy	11	54	1481	3	_rushy
rusty	8	52	2105	3	_rusty
rutty	8	56	1780	3	_rutty
scrimpy	16	48	613	3	scrimpy
scummy	15	26	522	3	scummy
shlumpy	17	4	286	3	shlumpy
shrimpy	17	41	540	3	shrimpy
sirupy	11	37	705	3	siru_py
skimpy	17	47	572	3	skimpy
slummy	13	32	586	3	slummy
slump	9	48	1663	3	slump_
slumps	10	43	1358	3	slumps
soupy	10	61	1540	3	sou_py
spumy	12	46	1036	3	spum_y
stump	9	46	1646	3	stump_
stumps	10	49	1228	3	stumps
sump	8	63	3153	3	_sump_
sumps	9	50	2343	3	_sumps
swampy	16	43	723	3	swampy
syrupy	14	28	582	3	syru_py
thrummy	17	4	217	3	thrummy
thump	12	62	1157	3	thump_
thumps	13	44	935	3	thumps
tramp	9	63	1977	3	tramp_
tramps	10	51	1445	3	tramps
trimly	11	44	1089	3	trimly
trippy	13	45	780	3	trippy
triumph	14	5	334	3	triumph
tromp	9	58	1580	3	tromp_
trompe	10	56	1126	3	trompe
tromps	10	49	1170	3	tromps
truly	8	41	1155	3	tru_ly
trumped	12	43	971	3	trumped
trumpery	15	3	361	3	trumpery
trumpet	11	38	1072	3	trumpet
trusty	9	47	1011	3	trusty
tummy	12	47	1199	3	_tummy
tump	8	59	2703	3	_tump_
tumps	9	54	2079	3	_tumps
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 7 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.376	475242.0
2	DLD Change Limit	112716	282	5.670	19879.4
3	Display Results	282	282	0.080	3525.0
	(SQL Overall)	178691	282	6.126	29169.3