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

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

320 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
blenny	11	5	620	(None)
benny	10	52	1736	1	b_enny
bendy	11	50	1725	2	b_endy
benne	7	65	2112	2	b_enne
benni	7	47	1536	2	b_enni
bleary	11	51	1255	2	bleary
blebby	12	3	374	2	blebby
blench	13	37	1045	2	blench
blend	8	53	1745	2	ble_nd
blende	9	54	1344	2	blende
blends	9	60	1288	2	blends
blent	7	62	3095	2	ble_nt
bonny	10	58	1662	2	b_onny
branny	11	51	1183	2	branny
bunny	10	47	1580	2	b_unny
fenny	11	51	1513	2	_fenny
jenny	15	38	1162	2	_jenny
penny	10	51	1945	2	_penny
plenty	11	3	1141	2	plenty
wenny	11	44	1246	2	_wenny
abhenry	15	4	333	3	abhenry
agency	12	3	703	3	agency
alienly	10	3	750	3	alienly
aplenty	12	3	717	3	aplenty
balcony	14	3	585	3	balcony
baleen	8	6	1305	3	baleen_
baleens	9	3	847	3	baleens
baloney	12	3	748	3	baloney
bandy	11	48	2418	3	b_andy
banns	7	53	2123	3	b_anns
banty	10	66	2400	3	b_anty
barney	11	53	1445	3	barney
barny	10	58	2173	3	b_arny
barony	11	59	1530	3	barony
beady	11	47	1992	3	b_eady
beaky	14	61	1802	3	b_eaky
beamy	12	62	1857	3	b_eamy
bean	6	64	4386	3	b_ean_
beano	7	54	2155	3	b_eano
beans	7	57	3469	3	b_eans
beechy	16	39	750	3	beechy
beefy	13	53	1383	3	b_eefy
been	6	53	3578	3	b_een_
beery	10	52	2012	3	b_eery
beigy	11	11	1058	3	b_eigy
being	8	49	2050	3	b_eing
belady	12	48	993	3	belady
belay	10	50	2152	3	b_elay
belfry	14	3	507	3	belfry
belly	10	46	2549	3	b_elly
belon	7	39	2411	3	belon_
belong	9	34	1104	3	belong
belons	8	41	1941	3	belons
ben	5	65	5492	3	b_e_n_
bench	12	56	1950	3	b_ench
bend	7	64	3526	3	b_e_nd
benday	12	38	1081	3	b_enday
bends	8	56	2897	3	b_ends
bendys	12	51	838	3	b_endys
bene	6	64	3949	3	b_e_ne
benes	7	55	3623	3	b_enes
bennes	8	60	1901	3	b_ennes
bennet	8	48	2336	3	b_ennet
bennis	8	43	1480	3	b_ennis
bens	6	59	4570	3	b_e_ns
bent	6	77	5991	3	b_e_nt
bento	7	59	2295	3	b_ento
bents	7	60	3369	3	b_ents
benzyl	20	3	416	3	b_enzyl
berry	10	45	2177	3	b_erry
betony	11	42	1158	3	betony
bevy	12	71	1522	3	b_e_vy
bey	8	66	4542	3	b_e__y
biennia	9	9	493	3	biennia
blabby	12	3	481	3	blabby
blain	7	54	2179	3	blain_
blains	8	45	1637	3	blains
blanch	13	34	1085	3	blanch
bland	8	53	2045	3	bl_and
blandly	13	3	604	3	blandly
blank	11	54	1855	3	bl_ank
blankly	16	3	426	3	blankly
blanks	12	41	1289	3	blanks
blarney	12	17	476	3	blarney
blasty	11	56	1105	3	blasty
blawn	10	68	1370	3	blawn_
bleach	13	36	1140	3	bleach
bleak	11	59	1538	3	ble_ak
bleakly	16	3	466	3	bleakly
bleaks	12	51	1243	3	bleaks
blear	7	59	1868	3	ble_ar
blears	8	51	1645	3	blears
bleat	7	57	3700	3	ble_at
bleats	8	55	1861	3	bleats
bleb	8	54	2522	3	ble__b
blebs	9	64	1615	3	ble_bs
bled	7	57	2931	3	ble__d
bleed	8	50	1980	3	ble_ed
bleeds	9	52	1159	3	bleeds
bleep	9	50	1345	3	ble_ep
bleeps	10	49	910	3	bleeps
blended	11	47	1071	3	blended
blender	10	46	1384	3	blender
blendes	10	47	1368	3	blendes
blending	12	24	996	3	blending
blennies	10	5	693	3	blennies
bless	7	59	1781	3	ble_ss
blest	7	64	3172	3	ble_st
blet	6	62	4767	3	ble__t
blets	7	53	2494	3	ble_ts
blew	9	47	2243	3	ble__w
blimey	13	46	845	3	blimey
blimy	12	52	1282	3	bl_imy
blin	6	72	2817	3	bl_in_
blind	8	63	1932	3	bl_ind
blindly	13	3	574	3	blindly
blinds	9	51	1161	3	blinds
blini	7	55	1927	3	bl_ini
blinis	8	53	1368	3	blinis
blink	11	57	2014	3	bl_ink
blinks	12	46	1357	3	blinks
blintz	17	8	884	3	blintz
blocky	17	38	835	3	blocky
blond	8	56	1837	3	bl_ond
blonde	9	48	1329	3	blonde
blonds	9	52	1334	3	blonds
bloody	12	47	1017	3	bloody
blooey	11	51	1079	3	blooey
bloomy	13	45	1011	3	bloomy
blotty	11	17	834	3	blotty
blousy	11	45	912	3	blousy
blowby	16	46	751	3	blowby
blown	10	57	1667	3	blown_
blowsy	14	57	945	3	blowsy
blowy	13	43	1532	3	bl_owy
blowzy	23	51	667	3	blowzy
blueing	10	37	1020	3	blueing
bluejay	19	4	272	3	bluejay
bluely	11	33	1008	3	bluely
bluesy	11	44	898	3	bluesy
bluey	10	48	1705	3	bl_uey
bluing	9	49	1448	3	bluing
blunge	9	43	1148	3	blunge
blunt	7	55	2502	3	bl_unt
bluntly	12	3	522	3	bluntly
blunts	8	45	1289	3	blunts
blurry	11	43	767	3	blurry
boloney	12	4	776	3	boloney
boney	10	52	2731	3	b_oney
bonne	7	51	2471	3	b_onne
bony	9	67	3208	3	b__ony
botany	11	3	926	3	botany
bouncy	13	40	907	3	bouncy
bounty	11	34	1107	3	bounty
brainy	11	48	1564	3	brainy
brandy	12	47	1206	3	brandy
brawny	14	47	1060	3	brawny
bready	12	45	1118	3	bready
breezy	20	29	585	3	breezy
bren	6	56	2956	3	bre_n_
brens	7	58	2336	3	bre_ns
brent	7	57	3413	3	bre_nt
brents	8	47	1727	3	brents
briny	10	47	1966	3	b_riny
briony	11	4	904	3	briony
bronzy	20	30	671	3	bronzy
browny	14	45	1004	3	browny
bryony	14	3	583	3	bryony
bunn	6	50	2365	3	b_unn_
bunns	7	47	1829	3	b_unns
canny	10	58	1769	3	_canny
clanky	15	46	907	3	clanky
clean	7	54	2041	3	clean_
cleanly	12	3	632	3	cleanly
cleans	8	58	1705	3	cleans
clench	13	39	1005	3	clench
clergy	12	3	499	3	clergy
clingy	12	65	906	3	clingy
clunky	15	44	789	3	clunky
cranny	11	42	1027	3	cranny
deny	8	60	2712	3	_de_ny
djinny	17	3	287	3	djinny
duenna	7	3	459	3	duenna
elegy	9	3	930	3	ele_gy
envy	10	4	1125	3	__envy
evenly	12	3	699	3	evenly
fanny	11	48	1604	3	_fanny
felony	12	37	1032	3	felony
ferny	11	58	1618	3	_ferny
finny	11	47	1675	3	_finny
flecky	18	38	765	3	flecky
fledgy	14	41	491	3	fledgy
fleecy	14	26	648	3	fleecy
flench	14	40	1081	3	flench
flense	9	3	890	3	flense
fleshy	15	40	628	3	fleshy
fleury	12	41	735	3	fleury
fley	10	66	2685	3	fle__y
flinty	12	61	1249	3	flinty
fluency	15	4	535	3	fluency
flunky	16	40	809	3	flunky
frenzy	21	3	588	3	frenzy
funny	11	46	1483	3	_funny
ginny	9	53	1457	3	_ginny
gleamy	12	39	811	3	gleamy
glean	6	58	1820	3	glean_
gleans	7	50	1474	3	gleans
gleety	10	47	919	3	gleety
glegly	11	3	487	3	glegly
glen	5	60	2720	3	gle_n_
glens	6	65	1985	3	gle_ns
gley	8	57	2465	3	gle__y
glinty	10	69	1069	3	glinty
granny	10	43	1116	3	granny
greeny	10	48	1145	3	greeny
gunny	9	44	1366	3	_gunny
henna	8	44	1404	3	_henna
henry	11	40	1447	3	_henry
hinny	11	56	1667	3	_hinny
johnny	19	3	219	3	johnny
keenly	13	3	637	3	keenly
lanky	12	55	1748	3	_lanky
lawny	11	59	1201	3	_lawny
leady	9	56	1860	3	_leady
leafy	11	63	1621	3	_leafy
leaky	12	52	1772	3	_leaky
lean	4	63	4524	3	_lean_
leanly	9	38	1150	3	_leanly
leans	5	55	3625	3	_leans
leant	5	67	3778	3	_leant
leary	8	59	2738	3	_leary
leavy	11	57	1577	3	_leavy
ledgy	10	57	1202	3	_ledgy
leery	8	59	1913	3	_leery
lefty	11	56	1356	3	_lefty
leggy	10	52	1024	3	_leggy
lemony	11	41	955	3	_lemony
lend	5	62	3367	3	_le_nd
lends	6	53	2625	3	_lends
lenes	5	47	3852	3	_lenes
lenis	5	63	2686	3	_lenis
lenity	9	6	1271	3	_lenity
leno	4	73	3139	3	_le_no
lenos	5	60	2486	3	_lenos
lens	4	61	4649	3	_le_ns
lense	5	45	2343	3	_lense
lent	4	63	6053	3	_le_nt
lento	5	72	2339	3	_lento
leone	5	50	1882	3	_leone
levy	10	64	1850	3	_le_vy
ley	6	62	4681	3	_le__y
lezzy	16	60	808	3	_lezzy
lindy	9	69	1831	3	_lindy
lineny	9	40	1144	3	_lineny
liney	8	70	2963	3	_liney
lingy	9	69	2514	3	_lingy
linky	12	76	2238	3	_linky
linn	4	60	3459	3	_linn_
linns	5	61	2333	3	_linns
linty	8	71	2656	3	_linty
liny	7	81	4132	3	_l_iny
loony	8	69	1896	3	_loony
luny	7	73	2413	3	_l_uny
meany	10	46	2048	3	_meany
meiny	10	40	1541	3	_meiny
minny	10	45	1866	3	_minny
nanny	8	48	1381	3	_nanny
ninny	8	45	1493	3	_ninny
olein	5	3	1600	3	olein_
oleine	6	3	1379	3	oleine
oleins	6	3	1352	3	oleins
openly	11	3	712	3	openly
penna	7	45	2020	3	_penna
penne	7	54	2385	3	_penne
penni	7	46	1790	3	_penni
peony	10	57	1756	3	_peony
pinny	10	52	2206	3	_pinny
plena	7	58	1639	3	ple_na
plenary	12	3	754	3	plenary
plench	13	40	1081	3	plench
plenum	10	3	950	3	plenum
pleon	7	42	1638	3	pleon_
pleons	8	42	1334	3	pleons
plunky	15	37	795	3	plunky
punny	10	42	1771	3	_punny
runny	8	46	1348	3	_runny
senna	5	46	1798	3	_senna
shanny	12	41	1009	3	shanny
sheeny	12	49	1219	3	sheeny
shinny	12	48	1078	3	shinny
sienna	6	4	719	3	sienna
skinny	13	45	661	3	skinny
slangy	10	54	1139	3	slangy
slanty	9	51	1484	3	slanty
sleazy	18	26	739	3	sleazy
sleeky	13	39	896	3	sleeky
sleepy	11	47	941	3	sleepy
sleety	9	41	1265	3	sleety
slinky	13	39	910	3	slinky
sonny	8	50	1610	3	_sonny
spendy	12	49	1114	3	spendy
spinny	11	45	1018	3	spinny
spleeny	12	3	456	3	spleeny
sunny	8	49	1774	3	_sunny
swanny	12	33	682	3	swanny
sweeny	12	35	884	3	sweeny
teensy	9	47	827	3	teensy
teeny	8	54	1788	3	_teeny
tenty	8	61	2160	3	_tenty
tinny	8	53	1765	3	_tinny
tranny	9	42	1086	3	tranny
trendy	10	46	960	3	trendy
tunny	8	65	1503	3	_tunny
tweeny	12	47	700	3	tweeny
twenty	12	3	622	3	twenty
valency	15	6	546	3	valency
veiny	11	54	1436	3	_veiny
weensy	12	41	682	3	weensy
weeny	11	53	1616	3	_weeny
whinny	15	58	749	3	whinny

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.390	458182.1
2	DLD Change Limit	112716	320	4.673	24120.7
3	Display Results	320	320	0.090	3555.6
	(SQL Overall)	178691	320	5.153	34677.1