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

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

309 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
liers	5	51	3040	(None)
biers	7	62	2522	1	biers
fliers	9	44	1719	1	fliers
kiers	9	53	2009	1	kiers
leers	5	48	2898	1	leers
liars	5	47	2316	1	liars
libers	8	47	2144	1	libers
liens	5	65	2550	1	liens
lier	4	59	4246	1	lier_
lies	4	64	5419	1	lie_s
lieus	5	62	1848	1	lieus
lifers	9	56	1784	1	lifers
ligers	7	50	2204	1	ligers
likers	10	46	2091	1	likers
liners	6	54	2885	1	liners
liters	6	54	2988	1	liters
livers	9	49	2782	1	livers
piers	7	59	2633	1	piers
pliers	8	47	1515	1	pliers
tiers	5	55	2652	1	tiers
viers	8	56	2195	1	viers
agers	6	50	2785	2	agers
aiders	7	45	2463	2	aiders
aimers	8	46	2191	2	aimers
airers	6	49	2231	2	airers
airs	4	64	4742	2	ai_rs
aivers	9	48	2232	2	aivers
alders	7	42	1842	2	alders
aliens	6	56	1921	2	aliens
aliners	7	47	1772	2	aliners
alters	6	49	2422	2	alters
apers	7	66	2913	2	apers
avers	8	51	2731	2	avers
beers	7	56	2839	2	beers
beliers	9	46	1738	2	beliers
biders	9	48	2280	2	biders
bier	6	55	3183	2	bier_
bikers	12	45	1755	2	bikers
biners	8	50	2363	2	biners
birrs	7	49	1710	2	birrs
biters	8	39	2524	2	biters
briers	8	53	1973	2	briers
ciders	9	46	2009	2	ciders
cires	7	49	3291	2	cires
citers	8	50	2298	2	citers
clivers	12	34	1175	2	clivers
criers	8	39	1858	2	criers
deers	6	49	3052	2	deers
dicers	9	47	2074	2	dicers
dies	5	56	5352	2	die_s
diets	6	60	2664	2	diets
dikers	11	44	1879	2	dikers
dimers	9	43	2109	2	dimers
diners	7	55	2595	2	diners
divers	10	50	2496	2	divers
doers	6	52	2571	2	doers
driers	7	45	1673	2	driers
dyers	9	66	1713	2	dyers
egers	6	51	2037	2	egers
eiders	7	43	2136	2	eiders
elders	7	48	1730	2	elders
elvers	9	38	1498	2	elvers
ers	3	60	4628	2	__ers
ewers	8	60	1882	2	ewers
eyers	8	65	2133	2	eyers
fiars	8	67	2083	2	fiars
fibers	11	47	1752	2	fibers
fiefs	11	62	1370	2	fiefs
fiery	11	47	1479	2	fiery
fifers	12	54	1492	2	fifers
filers	9	46	2372	2	filers
firers	9	49	2268	2	firers
fires	8	57	4075	2	fires
firs	7	66	3771	2	fi_rs
fivers	12	44	2092	2	fivers
fixers	16	51	1298	2	fixers
fleers	9	60	1579	2	fleers
flier	8	60	2340	2	flier_
flies	8	56	3071	2	flie_s
flirs	8	55	1893	2	fli_rs
flyers	12	57	1280	2	flyers
friers	9	47	1893	2	friers
gibers	9	51	1466	2	gibers
gies	5	56	4142	2	gie_s
givers	10	48	1771	2	givers
gliders	9	48	1184	2	gliders
gluers	7	50	1115	2	gluers
goers	6	55	2025	2	goers
heirs	8	56	1856	2	heirs
hers	7	58	4487	2	_hers
hiders	10	49	1965	2	hiders
hies	7	48	4283	2	hie_s
hikers	13	50	1435	2	hikers
hirers	9	45	1806	2	hirers
hires	8	61	3434	2	hires
hoers	8	57	2492	2	hoers
ileus	5	46	1689	2	ileus
inliers	7	31	1074	2	inliers
ires	4	56	3928	2	_ires
jeers	12	48	1813	2	jeers
jibers	15	59	1288	2	jibers
jivers	16	45	1564	2	jivers
keirs	9	53	1367	2	keirs
kiefs	12	61	1220	2	kiefs
kier	8	65	2681	2	kier_
kirs	8	58	3174	2	ki_rs
kiters	10	52	1859	2	kiters
lacers	8	52	2525	2	lacers
laders	7	49	2776	2	laders
lagers	7	48	2614	2	lagers
lairs	5	54	2587	2	lairs
lakers	10	52	2515	2	lakers
lares	5	48	5263	2	lares
lars	4	69	5657	2	l_ars
lasers	6	49	2570	2	lasers
lavers	9	45	2636	2	lavers
layers	9	39	2118	2	layers
lears	5	59	3873	2	lears
leas	4	59	5418	2	l_eas
leeks	9	53	1889	2	leeks
leer	4	62	3935	2	leer_
leery	8	59	1913	2	leery
lees	4	54	5588	2	l_ees
leets	5	49	2712	2	leets
legers	7	45	1831	2	legers
legs	5	61	3369	2	l_egs
lehrs	8	61	1113	2	lehrs
leis	4	57	3960	2	l_eis
leks	8	54	2760	2	l_eks
lens	4	61	4649	2	l_ens
lepers	8	48	1732	2	lepers
les	3	56	6307	2	l_e_s
less	4	56	3510	2	l_ess
lets	4	71	4794	2	l_ets
levers	9	46	2132	2	levers
leviers	10	35	1034	2	leviers
leys	7	64	3018	2	l_eys
liar	4	72	2968	2	liar_
liard	6	54	1859	2	liard
liards	7	52	1261	2	liards
libbers	11	38	1283	2	libbers
libels	8	51	1269	2	libels
liber	7	47	2362	2	liber_
libra	7	47	1242	2	libra
libras	8	37	1170	2	libras
libri	7	46	1011	2	libri
libs	6	67	3276	2	li_bs
lickers	13	41	1825	2	lickers
licks	11	53	2539	2	licks
lidars	7	3	1078	2	lidars
lidos	6	52	1988	2	lidos
lids	5	63	3646	2	li_ds
lie	3	82	6452	2	lie__
lied	5	58	3809	2	lie_d
lief	7	60	3699	2	lie_f
liege	6	53	1443	2	liege
lieges	7	41	1344	2	lieges
lien	4	53	3980	2	lie_n
lierne	6	3	802	2	lierne
liernes	7	3	962	2	liernes
lieu	4	65	3436	2	lie_u
lieve	8	63	1547	2	lieve
lifer	8	58	2215	2	lifer_
lifters	10	43	1378	2	lifters
lifts	8	57	1906	2	lifts
liger	6	50	2447	2	liger_
likens	10	56	1370	2	likens
liker	9	56	2706	2	liker_
likes	9	62	3190	2	likes
lilos	5	58	2187	2	lilos
lilts	5	58	2280	2	lilts
limas	7	56	2763	2	limas
limbers	11	36	1474	2	limbers
limbs	9	61	1894	2	limbs
limens	8	46	1803	2	limens
limes	7	56	3650	2	limes
limeys	11	42	927	2	limeys
limmers	11	34	1308	2	limmers
limners	9	33	1156	2	limners
limns	7	57	1839	2	limns
limos	7	53	2081	2	limos
limpers	11	38	1522	2	limpers
limps	9	55	2267	2	limps
linens	6	48	1839	2	linens
liner	5	59	3892	2	liner_
lines	5	70	5457	2	lines
lingers	8	42	2330	2	lingers
lings	6	71	3577	2	lings
linkers	11	43	1771	2	linkers
links	9	64	3019	2	links
linns	5	61	2333	2	linns
linos	5	56	3150	2	linos
lins	4	70	5905	2	li_ns
linters	7	38	2263	2	linters
lints	5	71	3719	2	lints
lions	5	59	2321	2	lions
lippers	11	34	1644	2	lippers
lips	6	71	4144	2	li_ps
lira	4	69	2868	2	li_ra
liras	5	60	2198	2	liras
lire	4	78	4529	2	li_re
liri	4	51	2825	2	li_ri
lis	3	71	6227	2	li__s
lispers	9	45	1432	2	lispers
lisps	7	69	1391	2	lisps
listers	7	40	2653	2	listers
lists	5	66	2869	2	lists
litas	5	49	2377	2	litas
liter	5	47	3634	2	liter_
litre	5	54	2146	2	litre
litres	6	52	2039	2	litres
lits	4	62	5249	2	li_ts
litters	7	34	2257	2	litters
livens	9	43	1489	2	livens
liver	8	51	3296	2	liver_
livery	12	49	1090	2	livery
lives	8	61	3319	2	lives
liviers	10	42	1107	2	liviers
livre	8	56	1325	2	livre
livres	9	43	1186	2	livres
livyers	13	36	590	2	livyers
loess	5	57	1470	2	loess
loiters	7	41	1661	2	loiters
loners	6	42	2581	2	loners
lopers	8	44	2414	2	lopers
lores	5	50	4540	2	lores
losers	6	51	2358	2	losers
lours	5	51	2529	2	lours
lovers	9	42	2343	2	lovers
lowers	9	46	2492	2	lowers
lues	4	59	4355	2	lue_s
lugers	7	46	1702	2	lugers
lurers	6	42	1749	2	lurers
lures	5	61	3853	2	lures
lweis	8	45	869	2	lweis
lyes	7	55	3083	2	lye_s
lyres	8	50	1996	2	lyres
miens	7	61	1830	2	miens
milers	8	46	2516	2	milers
mimers	10	55	2018	2	mimers
miners	8	41	2663	2	miners
mires	7	56	4088	2	mires
mirs	6	69	4057	2	mi_rs
misers	8	50	2570	2	misers
miters	8	43	2878	2	miters
mixers	15	45	1356	2	mixers
niters	6	46	2421	2	niters
oilers	6	47	2119	2	oilers
omers	7	69	2319	2	omers
osiers	6	34	1279	2	osiers
overs	8	52	2479	2	overs
oyers	8	76	2088	2	oyers
peers	7	51	3027	2	peers
pier	6	60	3529	2	pier_
pies	6	69	4960	2	pie_s
pikers	12	47	1739	2	pikers
pipers	10	43	1866	2	pipers
plier	7	52	2128	2	plier_
plies	7	45	2651	2	plie_s
plyers	11	49	1298	2	plyers
priers	8	45	2119	2	priers
reliers	7	55	1921	2	reliers
ricers	8	41	2099	2	ricers
riders	7	41	2390	2	riders
riels	5	51	2133	2	riels
rimers	8	45	2255	2	rimers
risers	6	46	2478	2	risers
rivers	9	46	2654	2	rivers
ruers	5	150	1941	2	ruers
seers	5	51	3638	2	seers
sers	4	57	4665	2	_sers
shiers	9	49	2175	2	shiers
sieurs	6	5	904	2	sieurs
sires	5	59	4537	2	sires
sirs	4	43	3833	2	si_rs
sivers	9	53	2415	2	sivers
sizers	15	52	1581	2	sizers
skiers	10	47	1370	2	skiers
slicers	9	41	1492	2	slicers
sliders	8	35	1522	2	sliders
slier	5	48	2724	2	slier_
slivers	10	41	1525	2	slivers
spiers	8	44	2174	2	spiers
suers	5	51	2848	2	suers
tier	4	49	3614	2	tier_
ties	4	52	4831	2	tie_s
tigers	7	56	1651	2	tigers
tilers	6	35	2350	2	tilers
timers	8	44	2099	2	timers
tires	5	54	3749	2	tires
titers	6	45	2641	2	titers
triers	6	43	2152	2	triers
twiers	9	54	1016	2	twiers
tyers	8	62	2005	2	tyers
ulcers	8	3	938	2	ulcers
users	5	58	1757	2	users
veers	8	45	2136	2	veers
vier	7	54	2815	2	vier_
vies	7	52	3862	2	vie_s
views	11	48	964	2	views
vipers	11	49	1453	2	vipers
vires	8	45	2968	2	vires
vivers	12	47	1736	2	vivers
weirs	8	43	1649	2	weirs
wipers	11	54	1608	2	wipers
wirers	9	46	1789	2	wirers
wires	8	60	3491	2	wires
wivers	12	53	2080	2	wivers
yirrs	8	46	919	2	yirrs

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	53800	0.313	570897.8
2	DLD Change Limit	53800	309	1.890	28465.6
3	Display Results	309	309	0.170	1817.6
	(SQL Overall)	178691	309	2.373	75301.7