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

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

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.

76 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
scalped	12	44	1199	(None)
scalded	11	40	976	1	scalded
scaled	9	48	2244	1	scal_ed
scalpel	11	37	771	1	scalpel
scalper	11	39	1292	1	scalper
scamped	14	47	1196	1	scamped
scaped	11	55	1955	1	sca_ped
scarped	12	43	1440	1	scarped
sculped	12	39	825	1	sculped
calked	13	46	1740	2	_calked
called	9	41	2673	2	_called
calmed	11	48	1638	2	_calmed
calved	12	52	1545	2	_calved
camped	13	47	2023	2	_camped
caped	10	49	3180	2	_ca_ped
capped	13	47	2185	2	_capped
carped	11	59	2376	2	_carped
escaloped	14	4	398	2	escaloped
escaped	12	38	885	2	esca_ped
escarped	13	5	516	2	escarped
palped	11	45	1364	2	_palped
salpid	9	5	1088	2	s_alpid
salted	7	41	2120	2	s_alted
salved	10	39	1642	2	s_alved
sapped	11	44	2201	2	s_apped
scabbed	14	40	822	2	scabbed
scalade	10	35	926	2	scalade
scald	8	48	1812	2	scal__d
scale	7	46	2914	2	scal_e_
scaler	8	43	2160	2	scal_er
scales	8	45	2931	2	scal_es
scalier	9	43	1691	2	scalier
scalloped	14	4	446	2	scalloped
scalp	9	52	1798	2	scalp__
scalpels	12	34	588	2	scalpels
scalpers	12	37	1086	2	scalpers
scalps	10	43	1523	2	scalp_s
scammed	14	47	954	2	scammed
scamper	13	46	1316	2	scamper
scanned	10	41	1089	2	scanned
scanted	10	41	1439	2	scanted
scape	9	69	2184	2	sca_pe_
scapes	10	51	2226	2	sca_pes
scared	9	52	2729	2	sca_red
scarfed	13	47	1118	2	scarfed
scarper	11	48	1482	2	scarper
scarphed	16	3	544	2	scarphed
scarred	10	45	1263	2	scarred
scarted	10	48	1612	2	scarted
scathed	13	40	1264	2	scathed
scatted	10	35	1277	2	scatted
scauper	11	37	945	2	scauper
scolded	11	35	886	2	scolded
scooped	12	46	1174	2	scooped
scoped	11	51	1665	2	sc_oped
scraped	12	43	1313	2	scraped
scrapped	15	5	653	2	scrapped
sculked	14	30	718	2	sculked
sculled	10	29	1169	2	sculled
sculpted	13	5	488	2	sculpted
sealed	7	43	2836	2	seal_ed
shaled	10	50	2395	2	shal_ed
shaped	12	50	2010	2	sha_ped
sharped	13	41	1205	2	sharped
skelped	14	3	520	2	skelped
slapped	12	35	1184	2	slapped
snapped	12	46	1120	2	snapped
soaped	9	58	1797	2	soa_ped
spalled	10	31	1313	2	spalled
staled	7	47	2810	2	stal_ed
stalked	12	38	1117	2	stalked
stalled	8	35	1568	2	stalled
stamped	12	48	1281	2	stamped
stapled	10	36	1370	2	stapled
swamped	15	49	844	2	swamped
swapped	15	42	914	2	swapped

Search took 4 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	107671	0.390	458182.1
2	DLD Change Limit	107671	76	3.423	31455.2
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	3.846	46461.5