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

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

394 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
fretty	12	4	922	(None)
pretty	11	5	1087	1	pretty
bratty	11	5	968	2	bratty
fatty	11	51	1741	2	f_atty
ferity	12	28	1334	2	ferity
freaky	16	43	923	2	freaky
freely	12	3	1095	2	freely
frenzy	21	3	588	2	frenzy
fret	7	58	4504	2	fre_t_
frets	8	55	2340	2	fre_ts
fretted	11	34	1185	2	fretted
fretter	10	34	1275	2	fretter
fritt	8	61	2941	2	fritt_
fritts	9	46	1319	2	fritts
frosty	12	47	1063	2	frosty
frothy	15	57	837	2	frothy
fruity	12	42	969	2	fruity
gritty	10	33	840	2	gritty
grotty	10	38	983	2	grotty
jetty	15	62	1258	2	_jetty
netty	8	58	1676	2	_netty
petty	10	53	2029	2	_petty
ratty	8	48	1959	2	_ratty
retry	8	47	1808	2	_retry
rutty	8	56	1780	2	_rutty
treaty	9	44	1435	2	treaty
afreet	9	3	1515	3	afreet_
afreets	10	3	701	3	afreets
arete	5	60	3135	3	are_te
aretes	6	44	2535	3	aretes
arietta	7	8	890	3	arietta
ariette	7	3	1237	3	ariette
artery	9	9	1145	3	artery
artsy	8	60	1296	3	ar_tsy
arty	7	75	3131	3	ar__ty
batty	10	54	2224	3	_batty
beretta	9	3	846	3	beretta
betta	7	49	1684	3	_betta
biretta	9	4	724	3	biretta
bitty	10	61	1917	3	_bitty
blotty	11	17	834	3	blotty
bready	12	45	1118	3	bready
breath	11	39	1626	3	breath
breathy	15	32	803	3	breathy
breezy	20	29	585	3	breezy
brent	7	57	3413	3	brent_
brents	8	47	1727	3	brents
brevity	15	3	478	3	brevity
britt	7	57	3223	3	britt_
brittly	12	16	597	3	brittly
britts	8	48	1344	3	britts
brothy	14	51	962	3	brothy
burette	9	3	985	3	burette
butty	10	40	2011	3	_butty
catty	10	45	2041	3	_catty
chatty	14	41	936	3	chatty
cherty	14	46	1247	3	cherty
chesty	14	46	1050	3	chesty
chitty	14	32	943	3	chitty
clotty	11	20	826	3	clotty
crafty	14	47	891	3	crafty
creaky	15	49	1155	3	creaky
creamy	13	48	1136	3	creamy
creasy	11	46	1230	3	creasy
create	8	51	2638	3	create
creepy	13	41	880	3	creepy
crepey	13	51	1093	3	crepey
crept	9	51	2589	3	crept_
crepy	12	48	1270	3	cre_py
cressy	11	43	911	3	cressy
crest	7	46	3269	3	crest_
crests	8	52	1870	3	crests
cretic	10	28	1628	3	cretic
cretin	8	29	1791	3	cretin
cruelty	12	3	411	3	cruelty
crusty	11	49	1134	3	crusty
curette	9	3	978	3	curette
cutty	10	54	1722	3	_cutty
deity	9	43	1677	3	_deity
ditty	9	50	1929	3	_ditty
dotty	9	45	1610	3	_dotty
drafty	13	63	893	3	drafty
dreamy	12	50	999	3	dreamy
dreary	10	46	1167	3	dreary
drecky	16	48	633	3	drecky
dreggy	12	36	463	3	dreggy
dressy	10	51	814	3	dressy
drest	6	55	3034	3	drest_
drifty	13	41	822	3	drifty
erect	7	41	2933	3	erect_
erectly	12	5	747	3	erectly
erects	8	41	1618	3	erects
faery	11	60	1548	3	fae_ry
fatly	11	57	1680	3	f_atly
faulty	12	42	936	3	faulty
fealty	12	29	1022	3	fealty
feat	7	64	5822	3	f_eat_
featly	12	37	1175	3	featly
feats	8	64	3275	3	f_eats
feebly	14	3	665	3	feebly
feet	7	53	5221	3	f_eet_
feisty	12	44	929	3	feisty
felly	11	49	2280	3	f_elly
felt	7	51	4693	3	f_elt_
felts	8	53	2454	3	f_elts
fenny	11	51	1513	3	f_enny
feretory	14	4	750	3	feretory
ferly	11	55	1735	3	f_erly
ferny	11	58	1618	3	f_erny
ferrety	13	28	701	3	ferrety
ferry	11	60	2080	3	f_erry
fest	7	49	4944	3	f_est_
fests	8	58	2804	3	f_ests
fet	6	64	7163	3	f_e_t_
feta	7	65	2890	3	f_e_ta
fetal	8	56	2337	3	f_etal
fetas	8	56	2440	3	f_etas
fetch	13	49	1347	3	f_etch
fete	7	57	3492	3	f_e_te
feted	9	44	2093	3	f_eted
fetes	8	56	3014	3	f_etes
fetid	9	37	1598	3	f_etid
fetor	8	12	1453	3	f_etor
fets	7	53	4594	3	f_e_ts
fetted	10	48	1789	3	f_etted
fetter	9	41	2038	3	f_etter
fettle	9	37	1312	3	f_ettle
fetus	8	58	1654	3	f_etus
fey	9	59	4088	3	f_e__y
feyly	14	42	951	3	f_eyly
fezzy	19	98	1145	3	f_ezzy
fiery	11	47	1479	3	fie_ry
fiesta	9	3	812	3	fiesta
fifty	14	52	1142	3	f_ifty
filthy	15	35	642	3	filthy
firefly	16	3	563	3	firefly
firstly	13	3	564	3	firstly
fitly	11	51	1497	3	f_itly
fixity	19	42	780	3	fixity
flatly	12	31	1021	3	flatly
flecky	18	38	765	3	flecky
fledgy	14	41	491	3	fledgy
fleecy	14	26	648	3	fleecy
fleet	8	59	3233	3	fleet_
fleetly	13	3	631	3	fleetly
fleets	9	69	1506	3	fleets
fleshy	15	40	628	3	fleshy
fletch	14	38	819	3	fletch
fleury	12	41	735	3	fleury
fley	10	66	2685	3	fle__y
flinty	12	61	1249	3	flinty
flirty	12	49	914	3	flirty
floaty	12	42	1094	3	floaty
flutey	12	52	1252	3	flutey
fluty	11	44	1564	3	f_luty
foetal	9	3	1188	3	foetal
foetid	10	5	1051	3	foetid
foetor	9	3	956	3	foetor
foetus	9	5	852	3	foetus
footsy	12	58	793	3	footsy
footy	11	58	2053	3	f_ooty
forebay	15	3	813	3	forebay
foreby	14	3	863	3	fore_by
forest	9	49	2674	3	forest_
forestay	14	4	819	3	forestay
forestry	14	4	672	3	forestry
forests	10	41	1495	3	forests
foretop	12	11	789	3	foretop
forty	11	48	2427	3	f_orty
fouette	10	3	821	3	fouette
fracti	11	3	996	3	fracti
frailty	13	3	566	3	frailty
frat	7	56	4854	3	fr_at_
frater	9	45	2059	3	frater
frats	8	68	2967	3	fr_ats
fray	10	54	2890	3	fr__ay
freak	12	51	1524	3	fre_ak
freaks	13	47	1306	3	freaks
freckly	19	12	459	3	freckly
free	7	59	4018	3	fre__e
freed	9	52	2354	3	fre_ed
freer	8	60	2124	3	fre_er
freers	9	47	1730	3	freers
frees	8	61	3139	3	fre_es
freest	9	53	1828	3	freest
freeway	16	3	560	3	freeway
freeze	18	34	951	3	freeze
fremd	11	50	1032	3	fre_md
frena	8	59	1527	3	fre_na
french	14	35	1121	3	french
frenum	11	8	880	3	frenum
frere	8	56	1772	3	fre_re
freres	9	47	1617	3	freres
fresco	11	3	647	3	fresco
fresh	11	50	1220	3	fre_sh
freshly	16	28	683	3	freshly
fretful	13	4	614	3	fretful
fretsaw	13	4	392	3	fretsaw
fretters	11	34	1030	3	fretters
frettier	11	5	659	3	frettier
fretting	12	27	1152	3	fretting
friary	12	40	1009	3	friary
frilly	12	41	1144	3	frilly
fringy	13	30	926	3	fringy
frisette	11	9	548	3	frisette
frisky	16	40	667	3	frisky
frit	7	70	4447	3	fr_it_
frites	9	49	2248	3	frites
frith	11	59	2203	3	fr_ith
friths	12	43	1358	3	friths
frits	8	61	2910	3	fr_its
fritted	11	36	1133	3	fritted
fritter	10	39	1277	3	fritter
fritz	17	60	2077	3	fr_itz
frizette	20	9	350	3	frizette
frizzy	20	55	583	3	frizzy
froggy	14	3	449	3	froggy
fromenty	16	4	524	3	fromenty
front	8	50	2922	3	front_
fronts	9	44	1579	3	fronts
frost	8	47	2783	3	frost_
frosts	9	42	1462	3	frosts
froth	11	59	1928	3	fr_oth
froths	12	54	1144	3	froths
frouzy	21	39	528	3	frouzy
frowsty	16	46	498	3	frowsty
frowsy	15	49	827	3	frowsy
frowzy	24	48	579	3	frowzy
fruit	8	51	2222	3	fruit_
fruits	9	45	1249	3	fruits
frumenty	16	4	457	3	frumenty
frumpy	16	46	688	3	frumpy
frusta	9	3	745	3	frusta
fry	9	62	2650	3	fr___y
fumette	12	4	552	3	fumette
furmenty	16	4	529	3	furmenty
furmety	15	3	481	3	furmety
furmity	15	3	518	3	furmity
fusty	11	50	1651	3	f_usty
fytte	11	3	858	3	f_ytte
ghetto	10	3	607	3	ghetto
gleety	10	47	919	3	gleety
gnatty	10	33	648	3	gnatty
greasy	10	41	946	3	greasy
great	6	60	3424	3	great_
greatly	11	3	761	3	greatly
greats	7	63	1839	3	greats
greedy	11	51	884	3	greedy
greeny	10	48	1145	3	greeny
greet	6	58	3532	3	greet_
greets	7	51	1742	3	greets
gremmy	14	5	447	3	gremmy
grey	8	56	2404	3	gre__y
greyly	13	31	654	3	greyly
grotto	7	34	981	3	grotto
grouty	10	47	1098	3	grouty
gutty	9	45	1699	3	_gutty
hefty	14	61	1213	3	_hefty
jotty	15	50	1260	3	_jotty
jutty	15	49	1464	3	_jutty
kitty	12	46	1456	3	_kitty
knotty	13	31	522	3	knotty
lefty	11	56	1356	3	_lefty
meaty	10	70	2131	3	_meaty
meetly	11	3	867	3	meetly
melty	10	49	1836	3	_melty
natty	8	57	1914	3	_natty
nett	4	66	4323	3	_nett_
nettly	9	45	945	3	_nettly
netts	5	53	2072	3	_netts
nitty	8	54	1831	3	_nitty
nutty	8	48	1687	3	_nutty
patty	10	47	2361	3	_patty
peaty	10	57	2569	3	_peaty
pertly	11	53	1254	3	pertly
pesty	10	64	2171	3	_pesty
petti	7	51	1945	3	_petti
petto	7	60	2104	3	_petto
piety	10	58	1730	3	pie_ty
plenty	11	3	1141	3	plenty
plotty	11	20	885	3	plotty
poetry	11	3	938	3	poetry
potty	10	56	2100	3	_potty
prebuy	13	5	742	3	prebuy
predry	12	3	786	3	predry
prepay	13	3	1031	3	prepay
preppy	12	3	552	3	preppy
prest	7	57	3635	3	prest_
presto	8	42	1620	3	presto
prests	8	40	2126	3	prests
pretax	15	23	1019	3	pretax
pretor	8	3	1574	3	pretor
prettify	16	4	434	3	prettify
prettily	13	3	727	3	prettily
prexy	17	46	1157	3	pre_xy
prey	9	62	2848	3	pre__y
proette	9	3	1236	3	proette
putty	10	47	2140	3	_putty
qwerty	21	3	358	3	qwerty
rattly	9	41	1154	3	_rattly
ready	9	48	2150	3	_ready
realty	9	27	1369	3	_realty
reata	5	42	2539	3	_reata
rebuy	10	47	1468	3	_rebuy
recta	7	42	2026	3	_recta
recti	7	36	1962	3	_recti
recto	7	45	2080	3	_recto
redly	9	42	1719	3	_redly
redry	9	43	1436	3	_redry
reedy	9	100	2028	3	_reedy
reefy	11	42	1770	3	_reefy
reeky	12	54	1626	3	_reeky
refly	11	39	1456	3	_refly
refry	11	44	1246	3	_refry
reft	7	51	4127	3	_reft_
reify	11	48	1497	3	_reify
rekey	12	40	1473	3	_rekey
relay	8	44	2467	3	_relay
rely	7	54	2895	3	_re_ly
rent	4	66	6124	3	_rent_
rente	5	47	3378	3	_rente
rents	5	59	3518	3	_rents
repay	10	48	1845	3	_repay
reply	10	40	1585	3	_reply
resay	8	53	2054	3	_resay
rest	4	64	5984	3	_rest_
rests	5	49	3587	3	_rests
ret	3	59	8283	3	_re_t_
retag	6	36	1841	3	_retag
retax	12	45	1797	3	_retax
retch	10	48	1830	3	_retch
rete	4	49	4413	3	_re_te
retem	7	42	2195	3	_retem
retia	5	53	2611	3	_retia
retie	5	57	3530	3	_retie
retro	5	50	2095	3	_retro
rets	4	53	5256	3	_re_ts
retted	7	48	2631	3	_retted
ritzy	17	56	1116	3	_ritzy
rooty	8	64	2302	3	_rooty
rotte	5	46	2593	3	_rotte
runty	8	61	1904	3	_runty
rusty	8	52	2105	3	_rusty
scatty	11	53	1065	3	scatty
sett	4	59	4905	3	_sett_
setts	5	51	2432	3	_setts
shelty	12	40	1155	3	shelty
shitty	12	41	1006	3	shitty
sleety	9	41	1265	3	sleety
slitty	9	32	916	3	slitty
slutty	9	24	800	3	slutty
smutty	11	26	632	3	smutty
snotty	9	48	920	3	snotty
spotty	11	44	858	3	spotty
stretta	7	3	729	3	stretta
strette	7	3	1076	3	strette
stretti	7	4	791	3	stretti
stretto	7	3	772	3	stretto
suety	8	53	1849	3	sue_ty
surety	9	35	1501	3	sure_ty
sweaty	12	37	1005	3	sweaty
syrette	10	3	718	3	syrette
tatty	8	47	2018	3	_tatty
tenty	8	61	2160	3	_tenty
testy	8	54	1906	3	_testy
titty	8	53	1665	3	_titty
treat	5	62	4035	3	treat_
treats	6	48	2169	3	treats
trebly	11	3	897	3	trebly
trendy	10	46	960	3	trendy
tressy	9	44	855	3	tressy
tret	4	66	5353	3	tre_t_
trets	5	59	2802	3	tre_ts
trey	7	72	2879	3	tre__y
trouty	9	52	1179	3	trouty
trusty	9	47	1011	3	trusty
tutty	8	52	1702	3	_tutty
twenty	12	3	622	3	twenty
unpretty	13	4	326	3	unpretty
ureter	6	3	1320	3	ureter
uretic	8	29	1435	3	uretic
verity	12	37	1485	3	verity
wetly	11	45	1171	3	_wetly
witty	11	47	1701	3	_witty
wrathy	15	37	785	3	wrathy
wreath	12	41	1119	3	wreath
wreathy	16	32	606	3	wreathy
wrest	8	49	2543	3	wrest_
wrests	9	53	1308	3	wrests
wretch	14	32	653	3	wretch
wristy	12	50	970	3	wristy
yett	7	64	3449	3	_yett_
yetts	8	67	1513	3	_yetts
zesty	17	65	1216	3	_zesty

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.140	1276364.3
2	DLD Change Limit	112716	394	5.640	19985.1
3	Display Results	394	394	0.110	3581.8
	(SQL Overall)	178691	394	5.890	30338.0