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

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

348 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
nearby	11	35	605	(None)
nearly	9	48	1373	1	nearly
dearly	10	46	1532	2	dearly
deary	9	58	2684	2	dear_y
derby	11	47	1534	2	de_rby
early	8	53	2412	2	_early
hearty	12	63	1363	2	hearty
herby	13	47	1531	2	he_rby
leary	8	59	2738	2	lear_y
narky	12	60	1780	2	n_arky
nary	7	69	3122	2	n_ar_y
near	4	52	3650	2	near__
neared	7	51	1980	2	neared
nearer	6	46	1889	2	nearer
nears	5	55	2942	2	near_s
neatly	9	38	1248	2	neatly
nerdy	9	50	1470	2	ne_rdy
nervy	11	46	1086	2	ne_rvy
pearly	11	64	1484	2	pearly
teary	8	51	2405	2	tear_y
weary	11	56	2061	2	wear_y
yearly	12	52	1027	2	yearly
aby	8	102	3806	3	__a_by
aery	7	72	3168	3	ae_r_y
alary	8	61	2344	3	alar_y
anear	5	54	2032	3	anear__
aneared	8	5	1274	3	aneared
anears	6	37	1718	3	anear_s
anergy	10	15	686	3	ane_rgy
angary	10	3	1132	3	angar_y
arb	5	104	4842	3	__arb_
arbs	6	68	3473	3	__arbs
army	9	66	2418	3	__army
arty	7	75	3131	3	__arty
aweary	12	3	730	3	awear_y
baby	11	67	2368	3	_ba_by
barb	8	52	4006	3	_barb_
barbe	9	53	2828	3	_barbe
barbs	9	59	2819	3	_barbs
barky	14	57	2161	3	_barky
barmy	12	52	1876	3	_barmy
barny	10	58	2173	3	_barny
beachy	16	40	1125	3	beachy
beady	11	47	1992	3	bea_dy
beaky	14	61	1802	3	bea_ky
beamy	12	62	1857	3	bea_my
bear	6	68	4464	3	bear__
bearably	15	17	793	3	bearably
beard	8	60	2496	3	bear_d
beards	9	41	1667	3	beards
bearer	8	53	2391	3	bearer
bears	7	57	3904	3	bear_s
beauty	11	54	1016	3	beauty
beery	10	52	2012	3	beer_y
berry	10	45	2177	3	be_rry
betray	11	15	1144	3	betray
bewray	14	14	773	3	bewray
blabby	12	3	481	3	blabby
bleary	11	51	1255	3	blear_y
cabby	14	53	1456	3	_cabby
carb	8	51	4316	3	_carb_
carbo	9	49	2384	3	_carbo
carboy	13	49	1418	3	_carboy
carbs	9	60	3146	3	_carbs
carny	10	58	2292	3	_carny
carry	10	58	2378	3	_carry
cedary	12	41	960	3	cedar_y
charry	14	50	1211	3	charry
chary	13	50	2313	3	char_y
clary	10	57	1961	3	clar_y
clearly	12	3	666	3	clearly
corby	12	50	1853	3	_corby
crabby	15	34	675	3	crabby
darb	7	60	3353	3	_darb_
darbs	8	53	2326	3	_darbs
darky	13	60	1883	3	_darky
dauby	11	52	1122	3	_dauby
deadly	11	38	1147	3	deadly
deafly	13	38	912	3	deafly
dear	5	53	4360	3	dear__
dearer	7	48	2280	3	dearer
dearie	7	33	1981	3	dearie
dears	6	57	3688	3	dear_s
dearth	10	42	1251	3	dearth
deathy	13	42	1023	3	deathy
decry	11	55	1435	3	decr_y
defray	13	3	764	3	defray
denary	10	53	1686	3	denar_y
deray	9	50	2418	3	de_ray
derry	9	47	2137	3	de_rry
diary	9	50	1697	3	diar_y
dreary	10	46	1167	3	drear_y
ear	3	68	6788	3	_ear__
earbud	9	3	628	3	_earbud
eared	6	51	3950	3	_eared
earl	4	58	3814	3	_ear_l
earls	5	61	2751	3	_earls
earn	4	67	3755	3	_ear_n
earns	5	59	2756	3	_earns
ears	4	63	5659	3	_ear_s
earth	8	50	2305	3	_earth
earthy	12	39	994	3	_earthy
easy	7	62	2449	3	_ea_sy
eery	7	61	2962	3	_eer_y
energy	10	13	751	3	energy
entry	8	24	1426	3	entr_y
eyry	10	63	1588	3	_eyr_y
faery	11	60	1548	3	faer_y
farcy	13	52	1709	3	_farcy
fealty	12	29	1022	3	fealty
fear	7	53	3779	3	fear__
feared	10	63	2043	3	feared
fearer	9	48	2018	3	fearer
fears	8	48	2939	3	fear_s
featly	12	37	1175	3	featly
ferly	11	55	1735	3	fe_rly
ferny	11	58	1618	3	fe_rny
ferry	11	60	2080	3	fe_rry
flabby	16	3	457	3	flabby
forby	13	53	1767	3	_forby
gabby	13	55	1295	3	_gabby
gaby	10	71	2319	3	_ga_by
garb	7	53	3267	3	_garb_
garbs	8	63	2141	3	_garbs
gear	5	59	3497	3	gear__
gearbox	17	4	295	3	gearbox
geared	8	53	1774	3	geared
gears	6	46	2869	3	gear_s
germy	11	51	1366	3	ge_rmy
gharry	13	54	627	3	gharry
glary	9	60	1854	3	glar_y
gnarly	10	46	1038	3	gnarly
grabby	14	33	618	3	grabby
hardy	12	56	2206	3	_hardy
harpy	13	64	1821	3	_harpy
harry	11	53	2295	3	_harry
heady	12	51	1726	3	hea_dy
heapy	13	59	1498	3	hea_py
hear	7	61	4388	3	hear__
heard	9	52	2275	3	hear_d
hearer	9	43	2364	3	hearer
hears	8	67	3737	3	hear_s
hearsay	13	3	552	3	hearsay
hearse	9	41	1427	3	hearse
heart	8	54	4074	3	hear_t
hearth	12	53	1521	3	hearth
hearts	9	62	1894	3	hearts
heathy	15	61	1121	3	heathy
heavy	14	48	1418	3	hea_vy
henry	11	40	1447	3	henr_y
herb	9	47	3096	3	he_rb_
herbs	10	55	2050	3	he_rbs
hereby	14	46	833	3	hereby
herry	11	49	2247	3	he_rry
hoary	11	45	1676	3	hoar_y
inearth	10	3	704	3	inearth
jerky	19	67	1242	3	je_rky
jerry	15	50	1618	3	je_rry
kerb	10	43	2271	3	ke_rb_
kerbs	11	50	1367	3	ke_rbs
kerry	12	49	1609	3	ke_rry
knarry	13	3	461	3	knarry
lamby	12	51	1484	3	_lamby
lardy	9	61	1927	3	_lardy
larky	12	52	1887	3	_larky
leachy	14	41	973	3	leachy
leady	9	56	1860	3	lea_dy
leafy	11	63	1621	3	lea_fy
leaky	12	52	1772	3	lea_ky
leally	9	40	1261	3	leally
lealty	9	29	1060	3	lealty
leanly	9	38	1150	3	leanly
lear	4	70	4595	3	lear__
learn	5	53	2266	3	lear_n
learns	6	55	1374	3	learns
learnt	6	40	1925	3	learnt
lears	5	59	3873	3	lear_s
leavy	11	57	1577	3	lea_vy
leery	8	59	1913	3	leer_y
linearly	11	4	679	3	linearly
marbly	13	41	1193	3	_marbly
marly	10	69	2561	3	_marly
marry	10	48	2169	3	_marry
marvy	13	50	1403	3	_marvy
mealy	10	44	2218	3	mea_ly
meanly	11	54	1204	3	meanly
meany	10	46	2048	3	mea_ny
measly	11	36	1044	3	measly
meaty	10	70	2131	3	mea_ty
mercy	12	59	1618	3	me_rcy
merry	10	47	2148	3	me_rry
nab	5	69	5492	3	n_a_b_
nabe	6	60	2949	3	n_a_be
nabs	6	62	3619	3	n_a_bs
naggy	10	66	1282	3	n_aggy
nancy	10	52	1492	3	n_ancy
nanny	8	48	1381	3	n_anny
nappy	12	63	1233	3	n_appy
narc	6	71	2795	3	n_ar_c
narco	7	67	1824	3	n_arco
narcs	7	61	2202	3	n_arcs
nard	5	66	3445	3	n_ar_d
nards	6	59	2846	3	n_ards
nares	5	55	4415	3	n_ares
naric	7	68	2417	3	n_aric
naris	5	57	3529	3	n_aris
nark	8	52	3006	3	n_ar_k
narks	9	60	2603	3	n_arks
nasty	8	57	1728	3	n_asty
natty	8	57	1914	3	n_atty
navvy	14	69	668	3	n_avvy
navy	10	75	1863	3	n_a_vy
nay	6	69	5277	3	n_a__y
neap	6	69	2701	3	nea__p
neaps	7	56	1832	3	nea_ps
nearest	7	34	1584	3	nearest
nearing	8	30	2033	3	nearing
neat	4	63	5678	3	nea__t
neaten	6	42	1454	3	neaten
neater	6	44	2431	3	neater
neath	8	60	2028	3	nea_th
neats	5	59	3190	3	nea_ts
neb	5	72	3862	3	ne__b_
nebs	6	61	2498	3	ne__bs
nebuly	11	3	579	3	nebuly
nectary	12	4	622	3	nectar_y
neddy	10	47	987	3	ne_ddy
needy	9	46	1469	3	ne_edy
nelly	8	46	1881	3	ne_lly
nerd	5	66	2494	3	ne_r_d
nerds	6	57	1925	3	ne_rds
nerol	5	10	1781	3	ne_rol
nerts	5	59	2498	3	ne_rts
nertz	14	51	1745	3	ne_rtz
nerve	8	66	1737	3	ne_rve
nettly	9	45	945	3	nettly
netty	8	58	1676	3	ne_tty
neural	6	3	1199	3	neural
neuron	6	3	1037	3	neuron
newly	11	46	1020	3	ne_wly
newsboy	15	4	249	3	newsboy
newsy	11	48	939	3	ne_wsy
nobby	12	55	1346	3	n_obby
notary	9	23	1071	3	notar_y
nubby	12	50	1103	3	n_ubby
onery	8	4	1412	3	one_r_y
orby	9	75	1960	3	__orby
ovary	11	4	911	3	ovar_y
pardy	11	55	2395	3	_pardy
parry	10	53	2375	3	_parry
party	10	66	3061	3	_party
peachy	16	45	1084	3	peachy
peaky	14	57	1815	3	pea_ky
pear	6	97	4523	3	pear__
pearl	7	53	2446	3	pear_l
pearls	8	47	1539	3	pearls
pears	7	51	3861	3	pear_s
peart	7	64	4075	3	pear_t
peartly	12	6	745	3	peartly
peaty	10	57	2569	3	pea_ty
peavey	14	39	879	3	peavey
peavy	13	50	1484	3	pea_vy
peery	10	57	1944	3	peer_y
perdy	11	54	1733	3	pe_rdy
perky	14	53	1948	3	pe_rky
perry	10	52	2271	3	pe_rry
quarry	18	3	747	3	quarry
ready	9	48	2150	3	rea_dy
really	9	33	1561	3	really
realty	9	27	1369	3	realty
rear	4	56	4455	3	rear__
reared	7	59	3001	3	reared
rearer	6	49	2891	3	rearer
rearm	7	59	2357	3	rear_m
rearms	8	51	1465	3	rearms
rears	5	47	3965	3	rear_s
recarry	12	4	506	3	recarry
redry	9	43	1436	3	redr_y
refry	11	44	1246	3	refr_y
remarry	12	3	519	3	remarry
retry	8	47	1808	3	retr_y
sarky	12	55	2178	3	_sarky
scabby	15	3	550	3	scabby
scarey	11	50	1698	3	scarey
scarry	11	63	1118	3	scarry
scary	10	52	2259	3	scar_y
seamy	10	59	2127	3	sea_my
sear	4	73	5384	3	sear__
search	11	33	1242	3	search
seared	7	52	3284	3	seared
searer	6	54	3202	3	searer
sears	5	47	4491	3	sear_s
seaway	12	30	999	3	seaway
senary	9	37	1607	3	senar_y
serry	8	48	2412	3	se_rry
shabby	16	3	580	3	shabby
sharny	12	47	1183	3	sharny
sharpy	14	52	1103	3	sharpy
smarmy	13	62	935	3	smarmy
smarty	11	50	1379	3	smarty
smeary	11	41	1080	3	smear_y
snarky	13	42	1084	3	snarky
snarly	9	38	1500	3	snarly
sneaky	13	42	784	3	snea_ky
sneery	9	36	1041	3	sneer_y
sparky	15	45	1152	3	sparky
sparry	11	51	1130	3	sparry
starry	9	49	1167	3	starry
swabby	16	3	435	3	swabby
swarty	12	58	1238	3	swarty
tabby	12	52	1389	3	_tabby
tardy	9	47	2046	3	_tardy
tarry	8	54	2251	3	_tarry
tarty	8	63	2818	3	_tarty
teapoy	11	3	811	3	teapoy
tear	4	52	4288	3	tear__
teared	7	57	2215	3	teared
tearer	6	48	2290	3	tearer
tearily	10	3	1115	3	tearily
tears	5	54	3646	3	tear_s
terry	8	47	2187	3	te_rry
unary	8	3	1599	3	unar_y
unearth	10	3	706	3	unearth
uneasy	9	27	885	3	unea_sy
unwary	12	3	982	3	unwar_y
unweary	13	3	584	3	unwear_y
vary	10	52	2606	3	_var_y
vealy	11	58	1777	3	vea_ly
veery	11	58	1625	3	veer_y
verb	9	62	2487	3	ve_rb_
verbs	10	46	1439	3	ve_rbs
very	10	80	2564	3	ve_r_y
warty	11	93	2382	3	_warty
wary	10	67	4001	3	_war_y
weakly	16	3	648	3	weakly
wear	7	58	3672	3	wear__
wearer	9	43	1940	3	wearer
wearily	13	3	878	3	wearily
wears	8	60	3030	3	wear_s
webby	15	3	715	3	we_bby
weirdy	13	39	546	3	weirdy
yabby	15	38	975	3	_yabby
year	7	65	3425	3	year__
yearn	8	63	1643	3	year_n
yearns	9	50	954	3	yearns
years	8	45	2767	3	year_s
yeasty	12	43	869	3	yeasty
yerba	10	10	1076	3	ye_rba

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.373	479064.3
2	DLD Change Limit	112716	348	5.533	20371.6
3	Display Results	348	348	0.106	3283.0
	(SQL Overall)	178691	348	6.012	29722.4