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

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

128 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
bopped	13	44	1340	(None)
bopper	12	38	1383	1	bopper
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
popped	10	41	1781	1	popped
sopped	11	48	1990	1	sopped
topped	11	46	1772	1	topped
beeped	11	53	1345	2	beeped
biped	10	47	1883	2	b_iped
blipped	14	37	719	2	blipped
blooped	12	39	854	2	blooped
boated	9	42	2197	2	boated
bobbed	10	43	1583	2	bobbed
boded	9	51	2496	2	bo_ded
bodied	10	38	1458	2	bodied
boffed	15	36	948	2	boffed
bogged	11	60	1928	2	bogged
boiled	9	50	2095	2	boiled
bolled	9	47	2265	2	bolled
bolted	9	46	1780	2	bolted
bombed	13	41	1387	2	bombed
bonded	10	47	1995	2	bonded
boned	8	51	3324	2	bo_ned
bonged	10	57	1960	2	bonged
bonked	13	55	1731	2	bonked
boobed	11	45	1487	2	boobed
booed	8	51	2727	2	bo_oed
booked	13	53	1950	2	booked
boomed	11	53	1813	2	boomed
booted	9	48	2273	2	booted
boozed	18	48	1383	2	boozed
bopeep	12	3	676	2	bopeep
boppers	13	39	1192	2	boppers
bored	8	50	3430	2	bo_red
borked	13	51	1729	2	borked
bossed	9	48	1653	2	bossed
boused	9	53	2288	2	boused
bowed	11	45	3342	2	bo_wed
bowled	12	50	1814	2	bowled
bowsed	12	57	1597	2	bowsed
boxed	15	43	1861	2	bo_xed
bumped	13	44	1400	2	bumped
burped	11	62	1550	2	burped
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	954	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
pepped	10	31	1340	2	pepped
pipped	10	45	1654	2	pipped
plopped	11	28	877	2	plopped
pooped	11	39	1594	2	pooped
popper	9	36	1596	2	popper
poppet	9	27	1732	2	poppet
poppied	11	38	898	2	poppied
poppled	11	33	924	2	poppled
propped	11	33	1195	2	propped
pupped	10	50	1327	2	pupped
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 3 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	128	2.360	34979.2
3	Display Results	128	128	0.046	2782.6
	(SQL Overall)	178691	128	2.749	65002.2