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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

92 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
linearly	11	4	679	(None)
lineally	11	3	779	1	lineally
biyearly	16	4	339	2	biyearly
lineable	10	18	1108	2	lineable
lineal	6	56	1602	2	linea_l_
linear	6	51	1334	2	linear__
linearity	12	4	611	2	linearity
nearly	9	48	1373	2	__nearly
binary	11	3	1222	3	bin_ar_y
cinerary	13	4	643	3	cinerary
clearly	12	3	666	3	_clearly
clinally	13	4	723	3	clin_ally
dearly	10	46	1532	3	__dearly
early	8	53	2412	3	___early
finally	13	3	1010	3	fin_ally
fineable	13	18	1033	3	fineable
finely	12	30	1156	3	fine__ly
finery	12	45	1289	3	fine_r_y
gingerly	13	31	530	3	gingerly
gnarly	10	46	1038	3	_gn_arly
ideally	11	3	779	3	_ideally
inearth	10	3	704	3	_inearth
ineptly	12	4	507	3	_ineptly
inertly	10	3	854	3	_inertly
innerly	10	3	713	3	_innerly
inwardly	15	4	378	3	_inwardly
lanely	9	39	1448	3	lane__ly
laniary	10	6	801	3	laniar_y
leally	9	40	1261	3	l__eally
leanly	9	38	1150	3	l__eanly
leary	8	59	2738	3	l__ear_y
liberal	9	3	1019	3	liberal_
liberally	14	4	626	3	liberally
liberals	10	3	941	3	liberals
liberty	12	3	716	3	libe_rty
library	12	4	532	3	librar_y
liefly	12	6	636	3	li_e_fly
lienable	10	18	869	3	lienable
lienal	6	39	1278	3	liena_l_
likeable	14	16	647	3	likeable
likely	13	32	813	3	like__ly
limberly	15	4	446	3	limberly
linable	9	22	1434	3	lin_able
lineage	8	7	898	3	linea_ge
lineages	9	7	918	3	lineages
lineality	12	4	642	3	lineality
linearise	9	4	643	3	linearise
linearize	18	4	575	3	linearize
lineate	7	8	1515	3	linea_te
lineated	9	7	1106	3	lineated
linebred	11	4	496	3	linebred
lineny	9	40	1144	3	line__ny
liner	5	59	3892	3	line_r__
liners	6	54	2885	3	line_r_s
liney	8	70	2963	3	line___y
lingually	13	4	437	3	lingually
linkable	14	18	726	3	linkable
literacy	13	4	680	3	literacy
literal	7	6	1327	3	literal_
literally	12	4	834	3	literally
literals	8	3	1229	3	literals
literarily	13	5	427	3	literarily
literary	11	4	775	3	literary
liveable	13	17	766	3	liveable
livelily	14	4	410	3	livelily
lively	12	33	1081	3	live__ly
livery	12	49	1090	3	live_r_y
lonelily	11	4	497	3	lonelily
lonely	9	29	1247	3	lone__ly
loveably	16	17	523	3	loveably
loverly	13	4	697	3	love_rly
mineable	12	16	1105	3	mineable
mineral	9	3	1273	3	mineral_
minerals	10	3	1138	3	minerals
miserly	12	32	982	3	mise_rly
nearby	11	35	605	3	__nearby
neatly	9	38	1248	3	__neatly
pearly	11	64	1484	3	__pearly
pineal	8	48	1768	3	pinea_l_
pineals	9	32	1284	3	pinea_ls
pinery	11	52	1429	3	pine_r_y
sizeably	22	4	468	3	sizeably
snarly	9	38	1500	3	_sn_arly
tineal	6	62	1616	3	tinea_l_
tuneably	13	4	609	3	tuneably
vicarly	15	3	646	3	vi_carly
vineal	9	48	1474	3	vinea_l_
vinegary	15	4	389	3	vinegar_y
vinery	12	49	1260	3	vine_r_y
winery	12	50	1428	3	wine_r_y
winterly	14	30	674	3	winterly
yearly	12	52	1027	3	__yearly

Search took 8 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	146162	0.436	409841.7
2	DLD Change Limit	146162	92	7.236	20199.3
3	Display Results	92	92	0.030	3066.7
	(SQL Overall)	178691	92	7.702	23200.6