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

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

86 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
properly	15	4	646	(None)
property	15	4	707	1	property
improperly	19	5	194	2	improperly
popery	13	45	1170	2	p_oper_y
pronely	12	3	1025	2	prone_ly
propel	10	37	1406	2	prope_l_
propels	11	34	1284	2	prope_ls
propenyl	15	4	458	2	propenyl
proper	10	43	1995	2	proper__
properer	12	5	920	2	properer
propers	11	36	1903	2	proper_s
provenly	16	4	620	2	provenly
ropery	11	43	1387	2	_roper_y
brokenly	17	4	420	3	brokenly
brotherly	17	4	379	3	brotherly
coopery	14	39	1027	3	cooper_y
dapperly	16	4	300	3	dapperly
drapery	13	38	794	3	draper_y
erosely	10	3	808	3	erose_ly
formerly	16	4	500	3	formerly
frozenly	23	4	312	3	frozenly
grapery	13	45	795	3	graper_y
grocery	13	33	676	3	grocer_y
groper	9	45	1725	3	groper__
gropers	10	48	1385	3	groper_s
loverly	13	4	697	3	_loverly
mopery	13	52	1097	3	_moper_y
openly	11	3	712	3	__openly
orderly	11	3	576	3	or_derly
overly	12	24	1136	3	__overly
papery	13	48	1274	3	p_aper_y
peppery	13	28	625	3	pepper_y
poorly	11	3	789	3	p_o_orly
poverty	15	3	643	3	p_overty
preppily	14	4	459	3	preppily
primely	14	5	772	3	prime_ly
priorly	12	33	576	3	pr_iorly
probably	17	4	641	3	probably
prober	10	45	1607	3	prober__
probers	11	35	1458	3	prober_s
progeny	13	8	946	3	proge_ny
progeria	11	4	794	3	progeria
prolixly	20	4	311	3	prolixly
promptly	17	4	391	3	promptly
propelled	14	5	691	3	propelled
propeller	13	4	662	3	propeller
propellor	13	4	454	3	propellor
propend	12	33	1127	3	prope_nd
propends	13	24	917	3	propends
propene	11	27	1604	3	prope_ne
propenes	12	28	1651	3	propenes
propenol	12	4	647	3	propenol
propenols	13	4	634	3	propenols
propense	12	24	1010	3	propense
properdin	14	4	627	3	properdin
properest	13	4	966	3	properest
prophecy	20	4	391	3	prophecy
prophesy	18	4	445	3	prophesy
propria	11	4	993	3	prop_ria
propyl	13	35	818	3	prop_yl_
propyla	14	29	663	3	prop_yla
propyls	14	30	819	3	prop_yls
proser	8	42	2346	3	proser__
prosers	9	42	1964	3	proser_s
prosily	12	6	1163	3	pro_sily
prosper	11	40	1219	3	prosper__
prospered	14	4	697	3	prospered
prosperity	17	5	451	3	prosperity
prospers	12	30	1226	3	prosper_s
proudly	13	3	633	3	pro_udly
provably	18	4	621	3	provably
prover	11	38	1972	3	prover__
proverb	14	37	821	3	prover_b
proverbs	15	31	558	3	proverbs
provers	12	38	1779	3	prover_s
prower	11	42	1812	3	prower__
prudery	13	3	524	3	pruder_y
ripely	11	25	1115	3	_ripe_ly
roper	7	54	3191	3	_roper__
ropers	8	43	2590	3	_roper_s
ropeway	15	4	477	3	_ropeway
ropey	10	60	2187	3	_rope__y
ropily	11	33	1244	3	_rop_ily
rosery	9	38	1328	3	_roser_y
soberly	12	3	694	3	_soberly
writerly	14	4	415	3	writerly

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.623	286823.4
2	DLD Change Limit	146162	86	6.360	22981.4
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	7.013	25480.0