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

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

390 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
lier	4	59	4246	(None)
bier	6	55	3183	1	bier
flier	8	60	2340	1	flier
kier	8	65	2680	1	kier
leer	4	62	3935	1	leer
liar	4	72	2968	1	liar
liber	7	47	2362	1	liber
lie	3	82	6452	1	lie_
lied	5	58	3809	1	lied
lief	7	60	3699	1	lief
lien	4	53	3980	1	lien
liers	5	51	3040	1	liers
lies	4	64	5419	1	lies
lieu	4	65	3436	1	lieu
lifer	8	58	2215	1	lifer
liger	6	50	2447	1	liger
liker	9	56	2706	1	liker
liner	5	59	3892	1	liner
lire	4	78	4529	1	lire
liter	5	47	3634	1	liter
liver	8	51	3296	1	liver
pier	6	60	3529	1	pier
plier	7	52	2128	1	plier
slier	5	48	2724	1	slier
tier	4	49	3614	1	tier
vier	7	54	2815	1	vier
ager	5	59	3584	2	ager
aider	6	54	3113	2	aider
aimer	7	59	2682	2	aimer
air	3	80	5839	2	ai_r
airer	5	49	2789	2	airer
aiver	8	57	2516	2	aiver
alder	6	54	2191	2	alder
alien	5	64	2558	2	alien
aliner	6	56	2198	2	aliner
alter	5	48	2850	2	alter
aper	6	63	3623	2	aper
aver	7	59	3188	2	aver
beer	6	56	3599	2	beer
belier	8	44	2356	2	belier
bider	8	57	2837	2	bider
biers	7	62	2522	2	biers
biker	11	60	2256	2	biker
biner	7	59	3069	2	biner
birr	6	60	2236	2	birr
biter	7	50	3003	2	biter
bluer	7	49	1849	2	bluer
brier	7	45	2740	2	brier
cider	8	47	2331	2	cider
cire	6	58	3637	2	cire
citer	7	48	2733	2	citer
crier	7	47	2446	2	crier
deer	5	67	3902	2	deer
dicer	8	54	2642	2	dicer
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
diker	10	55	2455	2	diker
dimer	8	56	2560	2	dimer
diner	6	56	3290	2	diner
dire	5	66	4414	2	dire
direr	6	49	2707	2	direr
diver	9	48	2780	2	diver
doer	5	77	3470	2	doer
drier	6	44	2396	2	drier
dyer	8	55	2211	2	dyer
eelier	6	42	1646	2	eelier
eger	5	59	2356	2	eger
eider	6	46	2474	2	eider
elder	6	40	2002	2	elder
elmier	8	3	981	2	elmier
elver	8	52	1624	2	elver
er	2	83	4514	2	__er
ever	7	70	2769	2	ever
ewer	7	75	2398	2	ewer
eyer	7	61	2728	2	eyer
fer	6	66	4612	2	_fer
fiar	7	64	2733	2	fiar
fiber	10	49	2113	2	fiber
fie	6	71	5244	2	fie_
fief	10	73	3136	2	fief
fiery	11	47	1479	2	fiery
fifer	11	55	1997	2	fifer
filer	8	54	3300	2	filer
finer	8	54	3156	2	finer
fir	6	67	4489	2	fi_r
fire	7	62	4559	2	fire
firer	8	112	2925	2	firer
fiver	11	60	2494	2	fiver
fixer	15	47	1783	2	fixer
fleer	8	60	2077	2	fleer
flied	9	65	1943	2	flied
fliers	9	44	1719	2	fliers
flies	8	56	3071	2	flies
flir	7	64	2220	2	fli_r
flyer	11	49	1625	2	flyer
frier	8	52	2584	2	frier
giber	8	54	1770	2	giber
gie	4	71	4954	2	gie_
gied	6	46	3198	2	gied
gien	5	63	3002	2	gien
gies	5	56	4142	2	gies
giver	9	49	2120	2	giver
glider	8	46	1426	2	glider
gluer	6	51	1677	2	gluer
gluier	7	3	1026	2	gluier
goer	5	68	2710	2	goer
heir	7	75	2380	2	heir
her	6	65	4781	2	_her
hider	9	50	2408	2	hider
hie	6	76	5270	2	hie_
hied	8	54	3404	2	hied
hies	7	48	4283	2	hies
hiker	12	51	1939	2	hiker
hire	7	55	3896	2	hire
hirer	8	54	2312	2	hirer
hoer	7	65	3398	2	hoer
holier	9	49	2162	2	holier
icier	7	43	1375	2	icier
ilea	4	59	3146	2	ilea
ilex	11	58	2203	2	ilex
iller	5	48	2129	2	iller
inlier	6	36	1536	2	inlier
ire	3	69	4317	2	_ire
jeer	11	54	2646	2	jeer
jiber	14	51	1570	2	jiber
jiver	15	51	1905	2	jiver
keir	8	62	1787	2	keir
kief	11	71	2840	2	kief
kiers	9	53	2009	2	kiers
kir	7	65	3567	2	ki_r
kiter	9	55	2321	2	kiter
lacer	7	58	3375	2	lacer
lacier	8	40	2009	2	lacier
lader	6	56	3372	2	lader
lager	6	51	3286	2	lager
lair	4	59	3415	2	lair
laker	9	54	3287	2	laker
lakier	10	47	1627	2	lakier
lamer	7	52	3370	2	lamer
lar	3	79	6753	2	l_ar
laser	5	46	3332	2	laser
later	5	48	4392	2	later
laver	8	50	3179	2	laver
laxer	12	54	2033	2	laxer
layer	8	46	2647	2	layer
lazier	15	42	1461	2	lazier
lea	3	76	6018	2	l_ea
lear	4	70	4595	2	lear
led	4	62	5455	2	l_ed
lee	3	60	6814	2	l_ee
leek	8	53	3173	2	leek
leers	5	48	2898	2	leers
leery	8	59	1913	2	leery
lees	4	54	5588	2	lees
leet	4	59	5790	2	leet
leg	4	64	4611	2	l_eg
leger	6	57	2150	2	leger
lehr	7	55	1494	2	lehr
lei	3	68	4638	2	l_ei
leis	4	57	3960	2	leis
lek	7	56	4030	2	l_ek
leper	7	48	2074	2	leper
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
lever	8	51	2516	2	lever
levier	9	40	1387	2	levier
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__
liard	6	54	1859	2	liard
liars	5	47	2316	2	liars
lib	5	77	5027	2	li_b
libber	10	44	1401	2	libber
libel	7	41	1610	2	libel
libers	8	47	2144	2	libers
libra	7	47	1242	2	libra
libri	7	46	1011	2	libri
libs	6	67	3276	2	libs
lice	6	60	4506	2	lice
lich	9	62	3084	2	lich
lick	10	69	3507	2	lick
licker	12	52	2204	2	licker
lid	4	74	5351	2	li_d
lidar	6	3	1272	2	lidar
lido	5	60	2815	2	lido
lids	5	63	3645	2	lids
lieder	7	49	1232	2	lieder
liefer	9	52	957	2	liefer
liege	6	53	1443	2	liege
liens	5	65	2550	2	liens
lierne	6	3	802	2	lierne
lieus	5	62	1848	2	lieus
lieve	8	63	1547	2	lieve
liever	9	46	1186	2	liever
life	7	54	3373	2	life
lifers	9	56	1784	2	lifers
lift	7	69	4272	2	lift
lifter	9	38	1481	2	lifter
ligers	7	50	2204	2	ligers
like	8	60	4084	2	like
liked	10	45	2381	2	liked
liken	9	118	1884	2	liken
likers	10	46	2091	2	likers
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
limb	8	54	2938	2	limb
limber	10	43	1679	2	limber
lime	6	62	4493	2	lime
limed	8	54	2680	2	limed
limen	7	54	2603	2	limen
limes	7	56	3650	2	limes
limey	10	47	2104	2	limey
limier	8	35	1872	2	limier
limmer	10	43	1479	2	limmer
limn	6	65	2769	2	limn
limner	8	41	1287	2	limner
limo	6	55	2973	2	limo
limp	8	84	3249	2	limp
limper	10	41	1785	2	limper
limy	9	57	2771	2	limy
lin	3	79	6737	2	li_n
line	4	69	6557	2	line
linear	6	51	1334	2	linear
lined	6	49	3464	2	lined
linen	5	57	2872	2	linen
liners	6	54	2885	2	liners
lines	5	70	5457	2	lines
liney	8	70	2963	2	liney
ling	5	74	4796	2	ling
linger	7	52	2600	2	linger
linier	6	44	2379	2	linier
link	8	69	4344	2	link
linker	10	43	2147	2	linker
linn	4	60	3459	2	linn
lino	4	63	4337	2	lino
lins	4	70	5905	2	lins
lint	4	162	6623	2	lint
linter	6	46	2534	2	linter
liny	7	81	4132	2	liny
lion	4	63	3444	2	lion
lip	5	147	5580	2	li_p
lipa	6	84	2592	2	lipa
lipe	6	68	3973	2	lipe
lipper	10	42	1963	2	lipper
lips	6	71	4144	2	lips
lira	4	69	2868	2	lira
liri	4	51	2825	2	liri
lis	3	71	6227	2	li_s
lisp	6	89	2688	2	lisp
lisper	8	41	1443	2	lisper
list	4	70	5534	2	list
lister	6	45	2725	2	lister
lit	3	93	7731	2	li_t
lite	4	70	5454	2	lite
liters	6	54	2988	2	liters
lither	9	45	2095	2	lither
litre	5	54	2146	2	litre
lits	4	62	5249	2	lits
litter	6	43	2485	2	litter
litu	4	76	3156	2	litu
live	7	65	4099	2	live
lived	9	55	2372	2	lived
liven	8	50	2173	2	liven
livers	9	49	2782	2	livers
livery	12	49	1090	2	livery
lives	8	61	3319	2	lives
livier	9	75	1459	2	livier
livre	8	56	1325	2	livre
livyer	12	42	629	2	livyer
logier	7	50	1573	2	logier
loiter	6	46	1917	2	loiter
loner	5	54	3104	2	loner
loper	7	51	2923	2	loper
lore	4	58	5035	2	lore
loser	5	47	2867	2	loser
lour	4	54	3068	2	lour
lover	8	55	2645	2	lover
lower	8	58	3041	2	lower
lues	4	59	4355	2	lues
luger	6	53	2208	2	luger
lunier	6	46	1760	2	lunier
lure	4	51	4246	2	lure
lurer	5	46	2531	2	lurer
lwei	7	53	1264	2	lwei
lye	6	65	3341	2	lye_
lyes	7	55	3083	2	lyes
lyre	7	56	2379	2	lyre
mien	6	50	2836	2	mien
miler	7	57	3306	2	miler
mimer	9	48	2576	2	mimer
miner	7	69	3354	2	miner
mir	5	70	4677	2	mi_r
mire	6	67	4823	2	mire
miser	7	54	3040	2	miser
miter	7	57	3479	2	miter
mixer	14	50	1764	2	mixer
nicer	7	46	1829	2	nicer
niter	5	50	2897	2	niter
oiler	5	46	2828	2	oiler
oilier	6	44	1723	2	oilier
older	6	51	2117	2	older
omer	6	70	2839	2	omer
osier	5	35	1801	2	osier
over	7	72	2734	2	over
oyer	7	59	2765	2	oyer
palier	8	50	2356	2	palier
peer	6	62	3835	2	peer
per	5	63	5309	2	_per
pie	5	54	5740	2	pie_
pied	7	50	3536	2	pied
piers	7	59	2633	2	piers
pies	6	69	4960	2	pies
piker	11	56	2284	2	piker
piper	9	65	2319	2	piper
plie	6	51	2739	2	plie_
plied	8	51	1859	2	plied
pliers	8	47	1515	2	pliers
plies	7	45	2651	2	plies
plyer	10	62	1433	2	plyer
prier	7	50	2776	2	prier
relier	6	58	2618	2	relier
ricer	7	47	2661	2	ricer
rider	6	52	3130	2	rider
riel	4	64	3238	2	riel
rifer	8	47	2198	2	rifer
rimer	7	54	2924	2	rimer
riper	7	43	2840	2	riper
riser	5	54	3105	2	riser
river	8	57	3169	2	river
ruer	4	61	2756	2	ruer
rulier	6	50	1635	2	rulier
seer	4	55	4704	2	seer
ser	3	67	5240	2	_ser
shier	8	54	2894	2	shier
sieur	5	9	1189	2	sieur
siker	9	53	2603	2	siker
sir	3	57	4667	2	si_r
sire	4	61	5041	2	sire
siver	8	57	2861	2	siver
sizer	14	55	2181	2	sizer
skier	9	51	1959	2	skier
slicer	8	41	1760	2	slicer
slider	7	39	1836	2	slider
sliver	9	41	1659	2	sliver
slyer	8	55	1512	2	slyer
spier	7	57	2803	2	spier
suer	4	53	3403	2	suer
tie	3	65	5753	2	tie_
tied	5	55	3521	2	tied
tiers	5	55	2652	2	tiers
ties	4	52	4831	2	ties
tiger	6	57	1863	2	tiger
tiler	5	61	3102	2	tiler
timer	7	56	2604	2	timer
tire	4	61	4335	2	tire
titer	5	54	3061	2	titer
trier	5	43	2853	2	trier
twier	8	47	1329	2	twier
tyer	7	53	2339	2	tyer
uglier	7	4	895	2	uglier
ulcer	7	3	1075	2	ulcer
user	4	50	2300	2	user
veer	7	62	2957	2	veer
vie	6	54	4763	2	vie_
vied	8	63	2863	2	vied
viers	8	56	2195	2	viers
vies	7	52	3862	2	vies
view	10	59	1767	2	view
viler	8	63	2416	2	viler
viper	10	50	1730	2	viper
weer	7	55	3509	2	weer
weir	7	60	1992	2	weir
wider	9	48	2635	2	wider
wilier	9	32	1707	2	wilier
wiper	10	54	2129	2	wiper
wire	7	58	3981	2	wire
wirer	8	51	2495	2	wirer
wiser	8	55	2280	2	wiser
wiver	11	59	2451	2	wiver
wrier	8	45	2175	2	wrier
yirr	7	65	1357	2	yirr

Search took 2 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.080	2233637.5
2	DLD Change Limit	29872	390	1.390	21490.6
3	Display Results	390	390	0.376	1037.2
	(SQL Overall)	178691	390	1.846	96799.0