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

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

380 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
lucern	8	4	610	(None)
lucerne	9	4	575	1	lucerne
lucerns	9	3	575	1	lucerns
decern	9	13	1095	2	decern
lacer	7	58	3375	2	lacer_
lacers	8	52	2525	2	lacers
lectern	9	3	703	2	lectern
lucarne	9	4	426	2	lucarne
luce	6	51	3257	2	luce__
lucent	8	3	1382	2	lucent
lucernes	10	4	636	2	lucernes
luces	7	55	2843	2	luce_s
lucre	7	64	1552	2	luc_re
lucres	8	45	1330	2	lucres
luger	6	53	2208	2	luger_
lugers	7	46	1702	2	lugers
lumen	7	52	2090	2	lume_n
lurer	5	46	2531	2	lurer_
lurers	6	42	1749	2	lurers
lutein	6	3	1126	2	lutein
luthern	10	3	765	2	luthern
quern	14	36	1040	2	qu_ern
secern	8	10	1022	2	secern
ulcer	7	3	1075	2	ulcer_
ulcers	8	3	938	2	ulcers
acerb	9	3	1276	3	_acerb
acorn	7	56	1662	3	_acorn
astern	6	48	1581	3	astern
auburn	8	3	621	3	auburn
auger	6	49	2247	3	auger_
augers	7	38	1870	3	augers
bicorn	10	36	1010	3	bicorn
blucher	14	33	1022	3	blucher_
bluchers	15	35	903	3	bluchers
bluer	7	49	1849	3	blu_er_
buckeen	15	3	670	3	buckeen
bucker	14	54	2046	3	bucker_
buckers	15	35	1745	3	buckers
buckra	14	3	675	3	buckra
burn	6	56	3643	3	bu__rn
buyer	10	50	1309	3	buyer_
buyers	11	45	1100	3	buyers
carn	6	62	4543	3	__carn
casern	8	47	1331	3	casern
cavern	11	53	1245	3	cavern
cere	6	67	4147	3	__cere
cero	6	63	2945	3	__cero
cicero	10	4	850	3	cicero
concern	11	30	1196	3	concern
corn	6	99	4581	3	__corn
cuber	9	52	2253	3	cuber_
cubers	10	53	1835	3	cubers
curer	7	50	3075	3	curer_
curers	8	49	2319	3	curers
curn	6	67	3189	3	__curn
cuter	7	47	2823	3	cuter_
decerns	10	11	905	3	decerns
dicer	8	54	2642	3	dicer_
dicers	9	47	2074	3	dicers
discern	10	3	849	3	discern
duce	7	69	3350	3	duce__
duces	8	63	2747	3	duce_s
ducker	13	43	1799	3	ducker_
duckers	14	32	1471	3	duckers
dudeen	8	5	717	3	dudeen
duper	8	55	1900	3	duper_
dupers	9	46	1560	3	dupers
dupery	12	37	874	3	dupery
durn	5	61	2763	3	du__rn
eluder	7	37	1221	3	eluder_
eluders	8	40	990	3	eluders
ern	3	57	3836	3	___ern
euchre	11	13	766	3	euchre
extern	13	4	847	3	extern
facer	10	55	2505	3	facer_
facers	11	55	1944	3	facers
fern	7	61	2932	3	__fern
fluter	9	53	1686	3	fluter_
fluters	10	37	1368	3	fluters
fucker	15	34	1442	3	fucker_
fuckers	16	36	1159	3	fuckers
fumer	10	59	1823	3	fumer_
fumers	11	36	1338	3	fumers
glucan	9	3	618	3	gluc_an
gluer	6	51	1677	3	glu_er_
gluers	7	50	1115	3	glu_ers
gluier	7	3	1026	3	gluier_
gluten	7	42	1075	3	glute_n
glycerin	14	4	435	3	glycerin
govern	10	3	682	3	govern
hern	7	61	3489	3	__hern
huger	9	49	1487	3	huger_
humeri	11	3	852	3	humeri
intern	6	40	1654	3	intern
juicer	15	3	628	3	juicer_
juicers	16	3	615	3	juicers
kern	8	53	2621	3	__kern
klavern	14	3	300	3	klavern
kuchen	15	3	665	3	kuchen
lace	6	68	4847	3	lace__
laced	8	71	3264	3	lace_d
laces	7	61	4176	3	lace_s
lacey	10	58	2091	3	lace_y
lacier	8	40	2009	3	lacier_
lacker	12	53	2562	3	lacker_
lackers	13	41	2054	3	lackers
lactean	9	5	647	3	lactean
laden	6	50	2219	3	lade_n
lader	6	56	3372	3	lader_
laders	7	49	2776	3	laders
lager	6	51	3286	3	lager_
lagers	7	48	2614	3	lagers
laker	9	54	3287	3	laker_
lakers	10	52	2515	3	lakers
lamer	7	52	3370	3	lamer_
lancer	8	43	1997	3	lancer_
lancers	9	36	1664	3	lancers
lantern	7	3	1001	3	lantern
laser	5	46	3332	3	laser_
lasers	6	49	2570	3	lasers
lateen	6	40	1486	3	lateen
laten	5	43	2834	3	late_n
later	5	48	4392	3	later_
lauder	7	38	1501	3	lauder_
lauders	8	40	1289	3	lauders
laver	8	50	3179	3	laver_
lavers	9	45	2636	3	lavers
laxer	12	54	2033	3	laxer_
layer	8	46	2647	3	layer_
layers	9	39	2118	3	layers
lean	4	63	4524	3	l__ean
learn	5	53	2266	3	l_earn
leben	7	3	1485	3	lebe_n
lecher	11	34	1585	3	lecher_
lechers	12	33	1396	3	lechers
lechery	15	25	764	3	lechery
lecterns	10	3	594	3	lecterns
lectin	8	25	1501	3	lectin
leer	4	62	3935	3	l_eer_
leers	5	48	2898	3	l_eers
leery	8	59	1913	3	l_eery
leger	6	57	2151	3	leger_
legers	7	45	1831	3	legers
leper	7	48	2074	3	leper_
lepers	8	48	1732	3	lepers
leucin	8	3	911	3	leuc_in
lever	8	51	2516	3	lever_
levers	9	46	2132	3	levers
liber	7	47	2362	3	liber_
libers	8	47	2144	3	libers
lice	6	60	4506	3	lice__
lichen	11	40	1274	3	lichen
licker	12	52	2204	3	licker_
lickers	13	41	1825	3	lickers
lien	4	53	3980	3	l_ie_n
lier	4	59	4246	3	l_ier_
lierne	6	3	802	3	l_ierne
liers	5	51	3040	3	l_iers
lifer	8	58	2215	3	lifer_
lifers	9	56	1784	3	lifers
liger	6	50	2447	3	liger_
ligers	7	50	2204	3	ligers
liken	9	118	1884	3	like_n
liker	9	56	2706	3	liker_
likers	10	46	2091	3	likers
limen	7	54	2603	3	lime_n
linen	5	57	2872	3	line_n
liner	5	59	3892	3	liner_
liners	6	54	2885	3	liners
liter	5	47	3634	3	liter_
liters	6	54	2988	3	liters
liven	8	50	2173	3	live_n
liver	8	51	3296	3	liver_
livers	9	49	2782	3	livers
livery	12	49	1090	3	livery
lochan	11	3	909	3	lochan
locker	12	40	1942	3	locker_
lockers	13	35	1692	3	lockers
loden	6	66	2114	3	lode_n
lomein	8	4	1020	3	lomein
loner	5	54	3104	3	loner_
loners	6	42	2581	3	loners
loper	7	51	2923	3	loper_
lopers	8	44	2414	3	lopers
lorn	4	64	3525	3	l__orn
loser	5	47	2867	3	loser_
losers	6	51	2358	3	losers
louden	7	37	1179	3	loude_n
louder	7	44	1460	3	louder_
loupen	8	45	1029	3	loupe_n
louver	9	41	1039	3	louver_
louvers	10	35	910	3	louvers
lover	8	55	2645	3	lover_
lovers	9	42	2343	3	lovers
lower	8	58	3041	3	lower_
lowers	9	46	2492	3	lowers
lowery	12	41	1271	3	lowery
lubber	10	42	1462	3	lubber_
lubbers	11	39	1372	3	lubbers
lube	6	47	3156	3	lube__
lubed	8	53	1989	3	lube_d
lubes	7	47	2799	3	lube_s
lucarnes	10	4	509	3	lucarnes
lucence	11	14	800	3	lucence
lucency	14	10	490	3	lucency
lucid	8	43	1457	3	luc_id
lucifer	12	3	460	3	lucifer_
luciferin	14	15	246	3	luciferin
lucifers	13	3	416	3	lucifers
lucite	8	3	1334	3	lucite
luck	10	53	2982	3	luc__k
lucked	13	51	1802	3	lucked
luckie	12	36	1141	3	luckie
luckier	13	38	1153	3	luckier_
lucking	14	36	1583	3	lucking
lucks	11	57	2356	3	luc_ks
lucky	14	55	1501	3	luc_ky
lude	5	53	3164	3	lude__
ludes	6	57	2885	3	lude_s
lues	4	59	4355	3	lu_e_s
luge	5	55	3164	3	luge__
luged	7	40	1909	3	luge_d
lugeing	9	35	911	3	lugeing
luges	6	59	2875	3	luge_s
lugger	8	39	1655	3	lugger_
luggers	9	37	1348	3	luggers
luller	6	34	1548	3	luller_
lullers	7	32	1335	3	lullers
lumber	10	38	1777	3	lumber_
lumbers	11	38	1591	3	lumbers
lumens	8	50	1397	3	lumens
lumpen	10	40	1066	3	lumpen
lumper	10	38	1665	3	lumper_
lumpers	11	35	1448	3	lumpers
lunar	5	70	1731	3	lunar_
lunars	6	50	1281	3	lunars
luncheon	13	4	401	3	luncheon
luncher	12	31	1141	3	luncher_
lunchers	13	34	956	3	lunchers
lune	4	71	4049	3	lune__
lunes	5	53	3777	3	lune_s
lunet	5	68	3542	3	lune_t
lunets	6	69	1476	3	lunets
lungan	7	47	1021	3	lungan
lunger	7	57	2042	3	lunger_
lungers	8	38	1709	3	lungers
lunier	6	46	1760	3	lunier_
lunker	10	47	1834	3	lunker_
lunkers	11	34	1460	3	lunkers
lupin	7	52	1584	3	lu_pin
lurcher	12	33	813	3	lurcher_
lurchers	13	30	715	3	lurchers
lurdan	7	3	836	3	lurdan
lure	4	51	4246	3	lu__re
lured	6	54	2749	3	lure_d
lures	5	61	3853	3	lure_s
lurex	12	48	1673	3	lure_x
lurk	8	66	2416	3	lu__rk
lurker	10	36	1329	3	lurker_
lurkers	11	39	1008	3	lurkers
lusher	9	38	1876	3	lusher_
luster	6	40	2367	3	luster_
lusters	7	39	2144	3	lusters
lustra	6	35	889	3	lustra
lustre	6	40	1168	3	lustre
lute	4	63	4101	3	lute__
lutea	5	48	1907	3	lute_a
luteal	6	44	1148	3	luteal
luted	6	48	2614	3	lute_d
luteins	7	3	1010	3	luteins
lutes	5	58	3666	3	lute_s
luteum	8	3	778	3	luteum
lutherns	11	3	629	3	lutherns
luxe	11	52	2269	3	luxe__
luxes	12	49	2150	3	luxe_s
luxury	16	4	254	3	luxury
lycea	10	41	894	3	lyce_a
lycee	10	47	1674	3	lyce_e
lycees	11	42	886	3	lycees
lyceum	13	4	395	3	lyceum
lycra	10	31	797	3	lyc_ra
lyncean	12	9	292	3	lyncean
macer	9	121	2694	3	macer_
macers	10	53	2127	3	macers
modern	9	3	952	3	modern
mucin	9	31	1682	3	muc_in
mucker	14	38	1639	3	mucker_
muckers	15	36	1280	3	muckers
mucor	9	40	1194	3	mucor_
mucors	10	44	1085	3	mucors
mucro	9	45	1372	3	muc_ro
murein	8	3	1176	3	murein
muser	7	60	2412	3	muser_
musers	8	47	1910	3	musers
muter	7	45	2554	3	muter_
nicer	7	46	1829	3	nicer_
nuclein	9	6	612	3	nuclein
nucleon	9	4	555	3	nucleon
nuder	6	64	1683	3	nuder_
numen	7	42	1679	3	nume_n
ocean	7	12	1296	3	_ocean
orcein	8	3	818	3	orcein
outearn	7	3	1068	3	outearn
outer	5	56	3330	3	outer_
outers	6	42	3017	3	outers
pacer	9	61	3161	3	pacer_
pacers	10	51	2454	3	pacers
placer	10	51	1774	3	placer_
placers	11	45	1526	3	placers
plucker	15	36	824	3	plucker_
pluckers	16	31	655	3	pluckers
puce	8	51	2788	3	puce__
puces	9	49	2463	3	puce_s
pucker	14	38	1763	3	pucker_
puckers	15	35	1467	3	puckers
puckery	18	30	626	3	puckery
puler	7	48	2662	3	puler_
pulers	8	38	2028	3	pulers
purer	7	51	2790	3	purer_
quaere	15	41	1067	3	quaere
quean	14	36	1284	3	qu_ean
queen	14	43	1206	3	qu_een
queer	14	37	1281	3	queer_
queers	15	35	1077	3	queers
querns	15	30	794	3	qu_erns
query	17	42	1208	3	qu_ery
racer	7	52	3302	3	racer_
racers	8	47	2543	3	racers
ricer	7	47	2661	3	ricer_
ricers	8	41	2099	3	ricers
ruder	6	53	2054	3	ruder_
rudery	10	41	903	3	rudery
ruer	4	61	2756	3	ru_er_
ruers	5	150	1941	3	ru_ers
ruler	5	49	2334	3	ruler_
rulers	6	43	1709	3	rulers
rumen	7	44	1950	3	rume_n
saucer	8	43	1410	3	saucer_
saucers	9	37	1213	3	saucers
scorn	7	58	1745	3	_scorn
secerns	9	8	773	3	secerns
slicer	8	41	1760	3	slicer_
slicers	9	41	1492	3	slicers
stern	5	53	1912	3	_stern
suber	7	49	2450	3	suber_
suberin	9	3	1456	3	suberin
subers	8	57	2264	3	subers
suborn	8	3	1001	3	suborn
sucker	12	41	2066	3	sucker_
suckers	13	37	1762	3	suckers
sucre	7	50	1910	3	suc_re
sucres	8	42	1889	3	sucres
suer	4	53	3403	3	su_er_
suers	5	51	2848	3	su_ers
super	7	49	2448	3	super_
superb	10	44	1099	3	superb
supers	8	46	2240	3	supers
surer	5	48	3310	3	surer_
tavern	9	42	893	3	tavern
tern	4	61	3480	3	__tern
tuber	7	54	2068	3	tuber_
tubers	8	50	1703	3	tubers
tuchun	11	4	544	3	tuchun
tucker	12	43	1695	3	tucker_
tuckers	13	40	1435	3	tuckers
tuner	5	60	2268	3	tuner_
tuners	6	44	1734	3	tuners
tureen	6	33	1272	3	tureen
turn	4	63	3039	3	tu__rn
tuyer	8	54	1429	3	tuyer_
tuyere	9	40	861	3	tuyere
tuyers	9	46	1256	3	tuyers
ulcered	10	3	797	3	ulcered
ulcering	11	3	933	3	ulcering
urn	3	57	3147	3	_u__rn
user	4	50	2300	3	_user_
users	5	58	1757	3	_users
uteri	5	10	1298	3	_uteri
wivern	12	40	928	3	wivern
wyvern	15	36	392	3	wyvern

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.376	475242.0
2	DLD Change Limit	112716	380	5.170	21801.9
3	Display Results	380	380	0.126	3015.9
	(SQL Overall)	178691	380	5.672	31504.1