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

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

252 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
belfry	14	3	507	(None)
beefy	13	53	1383	2	beef_y
beery	10	52	2012	2	be_ery
belady	12	48	993	2	belady
belay	10	50	2152	2	bel_ay
belly	10	46	2549	2	bel_ly
berry	10	45	2177	2	be_rry
bleary	11	51	1255	2	bleary
celery	11	3	962	2	celery
peltry	11	28	865	2	peltry
refry	11	44	1246	2	re_fry
aery	7	72	3168	3	ae__ry
alary	8	61	2344	3	_alary
baffy	16	55	1192	3	b_affy
bakery	15	59	1100	3	bakery
baldly	12	47	983	3	baldly
baldy	11	55	1893	3	bal_dy
baler	7	56	3527	3	baler_
balers	8	56	2693	3	balers
balky	14	54	1824	3	bal_ky
ballsy	11	50	887	3	ballsy
bally	10	55	3010	3	bal_ly
balmy	12	52	1747	3	bal_my
barfly	14	33	965	3	barfly
bawdry	15	51	646	3	bawdry
beachy	16	40	1125	3	beachy
beady	11	47	1992	3	be_ady
beaky	14	61	1802	3	be_aky
beamy	12	62	1857	3	be_amy
beanery	12	3	756	3	beanery
bear	6	68	4464	3	be_ar_
beard	8	60	2496	3	be_ard
bears	7	57	3904	3	be_ars
beauty	11	54	1016	3	beauty
bedirty	13	4	418	3	bedirty
beechy	16	39	750	3	beechy
beef	9	62	3368	3	beef__
beefed	12	35	1087	3	beefed
beefily	15	3	561	3	beefily
beefs	10	56	1856	3	beef_s
beer	6	56	3599	3	be_er_
beers	7	56	2839	3	be_ers
befit	10	52	2266	3	be_fit
beflag	12	6	588	3	beflag
beflea	11	4	712	3	beflea
befog	11	5	901	3	be_fog
before	11	4	1015	3	before
befret	11	3	1596	3	be_fret
beggary	14	31	615	3	beggary
begird	10	3	682	3	begird
begirt	9	4	1268	3	begirt
beigy	11	11	1058	3	be_igy
bel	5	71	4846	3	bel___
belaud	9	3	913	3	belaud
belays	11	43	1385	3	belays
belch	12	44	1550	3	bel_ch
beldam	11	4	1011	3	beldam
beleap	10	4	1028	3	beleap
belfried	14	4	420	3	belfried
belfries	13	3	698	3	belfries
belga	8	3	1323	3	bel_ga
belgas	9	3	1171	3	belgas
belie	7	56	3038	3	bel_ie
belied	9	50	2216	3	belied
belief	11	50	1860	3	belief
belier	8	44	2356	3	belier
beliers	9	46	1738	3	beliers
belies	8	46	3105	3	belies
belike	12	46	1628	3	belike
belive	11	54	1530	3	belive
bell	6	62	3718	3	bel__l
bellboy	14	4	512	3	bellboy
belle	7	58	2783	3	bel_le
belled	9	46	2619	3	belled
belles	8	53	2599	3	belles
bellow	11	42	1335	3	bellow
bells	7	64	3216	3	bel_ls
belon	7	39	2411	3	bel_on
belong	9	34	1104	3	belong
belons	8	41	1941	3	belons
below	10	46	1719	3	bel_ow
belows	11	46	1418	3	belows
bels	6	61	4249	3	bel__s
belt	6	57	5403	3	bel__t
belted	9	40	2063	3	belted
belter	8	47	2096	3	belter
belters	9	38	1941	3	belters
belts	7	59	3116	3	bel_ts
beltway	15	6	437	3	beltway
beluga	9	3	623	3	beluga
bemire	10	33	1280	3	bemire
benday	12	38	1081	3	benday
bendy	11	50	1725	3	be_ndy
benny	10	52	1736	3	be_nny
berg	7	54	2554	3	be__rg
berk	10	59	2984	3	be__rk
berm	8	67	3275	3	be__rm
beryl	10	12	1167	3	be__ryl
betony	11	42	1158	3	betony
betray	11	15	1144	3	betray
bevor	10	15	1081	3	bevor_
bevors	11	16	1034	3	bevors
bevy	12	71	1522	3	be__vy
beware	11	3	1371	3	beware
beweary	15	3	622	3	beweary
beworm	13	3	999	3	beworm
beworry	15	4	374	3	beworry
bewray	14	14	773	3	bewray
bey	8	66	4542	3	be___y
biffy	16	47	1113	3	b_iffy
bilby	12	49	1235	3	bil_by
bilgy	11	47	1371	3	bil_gy
biliary	12	3	821	3	biliary
billy	10	55	2536	3	bil_ly
binary	11	3	1222	3	binary
blare	7	58	2623	3	b_lare
blear	7	59	1868	3	blear_
blears	8	51	1645	3	blears
blebby	12	3	374	3	blebby
blenny	11	5	620	3	blenny
blimy	12	52	1282	3	b_limy
blowy	13	43	1532	3	b_lowy
bluey	10	48	1705	3	b_luey
blur	6	60	2053	3	b_lur_
blurb	9	52	1490	3	b_lurb
blurry	11	43	767	3	blurry
blurs	7	46	1908	3	b_lurs
blurt	7	76	2562	3	b_lurt
bolar	7	51	2347	3	bolar_
boldly	12	39	942	3	boldly
bolero	8	4	1209	3	bolero
bolshy	14	4	488	3	bolshy
botfly	14	3	609	3	botfly
bowery	14	60	1211	3	bowery
brewery	15	37	696	3	brewery
briary	11	49	1200	3	briary
briery	11	45	1077	3	briery
buffy	16	50	1337	3	b_uffy
bulgy	11	52	1410	3	bul_gy
bulky	14	62	1557	3	bul_ky
bully	10	51	2481	3	bul_ly
burry	10	52	2156	3	b_urry
bury	9	56	3359	3	b__ury
butlery	12	36	942	3	butlery
calory	11	3	1284	3	calory
cedary	12	41	960	3	cedary
clary	10	57	1961	3	_clary
deafly	13	38	912	3	deafly
deary	9	58	2684	3	de_ary
decry	11	55	1435	3	de_cry
decury	12	7	796	3	decury
defray	13	3	764	3	de_fray
defy	11	49	2126	3	de_f_y
deify	12	41	1276	3	deif_y
delay	9	48	2063	3	del_ay
delf	8	54	3657	3	delf__
delfs	9	49	1867	3	delf_s
delft	9	56	2332	3	delf_t
delfts	10	43	967	3	delfts
delly	9	60	2387	3	del_ly
denary	10	53	1686	3	denary
derry	9	47	2137	3	de_rry
descry	12	5	618	3	descry
eely	7	77	2521	3	eel__y
eery	7	61	2962	3	_e_ery
elegy	9	3	930	3	_elegy
elf	6	61	3852	3	_elf__
elfin	8	43	1246	3	_elfin
elmy	9	56	1679	3	_el_my
emery	10	48	1433	3	_emery
entry	8	24	1426	3	_entry
every	11	52	1545	3	_every
eyry	10	63	1588	3	_e_yry
felly	11	49	2280	3	fel_ly
felonry	13	29	484	3	felonry
felony	12	37	1032	3	felony
ferry	11	60	2080	3	fe_rry
fleury	12	41	735	3	fleury
fry	9	62	2650	3	___fry
gentry	10	34	1044	3	gentry
glary	9	60	1854	3	_glary
glory	9	64	1329	3	_glory
gulfy	12	46	1200	3	gulf_y
hefty	14	61	1213	3	he_fty
hellery	13	32	921	3	hellery
helotry	13	4	565	3	helotry
henry	11	40	1447	3	he_nry
herry	11	49	2247	3	he_rry
jelly	15	42	1825	3	jel_ly
jerry	15	50	1618	3	je_rry
kelly	12	46	1702	3	kel_ly
kelpy	14	51	1068	3	kel_py
kerry	12	49	1609	3	ke_rry
leafy	11	63	1621	3	leaf_y
leary	8	59	2738	3	le_ary
leery	8	59	1913	3	le_ery
lefty	11	56	1356	3	le_fty
lory	7	59	3171	3	__lory
medfly	15	3	522	3	medfly
melody	12	3	720	3	melody
melty	10	49	1836	3	mel_ty
memory	13	3	880	3	memory
merry	10	47	2148	3	me_rry
nelly	8	46	1881	3	nel_ly
palfrey	15	3	334	3	palfrey
paltry	11	49	1040	3	paltry
panfry	14	45	641	3	panfry
pedlary	13	27	754	3	pedlary
pedlery	13	29	708	3	pedlery
peery	10	57	1944	3	pe_ery
pelf	9	70	3145	3	pelf__
pelfs	10	50	1629	3	pelf_s
penury	11	4	810	3	penury
perry	10	52	2271	3	pe_rry
rebury	11	34	921	3	rebury
redry	9	43	1436	3	re_dry
reefy	11	42	1770	3	reef_y
refly	11	39	1456	3	re_fly
reify	11	48	1497	3	reif_y
relay	8	44	2467	3	rel_ay
rely	7	54	2895	3	rel__y
retry	8	47	1808	3	re_try
revery	12	40	1421	3	revery
salary	9	5	1521	3	salary
sealery	10	40	1105	3	sealery
self	7	51	3829	3	self__
selfed	10	3	1091	3	selfed
selfs	8	52	2024	3	self_s
senary	9	37	1607	3	senary
sentry	9	29	1205	3	sentry
serry	8	48	2412	3	se_rry
sulfury	13	4	516	3	sulfury
sultry	9	3	846	3	sultry
sweltry	13	3	341	3	sweltry
teary	8	51	2405	3	te_ary
telfer	9	37	989	3	telfer
telfers	10	29	907	3	telfers
telford	11	4	515	3	telford
telly	8	49	2082	3	tel_ly
terry	8	47	2187	3	te_rry
veery	11	58	1625	3	ve_ery
velar	8	58	1763	3	velar_
velars	9	39	1372	3	velars
velcro	11	4	413	3	velcro
velure	9	3	977	3	velure
venery	12	37	1066	3	venery
very	10	80	2564	3	ve__ry
vestry	12	3	862	3	vestry
volery	12	3	787	3	volery
weary	11	56	2061	3	we_ary
welfare	13	3	571	3	welfare
welly	11	46	2001	3	wel_ly

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.440	406115.9
2	DLD Change Limit	112716	252	6.233	18083.7
3	Display Results	252	252	0.093	2709.7
	(SQL Overall)	178691	252	6.766	26410.1