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

Here are the results of your fuzzy-string dictionary search for “lien” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

291 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
lien	4	53	3980	(None)
alien	5	64	2558	1	alien
gien	5	63	3002	1	gien
lie	3	82	6452	1	lie_
lied	5	58	3809	1	lied
lief	7	60	3699	1	lief
liens	5	65	2550	1	liens
lier	4	59	4246	1	lier
lies	4	64	5419	1	lies
lieu	4	65	3436	1	lieu
liken	9	118	1884	1	liken
limen	7	54	2603	1	limen
limn	6	65	2769	1	limn
lin	3	79	6737	1	li_n
line	4	69	6557	1	line
linen	5	57	2872	1	linen
linn	4	60	3459	1	linn
lion	4	63	3444	1	lion
liven	8	50	2173	1	liven
mien	6	50	2836	1	mien
ain	3	75	7909	2	ai_n
airn	4	64	3383	2	airn
aliens	6	56	1921	2	aliens
align	6	50	1650	2	align
aline	5	72	4315	2	aline
amen	6	67	3315	2	amen
been	6	53	3578	2	been
ben	5	65	5492	2	_ben
bier	6	55	3183	2	bier
bin	5	66	5864	2	bi_n
bine	6	66	5086	2	bine
blin	6	72	2817	2	bli_n
bren	6	56	2956	2	bren
cine	6	62	4294	2	cine
cion	6	133	3091	2	cion
client	8	3	1634	2	client
cline	7	64	2853	2	cline
den	4	75	5434	2	_den
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
diene	6	57	2013	2	diene
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
din	4	64	5946	2	di_n
dine	5	55	5533	2	dine
dizen	15	52	1493	2	dizen
en	2	80	5239	2	__en
even	7	52	2227	2	even
eyen	7	62	2366	2	eyen
fen	6	68	5135	2	_fen
fie	6	71	5244	2	fie_
fief	10	73	3136	2	fief
fiend	9	53	1298	2	fiend
fin	6	64	5803	2	fi_n
fine	7	51	4795	2	fine
firn	7	69	2750	2	firn
flied	9	65	1943	2	flied
flier	8	60	2340	2	flier
flies	8	56	3071	2	flies
gaen	5	73	2960	2	gaen
gen	4	59	5051	2	_gen
gie	4	71	4954	2	gie_
gied	6	46	3198	2	gied
gies	5	56	4142	2	gies
gin	4	60	5575	2	gi_n
girn	5	60	2686	2	girn
given	9	59	1528	2	given
glen	5	60	2720	2	glen
haen	7	62	2945	2	haen
hen	6	75	5527	2	_hen
hie	6	76	5270	2	hie_
hied	8	54	3404	2	hied
hies	7	48	4283	2	hies
hin	6	75	5956	2	hi_n
hisn	7	96	2093	2	hisn
ilea	4	59	3146	2	ilea
ilex	11	58	2203	2	ilex
in	2	81	5086	2	_i_n
inn	3	67	2743	2	_inn
ion	3	60	5102	2	_ion
jin	10	64	4393	2	ji_n
jinn	11	54	2024	2	jinn
keen	8	48	3040	2	keen
ken	7	63	4398	2	_ken
kief	11	71	2840	2	kief
kier	8	65	2680	2	kier
kiln	8	56	2097	2	kiln
kin	7	63	5396	2	ki_n
kine	8	56	4342	2	kine
kirn	8	71	2343	2	kirn
laden	6	50	2219	2	laden
lain	4	61	4628	2	lain
lane	4	51	5333	2	lane
laten	5	43	2834	2	laten
lawn	7	59	2563	2	lawn
lea	3	76	6018	2	l_ea
lean	4	63	4524	2	lean
leben	7	3	1485	2	leben
led	4	62	5455	2	l_ed
lee	3	60	6814	2	l_ee
leek	8	53	3173	2	leek
leer	4	62	3935	2	leer
lees	4	54	5588	2	lees
leet	4	59	5790	2	leet
leg	4	64	4611	2	l_eg
lei	3	68	4638	2	l_ei
leis	4	57	3960	2	leis
lek	7	56	4030	2	l_ek
lend	5	62	3367	2	l_end
leno	4	73	3139	2	l_eno
lens	4	61	4649	2	l_ens
lent	4	63	6053	2	l_ent
les	3	56	6307	2	l_es
let	3	64	8147	2	l_et
leu	3	60	4740	2	l_eu
lev	6	61	3942	2	l_ev
lex	10	79	4382	2	l_ex
ley	6	62	4681	2	l_ey
lez	12	55	4131	2	l_ez
li	2	99	4875	2	li__
liana	5	39	1589	2	liana
liane	5	47	2066	2	liane
liang	6	49	1441	2	liang
liar	4	72	2968	2	liar
lib	5	77	5027	2	li_b
libel	7	41	1610	2	libel
liber	7	47	2362	2	liber
libs	6	67	3276	2	libs
lice	6	60	4506	2	lice
lich	9	62	3084	2	lich
lichen	11	40	1274	2	lichen
lick	10	69	3507	2	lick
lid	4	74	5351	2	li_d
lido	5	60	2815	2	lido
lids	5	63	3645	2	lids
liege	6	53	1443	2	liege
lienal	6	39	1278	2	lienal
lierne	6	3	802	2	lierne
liers	5	51	3040	2	liers
lieus	5	62	1848	2	lieus
lieve	8	63	1547	2	lieve
life	7	54	3373	2	life
lifer	8	58	2215	2	lifer
lift	7	69	4272	2	lift
ligan	6	79	2028	2	ligan
liger	6	50	2447	2	liger
like	8	60	4084	2	like
liked	10	45	2381	2	liked
likens	10	56	1370	2	likens
liker	9	56	2706	2	liker
likes	9	62	3190	2	likes
lilo	4	67	3156	2	lilo
lilt	4	63	4994	2	lilt
lily	7	67	3018	2	lily
lima	6	57	3413	2	lima
liman	7	59	2160	2	liman
limb	8	54	2938	2	limb
lime	6	62	4493	2	lime
limed	8	54	2680	2	limed
limens	8	46	1803	2	limens
limes	7	56	3650	2	limes
limey	10	47	2104	2	limey
limns	7	57	1839	2	limns
limo	6	55	2973	2	limo
limp	8	84	3249	2	limp
limy	9	57	2771	2	limy
linden	7	4	1145	2	linden
lined	6	49	3464	2	lined
linens	6	48	1839	2	linens
lineny	9	40	1144	2	lineny
liner	5	59	3892	2	liner
lines	5	70	5457	2	lines
liney	8	70	2963	2	liney
ling	5	74	4796	2	ling
linin	5	80	2552	2	linin
link	8	69	4344	2	link
linns	5	61	2333	2	linns
lino	4	63	4337	2	lino
lins	4	70	5905	2	lins
lint	4	162	6623	2	lint
liny	7	81	4132	2	liny
lions	5	59	2321	2	lions
lip	5	147	5580	2	li_p
lipa	6	84	2592	2	lipa
lipe	6	68	3973	2	lipe
lipin	7	55	1889	2	lipin
lippen	10	39	1140	2	lippen
lips	6	71	4144	2	lips
lira	4	69	2868	2	lira
lire	4	78	4529	2	lire
liri	4	51	2825	2	liri
lis	3	71	6227	2	li_s
lisp	6	89	2688	2	lisp
list	4	70	5534	2	list
listen	6	48	1681	2	listen
lit	3	93	7731	2	li_t
lite	4	70	5454	2	lite
liter	5	47	3634	2	liter
lits	4	62	5249	2	lits
litten	6	40	1487	2	litten
litu	4	76	3156	2	litu
live	7	65	4099	2	live
lived	9	55	2372	2	lived
livens	9	43	1489	2	livens
liver	8	51	3296	2	liver
lives	8	61	3319	2	lives
loan	4	74	3645	2	loan
loden	6	66	2114	2	loden
loin	4	68	3872	2	loin
lone	4	58	4913	2	lone
loon	4	73	4479	2	loon
lorn	4	64	3525	2	lorn
lown	7	69	2929	2	lown
lues	4	59	4355	2	lues
lumen	7	52	2090	2	lumen
lune	4	71	4049	2	lune
lwei	7	53	1264	2	lwei
lye	6	65	3341	2	lye_
lyes	7	55	3083	2	lyes
men	5	92	5285	2	_men
miens	7	61	1830	2	miens
mine	6	72	5617	2	mine
mizen	16	48	1527	2	mizen
nine	4	58	4217	2	nine
olden	6	51	1485	2	olden
olein	5	3	1600	2	olein
omen	6	68	2818	2	omen
open	6	64	2700	2	open
oven	7	66	2414	2	oven
oxen	11	62	1859	2	oxen
peen	6	59	3808	2	peen
pein	6	58	3494	2	pein
pen	5	65	5884	2	_pen
pian	6	61	3609	2	pian
pie	5	54	5740	2	pie_
pied	7	50	3536	2	pied
pier	6	60	3529	2	pier
pies	6	69	4960	2	pies
pin	5	70	6672	2	pi_n
pine	6	77	5571	2	pine
pion	6	72	3529	2	pion
pirn	6	71	2837	2	pirn
plie	6	51	2739	2	plie_
plied	8	51	1859	2	plied
plier	7	52	2128	2	plier
plies	7	45	2651	2	plies
rein	4	60	4089	2	rein
riel	4	64	3238	2	riel
rin	3	66	6318	2	ri_n
ripen	7	56	1926	2	ripen
risen	5	46	2188	2	risen
riven	8	51	2162	2	riven
seen	4	69	4312	2	seen
sen	3	60	5852	2	_sen
sign	5	55	2305	2	sign
sin	3	62	6589	2	si_n
sine	4	65	6062	2	sine
siren	5	45	2582	2	siren
slier	5	48	2724	2	slier
teen	4	59	3820	2	teen
ten	3	58	5611	2	_ten
then	7	84	2969	2	then
tie	3	65	5753	2	tie_
tied	5	55	3521	2	tied
tier	4	49	3614	2	tier
ties	4	52	4831	2	ties
tin	3	63	6217	2	ti_n
tine	4	58	5513	2	tine
vein	7	56	2575	2	vein
vie	6	54	4763	2	vie_
vied	8	63	2863	2	vied
vier	7	54	2815	2	vier
vies	7	52	3862	2	vies
view	10	59	1767	2	view
vimen	10	41	1475	2	vimen
vine	7	56	4368	2	vine
vixen	15	30	1002	2	vixen
ween	7	58	3546	2	ween
wen	6	62	4960	2	_wen
when	10	57	2304	2	when
widen	9	47	1797	2	widen
win	6	64	5629	2	wi_n
wine	7	49	5342	2	wine
wizen	17	58	1386	2	wizen
wren	7	82	2168	2	wren
yen	6	68	4738	2	_yen
yin	6	76	4873	2	yi_n
zein	13	56	2060	2	zein
zin	12	56	4377	2	zi_n
zine	13	70	3615	2	zine

Search took 3 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	29872	0.076	2351197.4
2	DLD Change Limit	29872	291	2.266	13182.7
3	Display Results	291	291	0.140	2078.6
	(SQL Overall)	178691	291	2.482	71994.8