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

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

313 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
lectern	9	3	703	(None)
lecterns	10	3	594	1	lecterns
decern	9	13	1095	2	dec_ern
extern	13	4	847	2	_extern
lactean	9	5	648	2	lactean
lantern	7	3	1001	2	lantern
leathern	11	39	891	2	leathern
lecher	11	34	1585	2	lecher_
lechers	12	33	1396	2	lechers
lechery	15	25	764	2	lechery
lectin	8	25	1501	2	lect_in
lection	9	26	1486	2	lection
lector	8	35	1499	2	lector_
lectors	9	34	1577	2	lectors
lecture	9	14	952	2	lecture
lefter	9	36	1343	2	lefter_
lenten	6	3	1288	2	lente_n
letter	6	37	2258	2	letter_
letters	7	38	1985	2	letters
lucern	8	4	610	2	luc_ern
pecten	10	27	1110	2	pecte_n
secern	8	10	1022	2	sec_ern
western	10	29	1110	2	western
yestern	10	33	864	2	yestern
alerter	7	21	1151	3	alerter_
astern	6	48	1581	3	_astern
bacterin	12	4	1028	3	bacterin
beaten	8	46	1706	3	beate_n
beater	8	47	2939	3	beater_
beaters	9	49	2504	3	beaters
belter	8	47	2096	3	belter_
belters	9	38	1941	3	belters
better	8	47	2370	3	better_
betters	9	44	2209	3	betters
bittern	9	48	1068	3	bittern
bleater	9	45	1530	3	bleater_
bleaters	10	34	1232	3	bleaters
center	8	44	2141	3	center_
centers	9	44	2060	3	centers
cistern	9	33	1070	3	cistern
cittern	9	33	914	3	cittern
decerns	10	11	905	3	dec_erns
decker	13	52	1599	3	decker_
deckers	14	44	1383	3	deckers
defter	10	42	1592	3	defter_
deter	6	50	2804	3	de_ter_
deters	7	47	2468	3	de_ters
deuteron	9	4	600	3	deuteron
dexter	14	38	1089	3	dexter_
eastern	7	44	1253	3	eastern
eaten	5	53	2305	3	_eate_n
eater	5	46	3984	3	_eater_
eaters	6	55	3595	3	_eaters
eatery	9	53	1635	3	_eatery
elater	6	47	2420	3	elater_
elaterin	8	4	990	3	elaterin
elaters	7	44	2019	3	elaters
elected	10	28	1261	3	electe_d
electee	9	25	1324	3	electe_e
electees	10	23	872	3	electees
election	10	20	1535	3	election
elector	9	33	1326	3	elector_
electors	10	30	1386	3	electors
electret	10	4	1200	3	electret
electro	9	28	1003	3	elect_ro
electron	10	26	1141	3	electron
enter	5	47	2638	3	_enter_
entera	6	42	1683	3	_entera
enteron	7	3	1334	3	_enteron
enters	6	44	2564	3	_enters
erecter	9	31	1339	3	erecter_
erecters	10	26	1161	3	erecters
ester	5	47	2771	3	_ester_
esters	6	46	2773	3	_esters
eterne	6	3	1172	3	_e_terne
externe	14	3	857	3	_externe
externs	14	3	823	3	_externs
feater	9	52	2405	3	feater_
fester	9	47	2351	3	fester_
festers	10	41	2139	3	festers
fetter	9	41	2038	3	fetter_
fetters	10	35	1790	3	fetters
flection	13	23	956	3	flection
fleeter	10	32	1036	3	fleeter_
getter	7	41	1761	3	getter_
getters	8	42	1610	3	getters
gittern	8	33	750	3	gittern
heater	9	48	2830	3	heater_
heaters	10	42	2522	3	heaters
hectare	12	3	847	3	hectare
hector	11	33	1265	3	hector_
hectors	12	35	1326	3	hectors
hefter	12	43	1392	3	hefter_
hefters	13	43	1200	3	hefters
hetero	9	3	1263	3	he_tero
intern	6	40	1654	3	_intern
jester	13	43	1915	3	jester_
jesters	14	41	1819	3	jesters
kelter	10	32	1438	3	kelter_
kelters	11	38	1375	3	kelters
lacer	7	58	3375	3	lac_er_
lacers	8	52	2525	3	lac_ers
lacier	8	40	2009	3	lacier_
lacker	12	53	2562	3	lacker_
lackers	13	41	2054	3	lackers
lactary	12	3	785	3	lactary
lacteal	9	6	682	3	lacteal
lanterns	8	3	830	3	lanterns
laster	6	48	3063	3	laster_
lasters	7	56	2769	3	lasters
lateen	6	40	1486	3	l_ateen
laten	5	43	2834	3	l_ate_n
later	5	48	4392	3	l_ater_
latten	6	50	1820	3	latte_n
latter	6	50	2789	3	latter_
leacher	12	40	1484	3	leacher_
leachers	13	37	1281	3	leachers
leaden	7	45	1522	3	leade_n
leader	7	48	2465	3	leader_
leaders	8	38	1960	3	leaders
leaker	10	46	2007	3	leaker_
leakers	11	34	1542	3	leakers
leaner	6	40	2219	3	leaner_
leaners	7	37	1817	3	leaners
leaper	8	81	1894	3	leaper_
leapers	9	37	1666	3	leapers
learn	5	53	2266	3	le__arn
leaser	6	53	2267	3	leaser_
leasers	7	47	1784	3	leasers
leather	10	38	1578	3	leather_
leathers	11	42	1508	3	leathers
leathery	14	43	897	3	leathery
leaven	9	50	1307	3	leave_n
leaver	9	43	2151	3	leaver_
leavers	10	37	1778	3	leavers
leben	7	3	1485	3	le_be_n
leched	12	37	1600	3	leche_d
lechered	14	3	752	3	lechered
lechering	15	3	844	3	lechering
leches	11	54	2131	3	leche_s
lecithin	13	4	431	3	lecithin
lectins	9	25	1500	3	lectins
lections	10	24	1384	3	lections
lectured	11	12	723	3	lectured
lecturer	10	13	603	3	lecturer
lecturers	11	12	423	3	lecturers
lectures	10	13	1016	3	lectures
lecturing	12	3	730	3	lecturing
ledger	8	59	1439	3	ledger_
ledgers	9	49	1218	3	ledgers
leer	4	62	3935	3	le__er_
leers	5	48	2898	3	le__ers
leery	8	59	1913	3	le__ery
leftest	10	26	946	3	leftest
leger	6	57	2151	3	le_ger_
legers	7	45	1831	3	le_gers
leghorn	11	4	622	3	leghorn
legmen	9	3	934	3	legme_n
leister	7	32	1275	3	leister_
leisters	8	33	1282	3	leisters
lender	7	39	2127	3	lender_
lenders	8	44	1964	3	lenders
leotard	8	4	619	3	leotard
leper	7	48	2074	3	le_per_
lepers	8	48	1732	3	le_pers
leptin	8	25	1233	3	lept_in
lepton	8	25	1080	3	lept_on
lessen	6	42	1243	3	lesse_n
lesser	6	35	1485	3	lesser_
lethean	10	3	709	3	lethean
letted	7	41	1854	3	lette_d
lettered	9	29	1078	3	lettered
letterer	8	25	922	3	letterer
lettering	10	21	1207	3	lettering
letterman	11	6	424	3	letterman
lettermen	11	6	428	3	lettermen
lever	8	51	2516	3	le_ver_
levers	9	46	2132	3	le_vers
levier	9	40	1387	3	levier_
leviers	10	35	1034	3	leviers
lewder	10	47	961	3	lewder_
lichen	11	40	1274	3	liche_n
licker	12	52	2204	3	licker_
lickers	13	41	1825	3	lickers
lictor	8	36	1086	3	lictor_
lictors	9	32	1260	3	lictors
lientery	11	3	488	3	lientery
lifter	9	38	1481	3	lifter_
lifters	10	43	1378	3	lifters
linter	6	46	2534	3	linter_
linters	7	38	2263	3	linters
listen	6	48	1681	3	liste_n
lister	6	45	2725	3	lister_
listers	7	40	2653	3	listers
liter	5	47	3634	3	l_iter_
liters	6	54	2988	3	l_iters
litten	6	40	1487	3	litte_n
litter	6	43	2485	3	litter_
litters	7	34	2257	3	litters
littery	10	37	1049	3	littery
locater	9	31	1360	3	locater_
locaters	10	27	1007	3	locaters
locker	12	40	1942	3	locker_
lockers	13	35	1692	3	lockers
lofter	9	46	1472	3	lofter_
lofters	10	39	1290	3	lofters
loiter	6	46	1917	3	loiter_
loiters	7	41	1661	3	loiters
looter	6	42	2232	3	looter_
looters	7	44	1916	3	looters
lotter	6	40	2560	3	lotter_
lotters	7	39	2106	3	lotters
lottery	10	38	983	3	lottery
lucerne	9	4	575	3	luc_erne
lucerns	9	3	575	3	luc_erns
luster	6	40	2367	3	luster_
lusters	7	39	2144	3	lusters
lutein	6	3	1126	3	l_utein
luthern	10	3	765	3	luthern
meeter	8	36	1650	3	meeter_
meeters	9	47	1454	3	meeters
melter	8	35	2011	3	melter_
melters	9	39	1831	3	melters
meter	7	51	3032	3	me_ter_
meters	8	56	2583	3	me_ters
neaten	6	42	1454	3	neate_n
neater	6	44	2431	3	neater_
necker	12	40	1279	3	necker_
neckers	13	42	1046	3	neckers
nectar	8	3	885	3	nectar_
nectars	9	3	846	3	nectars
nectary	12	4	622	3	nectary
nester	6	41	2418	3	nester_
nesters	7	44	2279	3	nesters
netter	6	37	2202	3	netter_
netters	7	36	1858	3	netters
neuter	6	37	1379	3	neuter_
neuters	7	42	1227	3	neuters
nocturn	9	4	465	3	nocturn
pastern	9	44	1506	3	pastern
pattern	9	37	1205	3	pattern
pecker	14	46	1536	3	pecker_
peckers	15	33	1267	3	peckers
pectens	11	18	920	3	pectens
pectin	10	26	1553	3	pect_in
pelter	8	33	2162	3	pelter_
pelters	9	37	2031	3	pelters
perter	8	44	2228	3	perter_
pester	8	48	2759	3	pester_
pesters	9	38	2709	3	pesters
peter	7	44	2759	3	pe_ter_
peters	8	66	2459	3	pe_ters
petter	8	39	2477	3	petter_
petters	9	37	2236	3	petters
pewter	11	40	1367	3	pewter_
pewters	12	41	1335	3	pewters
pleater	9	39	1633	3	pleater_
pleaters	10	36	1379	3	pleaters
plectra	11	4	579	3	plect_ra
plectron	12	22	802	3	plectron
postern	9	36	1561	3	postern
reciter	9	41	1726	3	reciter_
reciters	10	26	1311	3	reciters
reclean	9	3	852	3	reclean
rector	8	40	1975	3	rector_
rectors	9	35	2052	3	rectors
rectory	12	35	1273	3	rectory
renter	6	45	2741	3	renter_
renters	7	42	2482	3	renters
rester	6	38	3243	3	rester_
resters	7	41	3040	3	resters
retorn	6	109	2343	3	re_torn
return	6	232	2252	3	re_turn
saltern	7	40	1065	3	saltern
seater	6	45	3416	3	seater_
seaters	7	40	2894	3	seaters
secerns	9	8	773	3	sec_erns
sectary	12	3	827	3	sectary
section	9	25	1566	3	section
sector	8	34	1593	3	sector_
sectors	9	31	1645	3	sectors
setter	6	40	2372	3	setter_
setters	7	38	2206	3	setters
slattern	8	3	709	3	slattern
specter	11	31	1173	3	specter_
specters	12	28	1106	3	specters
stern	5	53	1912	3	__stern
teeter	6	54	2031	3	teeter_
teeters	7	40	1830	3	teeters
tenter	6	46	2393	3	tenter_
tenters	7	39	2111	3	tenters
tern	4	61	3480	3	___tern
tester	6	42	2715	3	tester_
testers	7	41	2454	3	testers
tetter	6	43	2245	3	tetter_
tetters	7	43	2047	3	tetters
vector	11	32	1206	3	vector_
vectors	12	32	1259	3	vectors
venter	9	42	1872	3	venter_
venters	10	37	1773	3	venters
veteran	10	3	935	3	ve_teran
vetter	9	34	1764	3	vetter_
vetters	10	40	1632	3	vetters
welter	9	34	1738	3	welter_
welters	10	35	1606	3	welters
wester	9	42	2289	3	wester_
westerns	11	32	896	3	westerns
westers	10	52	2196	3	westers
wetter	9	39	1944	3	wetter_
wetters	10	38	1775	3	wetters
yester	9	34	1798	3	yester_
zester	15	36	1779	3	zester_
zesters	16	35	1729	3	zesters

Search took 8 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	134027	0.420	425454.8
2	DLD Change Limit	134027	313	6.546	20474.6
3	Display Results	313	313	0.126	2484.1
	(SQL Overall)	178691	313	7.092	25196.1