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

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

156 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
palped	11	45	1364	(None)
paled	8	55	3872	1	pal_ed
palled	9	46	2516	1	palled
palmed	11	43	1464	1	palmed
pulped	11	46	1253	1	pulped
aliped	9	54	1428	2	_aliped
amped	10	48	2051	2	_amped
aped	7	85	3815	2	_a_ped
balded	10	54	1751	2	balded
baled	8	54	3644	2	bal_ed
balked	13	52	1941	2	balked
balled	9	49	2689	2	balled
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
damped	12	43	1558	2	damped
dapped	12	45	1676	2	dapped
galled	8	46	2285	2	galled
galoped	11	13	806	2	galoped
gaped	9	61	2353	2	ga_ped
gapped	12	42	1712	2	gapped
gasped	10	48	1429	2	gasped
gawped	13	50	907	2	gawped
gulped	10	46	1037	2	gulped
haled	9	53	3582	2	hal_ed
haloed	10	47	1759	2	haloed
halted	10	50	1960	2	halted
halved	13	48	1390	2	halved
happed	14	48	2010	2	happed
harped	12	44	1840	2	harped
hasped	12	50	1444	2	hasped
helped	12	47	1415	2	helped
japed	15	62	1763	2	ja_ped
jauped	16	45	790	2	jauped
kelped	13	44	954	2	kelped
lalled	7	42	1875	2	lalled
lamped	11	40	1754	2	lamped
lapped	11	43	2003	2	lapped
malfed	12	36	975	2	malfed
malled	9	46	2610	2	malled
malted	9	48	1985	2	malted
mapped	13	40	1588	2	mapped
naled	6	55	2505	2	nal_ed
napped	11	42	1816	2	napped
paced	10	69	3168	2	pa_ced
packed	15	48	2260	2	packed
padded	11	41	1350	2	padded
paged	9	59	2678	2	pa_ged
paiked	13	51	1343	2	paiked
pained	9	56	2285	2	pained
paired	9	50	1752	2	paired
palaced	12	41	1077	2	palaced
pale	6	60	5501	2	pal_e_
palea	7	50	2866	2	pal_ea
paler	7	54	3693	2	pal_er
pales	7	57	5380	2	pal_es
palet	7	46	5080	2	pal_et
palier	8	50	2356	2	palier
pallet	8	42	3265	2	pallet
pallid	9	39	1527	2	pallid
palmer	10	58	1654	2	palmer
palp	8	58	2857	2	palp__
palpal	10	41	1205	2	palpal
palpated	13	24	976	2	palpated
palpi	9	54	1455	2	palp_i
palps	9	47	1956	2	palp_s
palpus	10	42	1028	2	palpus
palsied	10	29	1130	2	palsied
palter	8	44	2326	2	palter
pamper	12	43	1666	2	pamper
paned	8	54	3718	2	pa_ned
panged	10	47	2233	2	panged
panned	9	41	2343	2	panned
panted	9	50	2482	2	panted
paper	9	51	2866	2	pa_per
pared	8	69	4676	2	pa_red
parged	10	49	2203	2	parged
parked	13	44	2513	2	parked
parled	9	46	2627	2	parled
parred	9	50	2407	2	parred
parsed	9	63	2389	2	parsed
parted	9	42	2868	2	parted
pashed	12	59	2314	2	pashed
passed	9	43	2094	2	passed
pasted	9	44	2690	2	pasted
pated	8	52	3784	2	pa_ted
patted	9	47	2468	2	patted
pauper	10	35	1194	2	pauper
paused	9	51	1496	2	paused
paved	11	55	2526	2	pa_ved
paveed	12	43	889	2	paveed
pawed	11	57	2561	2	pa_wed
pawned	12	45	1328	2	pawned
payed	11	59	2593	2	pa_yed
pealed	9	53	2280	2	peal_ed
peeped	11	39	1538	2	peeped
pelted	9	46	1775	2	pelted
pepped	10	31	1339	2	pepped
piled	8	52	3299	2	pil_ed
pilled	9	42	2275	2	pilled
pimped	13	49	1348	2	pimped
piped	10	51	2316	2	p_iped
pipped	10	45	1654	2	pipped
placed	11	43	1800	2	placed
planed	9	44	2091	2	planed
plated	9	52	2577	2	plated
played	12	48	1503	2	played
pled	7	52	3143	2	p_l_ed
plied	8	51	1859	2	p_lied
poled	8	49	3484	2	pol_ed
polled	9	40	2200	2	polled
polyped	15	3	717	2	polyped
pooped	11	39	1594	2	pooped
popped	10	41	1781	2	popped
psalmed	12	3	450	2	psalmed
puled	8	49	2652	2	pul_ed
pulled	9	43	2219	2	pulled
pulper	10	35	1327	2	pulper
pulsed	9	40	1372	2	pulsed
pumped	13	39	1556	2	pumped
pupped	10	50	1327	2	pupped
ralphed	13	3	436	2	ralphed
ramped	11	46	1790	2	ramped
raped	8	53	3462	2	ra_ped
rapped	11	41	2268	2	rapped
rasped	9	47	1520	2	rasped
salpid	9	5	1087	2	salpid
salted	7	41	2120	2	salted
salved	10	39	1642	2	salved
sapped	11	44	2201	2	sapped
scalped	12	44	1199	2	scalped
spalled	10	31	1312	2	spalled
talced	9	38	1100	2	talced
taliped	10	7	820	2	taliped
talked	11	40	1540	2	talked
tamped	11	43	1704	2	tamped
taped	8	53	2742	2	ta_ped
tapped	11	38	2005	2	tapped
valued	10	40	1115	2	valued
valved	13	67	1104	2	valved
vamped	14	42	1101	2	vamped
waled	9	43	3099	2	wal_ed
walked	14	53	1378	2	walked
walled	10	40	2129	2	walled
wapped	14	44	1647	2	wapped
warped	12	48	1641	2	warped
yapped	14	44	1514	2	yapped
yauped	12	40	833	2	yauped
yawped	15	52	810	2	yawped
yelped	12	43	936	2	yelped
zapped	20	42	1352	2	zapped

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	82551	0.123	1452772.4
2	DLD Change Limit	82551	156	3.470	23789.9
3	Display Results	156	156	0.110	1418.2
	(SQL Overall)	178691	156	3.703	48255.7