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

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

63 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
dapperly	16	4	300	(None)
dapper	11	40	1663	2	dapper__
dapperer	13	3	576	2	dapperer
angerly	11	3	777	3	_angerly
apery	10	65	1790	3	_a_per_y
appeal	10	39	1161	3	_appeal_
appeals	11	37	867	3	_appeals
appel	9	46	1589	3	_appe_l_
appels	10	43	1279	3	_appe_ls
apply	12	51	1139	3	_app__ly
badgerly	15	4	328	3	badgerly
bankerly	17	4	433	3	bankerly
capper	12	44	2198	3	capper__
cappers	13	44	1940	3	capper_s
coppery	16	40	939	3	copper_y
damper	11	41	1775	3	damper__
dampers	12	39	1569	3	damper_s
damply	14	33	789	3	damp__ly
dapped	12	45	1676	3	dappe__d
dapperest	14	4	528	3	dapperest
dapple	11	3	885	3	dapp__le
datedly	12	3	602	3	da_tedly
daubery	13	39	621	3	dauber_y
dazedly	21	3	406	3	da_zedly
dipper	11	40	1779	3	dipper__
dippers	12	36	1518	3	dipper_s
drapery	13	38	794	3	draper_y
dupery	12	37	874	3	d_uper_y
eagerly	11	3	605	3	ea_gerly
easterly	11	24	664	3	easterly
fatherly	17	4	507	3	fatherly
foppery	17	38	562	3	fopper_y
happily	17	4	576	3	happ_ily
japery	18	43	914	3	ja_per_y
jaspery	19	40	525	3	jasper_y
lapper	10	43	1995	3	lapper__
lappered	13	28	821	3	lappered
lappers	11	37	1746	3	lapper_s
latterly	11	3	606	3	latterly
lawyerly	17	4	214	3	lawyerly
mannerly	13	4	498	3	mannerly
mapper	12	45	1609	3	mapper__
mappers	13	33	1378	3	mapper_s
masterly	13	31	765	3	masterly
napery	11	48	981	3	na_per_y
napper	10	37	1828	3	napper__
nappers	11	42	1486	3	napper_s
papery	13	48	1274	3	pa_per_y
peppery	13	28	625	3	pepper_y
properly	15	4	646	3	properly
rappel	10	42	1195	3	rappe_l_
rappels	11	44	880	3	rappe_ls
rapper	10	46	2157	3	rapper__
rappers	11	36	1844	3	rapper_s
sapper	10	38	2235	3	sapper__
sappers	11	35	1890	3	sapper_s
sappily	14	3	716	3	sapp_ily
tapper	10	44	1961	3	tapper__
tappers	11	34	1654	3	tapper_s
yapper	13	37	1451	3	yapper__
yappers	14	40	1225	3	yapper_s
zapper	19	34	1402	3	zapper__
zappers	20	39	1163	3	zapper_s

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.406	440125.6
2	DLD Change Limit	146162	63	7.186	20339.8
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	7.622	23444.1