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

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

510 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
learnt	6	40	1925	(None)
leant	5	67	3778	1	lea_nt
learn	5	53	2266	1	learn_
learns	6	55	1374	1	learns
earn	4	67	3755	2	_earn_
earns	5	59	2756	2	_earns
heart	8	54	4074	2	hear_t
lean	4	63	4524	2	lea_n_
leans	5	55	3625	2	lea_ns
leapt	7	50	2747	2	lea_pt
lear	4	70	4595	2	lear__
learned	8	32	930	2	learned
learner	7	31	938	2	learner
lears	5	59	3873	2	lear_s
leary	8	59	2738	2	lear_y
least	5	61	3488	2	lea_st
lent	4	63	6053	2	le__nt
levant	9	3	1449	2	levant
lyart	8	51	2188	2	lyar_t
meant	7	65	3721	2	mea_nt
peart	7	64	4075	2	pear_t
relearnt	8	4	921	2	relearnt
unlearnt	8	4	640	2	unlearnt
yearn	8	63	1643	2	yearn_
yearns	9	50	954	2	yearns
alant	5	57	4229	3	ala_nt
alert	5	47	4065	3	ale_r_t
alterant	8	6	1496	3	alterant
amarna	8	3	979	3	amarna
ant	3	72	7079	3	__a_nt
apart	7	43	3067	3	apar_t
arrant	6	6	2325	3	arrant
art	3	86	7914	3	__ar_t
aunt	4	65	5365	3	__aunt
avant	8	62	2466	3	ava_nt
avaunt	9	5	960	3	avaunt
barn	6	64	4464	3	_barn_
barns	7	63	3514	3	_barns
barny	10	58	2173	3	_barny
bean	6	64	4386	3	bea_n_
beano	7	54	2155	3	bea_no
beans	7	57	3469	3	bea_ns
bear	6	68	4464	3	bear__
bearcat	11	6	1191	3	bearcat
beard	8	60	2496	3	bear_d
beards	9	41	1667	3	beards
bearer	8	53	2391	3	bearer
bearing	10	36	2477	3	bearing
bears	7	57	3904	3	bear_s
beast	7	63	3864	3	bea_st
beat	6	61	6830	3	bea__t
beaut	7	51	3521	3	bea_ut
befret	11	3	1596	3	befret
bent	6	77	5991	3	be__nt
bepaint	11	3	1218	3	bepaint
beret	7	49	4636	3	be_ret
bezant	17	8	1454	3	bezant
blear	7	59	1868	3	blear__
bleared	10	42	1125	3	bleared
blearing	11	31	1194	3	blearing
blears	8	51	1645	3	blear_s
bleary	11	51	1255	3	blear_y
bleat	7	57	3700	3	blea__t
blent	7	62	3095	3	ble__nt
boart	7	88	3593	3	boar_t
brant	7	47	4217	3	bra_nt
burnt	7	52	3032	3	_burnt
cant	6	63	6203	3	_ca_nt
carat	7	50	4879	3	_carat
caret	7	53	6056	3	_caret
carn	6	62	4543	3	_carn_
carnet	8	47	3287	3	_carnet
carns	7	59	3756	3	_carns
carny	10	58	2292	3	_carny
cart	6	65	7034	3	_car_t
cedarn	9	40	844	3	cedarn_
cement	10	33	2166	3	cement
cent	6	74	5101	3	ce__nt
chant	10	59	3269	3	cha_nt
chart	10	50	3828	3	char_t
chaunt	11	6	1349	3	chaunt
claret	8	40	2657	3	claret
clean	7	54	2041	3	clea_n_
cleans	8	58	1705	3	clea_ns
clear	7	62	1905	3	clear__
clearcut	12	4	422	3	clearcut
cleared	10	36	1246	3	cleared
clearer	9	37	1082	3	clearer
clearest	10	3	865	3	clearest
clearing	11	30	1488	3	clearing
clearly	12	3	666	3	clearly
clears	8	41	1656	3	clear_s
cleat	7	63	3506	3	clea__t
clement	11	3	1377	3	clement
darn	5	64	3462	3	_darn_
darns	6	69	2789	3	_darns
dart	5	58	5787	3	_dar_t
daunt	6	59	2908	3	_daunt
dealt	6	52	3428	3	dea_lt
dean	5	60	3948	3	dea_n_
deans	6	61	3139	3	dea_ns
dear	5	53	4360	3	dear__
dearer	7	48	2280	3	dearer
dearest	8	36	1867	3	dearest
dearie	7	33	1981	3	dearie
dearly	10	46	1532	3	dearly
dears	6	57	3688	3	dear_s
dearth	10	42	1251	3	dearth
deary	9	58	2684	3	dear_y
decant	9	35	2422	3	decant
decent	9	40	2370	3	decent
dement	9	38	2514	3	dement
dent	5	71	5841	3	de__nt
depaint	10	3	1459	3	depaint
depart	9	47	2056	3	depar_t
derat	6	50	4408	3	de_rat
detent	7	36	2448	3	detent
dharna	10	5	526	3	dharna
ear	3	68	6788	3	_ear__
eared	6	51	3950	3	_eared
earing	7	52	3548	3	_earing
earl	4	58	3814	3	_ear_l
earls	5	61	2751	3	_earls
early	8	53	2412	3	_early
earned	7	48	1833	3	_earned
earner	6	36	1722	3	_earner
earnest	7	3	1873	3	_earnest
ears	4	63	5659	3	_ear_s
earth	8	50	2305	3	_earth
east	4	66	5910	3	_ea_st
eat	3	69	8905	3	_ea__t
egret	6	33	2731	3	_egret
elain	5	53	2470	3	elain_
elains	6	49	1985	3	elains
elan	4	67	3424	3	ela_n_
eland	6	58	2039	3	ela_nd
elans	5	55	2775	3	ela_ns
elegant	8	3	1150	3	elegant
element	9	3	1780	3	element
elint	5	54	3647	3	_elint
eluant	6	3	1509	3	eluant
eluent	6	3	1548	3	eluent
ern	3	57	3835	3	_e_rn_
erne	4	67	2742	3	_e_rne
erns	4	54	2822	3	_e_rns
errant	6	6	1873	3	_errant
erst	4	74	3643	3	_e_rst
event	8	59	2444	3	_event
faint	8	58	3706	3	_faint
fart	7	68	6056	3	_far_t
fear	7	53	3779	3	fear__
feared	10	63	2043	3	feared
fearer	9	48	2018	3	fearer
fearing	11	35	2003	3	fearing
fears	8	48	2939	3	fear_s
feast	8	59	3272	3	fea_st
feat	7	64	5822	3	fea__t
feint	8	47	3225	3	fe_int
fern	7	61	2932	3	fe_rn_
ferns	8	52	2008	3	fe_rns
ferny	11	58	1618	3	fe_rny
ferret	9	30	2117	3	ferret
flaunt	9	7	1291	3	flaunt
fleapit	12	5	599	3	fleapit
garnet	7	39	2841	3	_garnet
garni	6	3	1570	3	_garni
gaunt	6	54	3040	3	_gaunt
gear	5	59	3497	3	gear__
geared	8	53	1774	3	geared
gearing	9	28	1884	3	gearing
gears	6	46	2869	3	gear_s
gelant	7	28	2167	3	gelant
gent	5	69	5439	3	ge__nt
gerent	7	32	2309	3	gerent
giant	6	54	3059	3	gia_nt
glean	6	58	1820	3	glea_n_
gleans	7	50	1474	3	glea_ns
grant	6	48	4002	3	gra_nt
haint	8	54	3632	3	_haint
hant	7	54	6159	3	_ha_nt
hart	7	68	6577	3	_har_t
haunt	8	52	2913	3	_haunt
hear	7	61	4388	3	hear__
heard	9	52	2275	3	hear_d
hearer	9	43	2364	3	hearer
hearing	11	33	2416	3	hearing
hears	8	67	3737	3	hear_s
hearse	9	41	1427	3	hearse
hearth	12	53	1521	3	hearth
hearts	9	62	1894	3	hearts
hearty	12	63	1363	3	hearty
heat	7	70	6142	3	hea__t
hent	7	66	5638	3	he__nt
hern	7	61	3489	3	he_rn_
herns	8	48	2558	3	he_rns
imaret	8	11	2123	3	imaret
iterant	7	3	1778	3	iterant
jaunt	12	50	2527	3	_jaunt
jean	11	66	2928	3	jea_n_
jeans	12	60	2211	3	jea_ns
jurant	13	42	1655	3	jurant
karat	9	68	3759	3	_karat
karn	8	61	2941	3	_karn_
karns	9	66	2414	3	_karns
karst	9	72	2899	3	_karst
kart	8	67	5080	3	_kar_t
kent	8	68	4696	3	ke__nt
kern	8	53	2621	3	ke_rn_
kerne	9	47	1822	3	ke_rne
kerns	9	47	1956	3	ke_rns
laari	5	44	1571	3	laar_i
labret	8	3	2022	3	labret
lain	4	61	4628	3	l_ain_
lament	8	50	2494	3	lament
land	5	63	3731	3	l_a_nd
lane	4	51	5333	3	l_a_ne
lang	5	66	3738	3	l_a_ng
lank	8	47	3445	3	l_a_nk
lar	3	79	6753	3	l_ar__
larch	10	59	1979	3	l_arch
lard	5	67	4200	3	l_ar_d
lards	6	53	3186	3	l_ards
lardy	9	61	1927	3	l_ardy
laree	5	60	3629	3	l_aree
lares	5	48	5263	3	l_ares
large	6	53	2546	3	l_arge
largo	6	53	1978	3	l_argo
lari	4	58	3915	3	l_ar_i
lariat	6	6	2904	3	l_ariat
larine	6	39	2704	3	l_arine
laris	5	47	3746	3	l_aris
lark	8	57	3386	3	l_ar_k
larks	9	52	2781	3	l_arks
larky	12	52	1887	3	l_arky
lars	4	69	5657	3	l_ar_s
larum	7	43	1797	3	l_arum
larva	8	3	1248	3	l_arva
larynx	16	3	285	3	l_arynx
last	4	62	6032	3	l_a_st
lat	3	75	9340	3	l_a__t
latent	6	41	2430	3	latent
lawn	7	59	2563	3	l_awn_
lawns	8	52	1542	3	l_awns
lawny	11	59	1201	3	l_awny
lazaret	16	4	1178	3	lazaret
lea	3	76	6018	3	lea___
leach	10	54	2252	3	lea_ch
leachy	14	41	973	3	leachy
lead	5	60	3885	3	lea__d
leaded	8	42	2154	3	leaded
leaden	7	45	1522	3	leaden
leadens	8	36	1098	3	leadens
leader	7	48	2465	3	leader
leading	9	34	1955	3	leading
leads	6	60	2849	3	lea_ds
leady	9	56	1860	3	lea_dy
leaf	7	64	4103	3	lea__f
leafed	10	57	1387	3	leafed
leafing	11	33	1358	3	leafing
leaflet	10	19	974	3	leaflet
leafs	8	57	2118	3	lea_fs
leafy	11	63	1621	3	lea_fy
league	7	5	874	3	league
leak	8	62	3371	3	lea__k
leaked	11	42	1770	3	leaked
leaker	10	46	2007	3	leaker
leaking	12	36	1697	3	leaking
leaks	9	59	2391	3	lea_ks
leaky	12	52	1772	3	lea_ky
leal	4	60	4327	3	lea__l
leally	9	40	1261	3	leally
lealty	9	29	1060	3	lealty
leaned	7	34	2254	3	leaned
leaner	6	40	2219	3	leaner
leanest	7	4	1586	3	leanest
leaning	8	37	2120	3	leaning
leanly	9	38	1150	3	leanly
leap	6	60	3268	3	lea__p
leaped	9	43	1777	3	leaped
leaper	8	81	1894	3	leaper
leaping	10	32	1599	3	leaping
leaps	7	55	2293	3	lea_ps
learier	7	34	1566	3	learier
leariest	8	31	1784	3	leariest
learners	8	39	815	3	learners
learning	9	7	855	3	learning
leas	4	59	5418	3	lea__s
lease	5	52	3026	3	lea_se
leased	7	47	2288	3	leased
leaser	6	53	2267	3	leaser
leases	6	54	2811	3	leases
leash	8	55	1921	3	lea_sh
leasing	8	39	2016	3	leasing
leasts	6	46	1641	3	leasts
leave	8	47	2372	3	lea_ve
leaved	10	57	1902	3	leaved
leaven	9	50	1307	3	leaven
leavens	10	40	930	3	leavens
leaver	9	43	2151	3	leaver
leaves	9	42	2238	3	leaves
leaving	11	42	1685	3	leaving
leavy	11	57	1577	3	lea_vy
leben	7	3	1485	3	leben_
lebens	8	3	1009	3	lebens
leer	4	62	3935	3	leer__
leered	7	38	1622	3	leered
leering	8	34	1764	3	leering
leers	5	48	2898	3	leer_s
leery	8	59	1913	3	leer_y
leet	4	59	5790	3	le__et
left	7	63	4048	3	le__ft
legend	8	3	769	3	legend
legist	7	13	1525	3	legist
legit	6	13	2350	3	le_git
legong	8	3	696	3	legong
lehr	7	55	1494	3	lehr__
lehrs	8	61	1113	3	lehr_s
leman	7	56	2260	3	leman_
lemans	8	53	1639	3	lemans
lemon	7	56	1818	3	lemon_
lemons	8	44	1505	3	lemons
lemony	11	41	955	3	lemony
lend	5	62	3367	3	le__nd
lenient	7	3	1384	3	lenient
leno	4	73	3139	3	le__no
lens	4	61	4649	3	le__ns
lento	5	72	2339	3	le__nto
leone	5	50	1882	3	le_one
lept	6	64	4088	3	le__pt
lest	4	69	5632	3	le__st
let	3	64	8147	3	le___t
levants	10	3	772	3	levants
leveret	10	30	1400	3	leveret
levin	8	48	1641	3	levin_
levins	9	45	1465	3	levins
liana	5	39	1589	3	lia_na
liane	5	47	2066	3	lia_ne
liang	6	49	1441	3	lia_ng
liar	4	72	2968	3	liar__
liard	6	54	1859	3	liar_d
liards	7	52	1261	3	liards
liars	5	47	2316	3	liar_s
lierne	6	3	802	3	lierne
lint	4	162	6623	3	l__int
lirot	5	4	3003	3	l_irot
llano	5	9	1060	3	lla_no
loan	4	74	3645	3	loa_n_
loans	5	60	2646	3	loa_ns
loment	8	40	2147	3	loment
loran	5	59	2509	3	loran_
lorans	6	51	1760	3	lorans
lorn	4	64	3525	3	l_orn_
lucarne	9	4	426	3	lucarne
lucent	8	3	1382	3	lucent
lunt	4	61	4884	3	l__unt
lyard	9	51	1321	3	lyar_d
mart	6	68	6598	3	_mar_t
mean	6	55	3809	3	mea_n_
means	7	58	3123	3	mea_ns
meany	10	46	2048	3	mea_ny
meat	6	63	5960	3	mea__t
merit	7	3	3918	3	me_rit
mislearnt	11	9	555	3	~~mis~~learnt
near	4	52	3650	3	near__
nearby	11	35	605	3	nearby
neared	7	51	1980	3	neared
nearer	6	46	1889	3	nearer
nearest	7	34	1584	3	nearest
nearing	8	30	2033	3	nearing
nearly	9	48	1373	3	nearly
nears	5	55	2942	3	near_s
neat	4	63	5678	3	nea__t
operant	9	3	1722	3	operant
outlearnt	9	4	596	3	~~out~~learnt
paint	7	54	4369	3	_paint
pant	6	60	6126	3	_pa_nt
parent	8	32	3042	3	_parent
part	6	59	6746	3	_par_t
pean	6	61	4717	3	pea_n_
peans	7	54	3764	3	pea_ns
peanut	8	3	1818	3	peanut
pear	6	97	4523	3	pear__
pearl	7	53	2446	3	pear_l
pearls	8	47	1539	3	pearls
pearly	11	64	1484	3	pearly
pears	7	51	3861	3	pear_s
peasant	9	3	1492	3	peasant
peat	6	59	6793	3	pea__t
pedant	9	3	1949	3	pedant
pent	6	65	5907	3	pe__nt
pert	6	67	5932	3	pe_r_t
plaint	8	53	2320	3	plaint
plant	7	54	3711	3	pla_nt
pleasant	10	4	832	3	pleasant
pleat	7	47	3447	3	plea__t
pliant	8	39	1882	3	plia_nt
quaint	15	4	1517	3	quaint
quant	14	36	2481	3	qua_nt
quart	14	40	2785	3	quar_t
rant	4	58	6468	3	_ra_nt
react	7	46	3433	3	rea_ct
reagent	8	7	1660	3	reagent
rear	4	56	4455	3	rear__
reared	7	59	3001	3	reared
rearer	6	49	2891	3	rearer
rearing	8	31	2878	3	rearing
rearm	7	59	2357	3	rear_m
rearms	8	51	1465	3	rearms
rears	5	47	3965	3	rear_s
recant	8	32	2868	3	recant
recent	8	36	3085	3	recent
reearn	6	6	1214	3	reearn_
reearns	7	4	910	3	reearns
refront	10	3	1326	3	refront
regent	7	41	2767	3	regent
regrant	8	3	1732	3	regrant
regret	7	37	2353	3	regret
relearn	7	4	797	3	relearn_
relearns	8	3	630	3	relearns
relent	6	44	3185	3	relent
remint	8	53	2997	3	remint
rent	4	66	6124	3	re__nt
repaint	9	3	1836	3	repaint
repent	8	47	2887	3	repent
reprint	9	3	1898	3	reprint
reran	5	73	2910	3	reran_
rerent	6	38	3245	3	rerent
resent	6	38	3362	3	resent
retint	6	56	3344	3	retint
riant	5	58	3315	3	ria_nt
saint	5	51	4707	3	_saint
scant	7	97	3507	3	sca_nt
scart	7	61	3977	3	scar_t
seafront	11	4	802	3	seafront
sealant	7	31	1830	3	sealant
sear	4	73	5384	3	sear__
search	11	33	1242	3	search
seared	7	52	3284	3	seared
searer	6	54	3202	3	searer
searest	7	33	2202	3	searest
searing	8	33	3092	3	searing
sears	5	47	4491	3	sear_s
seat	4	75	7556	3	sea__t
seawant	10	36	1341	3	seawant
secant	8	40	2329	3	secant
secret	8	3	2506	3	secret
sejant	13	31	1448	3	sejant
sent	4	69	6301	3	se__nt
sharn	8	48	2370	3	sharn_
sharns	9	55	1698	3	sharns
sharny	12	47	1183	3	sharny
slant	5	52	3870	3	sla_nt
smart	7	58	3409	3	smar_t
start	5	56	4231	3	star_t
swart	8	62	3464	3	swar_t
taint	5	55	4228	3	_taint
tarn	4	68	4272	3	_tarn_
tarns	5	64	3395	3	_tarns
tarot	5	59	4393	3	_tarot
tart	4	75	6618	3	_tar_t
taunt	5	55	3228	3	_taunt
teapot	8	4	1676	3	teapot
tear	4	52	4288	3	tear__
teared	7	57	2215	3	teared
tearer	6	48	2290	3	tearer
tearing	8	40	2149	3	tearing
tears	5	54	3646	3	tear_s
teary	8	51	2405	3	tear_y
teat	4	59	6363	3	tea__t
tenant	6	3	2247	3	tenant
tent	4	61	5986	3	te__nt
tern	4	61	3480	3	te_rn_
terne	5	64	2615	3	te_rne
terns	5	52	2687	3	te_rns
terret	6	34	2562	3	terret
territ	6	34	2137	3	territ
tolerant	8	4	1146	3	tolerant
tyrant	9	3	1533	3	tyrant
unlearn	7	3	595	3	unlearn_
unlearns	8	4	445	3	unlearns
varna	8	45	1617	3	_varna
vaunt	8	59	2531	3	_vaunt
vent	7	60	4905	3	ve__nt
verst	8	44	2937	3	ve_rst
vert	7	72	4937	3	ve_r_t
want	7	61	5617	3	_wa_nt
warn	7	52	3932	3	_warn_
warns	8	72	3100	3	_warns
wart	7	78	6608	3	_war_t
wean	7	57	3435	3	wea_n_
weans	8	53	2674	3	wea_ns
wear	7	58	3672	3	wear__
wearer	9	43	1940	3	wearer
wearing	11	33	1886	3	wearing
wears	8	60	3030	3	wear_s
weary	11	56	2061	3	wear_y
went	7	60	5187	3	we__nt
wert	7	97	4982	3	we_r_t
yarn	7	52	3004	3	_yarn_
yarns	8	56	2179	3	_yarns
yean	7	58	3458	3	yea_n_
yeans	8	66	2488	3	yea_ns
year	7	65	3425	3	year__
yearend	11	28	570	3	yearend
yearly	12	52	1027	3	yearly
yearned	11	32	737	3	yearned
yearner	10	33	687	3	yearner
years	8	45	2767	3	year_s
yeast	8	53	2794	3	yea_st
zealot	15	3	1347	3	zealot

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.360	496363.9
2	DLD Change Limit	112716	510	4.936	22835.5
3	Display Results	510	510	0.173	2948.0
	(SQL Overall)	178691	510	5.469	32673.4