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

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

137 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
popped	10	41	1781	(None)
bopped	13	44	1340	1	bopped
copped	13	52	2125	1	copped
fopped	14	40	1267	1	fopped
hopped	14	43	1811	1	hopped
lopped	11	42	1862	1	lopped
mopped	13	41	1432	1	mopped
pepped	10	31	1340	1	pepped
pipped	10	45	1654	1	pipped
plopped	11	28	877	1	plopped
pooped	11	39	1594	1	pooped
popper	9	36	1596	1	popper
poppet	9	27	1732	1	poppet
poppied	11	38	898	1	poppied
poppled	11	33	924	1	poppled
propped	11	33	1195	1	propped
pupped	10	50	1327	1	pupped
sopped	11	48	1990	1	sopped
topped	11	46	1772	1	topped
bopper	12	38	1383	2	bopper
capped	13	47	2185	2	capped
chopped	17	45	1100	2	chopped
clopped	14	36	1152	2	clopped
comped	13	59	1987	2	comped
cooped	11	48	2160	2	cooped
coped	10	50	3684	2	co_ped
copied	11	46	1856	2	copied
copper	12	43	2189	2	copper
couped	11	50	1931	2	couped
cropped	14	38	1206	2	cropped
cupped	13	44	1398	2	cupped
dapped	12	45	1676	2	dapped
dipped	12	35	1749	2	dipped
doped	9	53	2671	2	do_ped
dropped	13	32	928	2	dropped
dupped	12	44	1164	2	dupped
flopped	15	33	876	2	flopped
gapped	12	42	1712	2	gapped
gipped	12	48	1590	2	gipped
glopped	13	34	761	2	glopped
gypped	15	37	711	2	gypped
happed	14	48	2010	2	happed
hipped	14	43	1769	2	hipped
hooped	12	55	1818	2	hooped
hoped	11	56	2818	2	ho_ped
hopper	13	42	1848	2	hopper
hoppled	15	33	808	2	hoppled
kepped	15	30	953	2	kepped
kipped	15	31	1457	2	kipped
knopped	16	35	545	2	knopped
lapped	11	43	2003	2	lapped
lipped	11	44	1954	2	lipped
looped	9	52	1717	2	looped
loped	8	51	2833	2	lo_ped
lopper	10	37	1720	2	lopper
louped	9	53	1638	2	louped
mapped	13	40	1588	2	mapped
moped	10	54	2473	2	mo_ped
mopper	12	62	1500	2	mopper
moppet	12	69	1509	2	moppet
napped	11	42	1816	2	napped
nipped	11	36	1585	2	nipped
oped	7	62	3015	2	_o_ped
opted	8	49	1427	2	_opted
palped	11	45	1364	2	palped
peeped	11	39	1539	2	peeped
peopled	12	3	850	2	peopled
pepper	9	35	1294	2	pepper
pimped	13	49	1348	2	pimped
piped	10	51	2316	2	p_iped
pocked	15	48	1898	2	pocked
podded	11	50	1271	2	podded
poised	9	49	1847	2	poised
poked	12	54	2539	2	po_ked
poled	8	49	3484	2	po_led
polled	9	40	2200	2	polled
polyped	15	3	717	2	polyped
ponced	11	43	1481	2	ponced
ponded	10	52	1877	2	ponded
ponged	10	56	1935	2	ponged
ponied	9	49	2070	2	ponied
pooed	8	52	2624	2	po_oed
poohed	12	39	1252	2	poohed
pooled	9	46	1981	2	pooled
pope	8	55	3561	2	po_pe_
popes	9	59	3381	2	po_pes
popeyed	15	3	571	2	popeyed
poppa	8	40	989	2	popp_a
poppas	9	37	1071	2	poppas
poppers	10	34	1486	2	poppers
poppets	10	33	885	2	poppets
poppies	10	28	1619	2	poppies
popple	9	27	1098	2	popple
popples	10	30	1187	2	popples
poppy	11	48	1319	2	popp_y
pored	8	52	3451	2	po_red
porked	13	47	1762	2	porked
ported	9	42	2324	2	ported
posed	8	58	2841	2	po_sed
posted	9	37	2249	2	posted
potted	9	46	2401	2	potted
poufed	12	44	971	2	poufed
poured	9	51	1674	2	poured
pouted	9	40	2139	2	pouted
poxed	15	48	1786	2	po_xed
prepped	11	32	990	2	prepped
pulped	11	46	1253	2	pulped
pumped	13	39	1556	2	pumped
puppet	9	35	1459	2	puppet
rapped	11	41	2268	2	rapped
repped	11	46	1672	2	repped
ripped	11	44	1901	2	ripped
romped	11	45	1365	2	romped
roped	8	46	3080	2	ro_ped
rouped	9	57	1735	2	rouped
sapped	11	44	2201	2	sapped
shopped	15	35	1221	2	shopped
sipped	11	37	2063	2	sipped
slopped	12	35	1144	2	slopped
soaped	9	58	1797	2	soaped
souped	9	50	1767	2	souped
stopped	12	45	1220	2	stopped
supped	11	44	1570	2	supped
swopped	15	43	767	2	swopped
tapped	11	38	2005	2	tapped
tipped	11	44	1826	2	tipped
toped	8	56	3131	2	to_ped
topper	10	38	1760	2	topper
toppled	12	34	884	2	toppled
tupped	11	40	1323	2	tupped
upped	10	37	1516	2	_upped
wapped	14	44	1647	2	wapped
whopped	18	35	800	2	whopped
yapped	14	44	1514	2	yapped
yipped	14	36	1328	2	yipped
zapped	20	42	1352	2	zapped
zipped	20	36	1298	2	zipped

Search took 5 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.343	520965.0
2	DLD Change Limit	82551	137	3.673	22475.1
3	Display Results	137	137	0.046	2978.3
	(SQL Overall)	178691	137	4.062	43990.9