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

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

177 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
booked	13	53	1950	(None)
bonked	13	55	1731	1	bonked
boobed	11	45	1487	1	boobed
booed	8	51	2727	1	boo_ed
bookend	14	39	664	1	bookend
booker	12	47	1919	1	booker
boomed	11	53	1813	1	boomed
booted	9	48	2273	1	booted
boozed	18	48	1383	1	boozed
borked	13	51	1729	1	borked
brooked	14	36	1003	1	brooked
cooked	13	59	2136	1	cooked
hooked	14	53	2055	1	hooked
looked	11	47	1707	1	looked
rooked	11	49	1814	1	rooked
backed	15	57	2572	2	backed
baked	12	61	3077	2	b_aked
balked	13	52	1941	2	balked
banked	13	50	2144	2	banked
barked	13	50	2731	2	barked
basked	13	52	1860	2	basked
beaked	13	59	1949	2	beaked
becked	15	54	1776	2	becked
biked	12	53	2003	2	b_iked
bilked	13	40	1294	2	bilked
blocked	16	44	998	2	blocked
bloke	11	43	1663	2	bloke_
blokes	12	38	1388	2	blokes
blooded	11	37	980	2	blooded
bloomed	12	43	943	2	bloomed
blooped	12	39	854	2	blooped
blowed	12	50	1669	2	blowed
boated	9	42	2197	2	boated
bobbed	10	43	1583	2	bobbed
boded	9	51	2496	2	b_oded
bodied	10	38	1458	2	bodied
boffed	15	36	948	2	boffed
bogged	11	60	1928	2	bogged
boiled	9	50	2095	2	boiled
boinked	14	45	704	2	boinked
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	b_oned
bonged	10	57	1960	2	bonged
boodled	11	34	1093	2	boodled
booger	9	48	1655	2	booger
boogey	12	47	1152	2	boogey
boogied	11	37	928	2	boogied
book	10	68	3633	2	book__
bookends	15	37	485	2	bookends
bookers	13	40	1661	2	bookers
bookie	12	35	1600	2	bookie
bookies	13	38	1940	2	bookies
booklet	13	23	1264	2	booklet
bookmen	15	12	626	2	bookmen
bookoo	12	4	834	2	bookoo
books	11	57	2971	2	book_s
boomer	10	46	1851	2	boomer
boosted	10	41	1198	2	boosted
bootee	8	43	2302	2	bootee
booze	16	47	1891	2	booze_
boozer	17	48	1596	2	boozer
boozes	17	49	1652	2	boozes
bopped	13	44	1340	2	bopped
bored	8	50	3430	2	b_ored
bosker	12	38	1365	2	bosker
bosket	12	49	1922	2	bosket
bosomed	12	3	800	2	bosomed
bossed	9	48	1653	2	bossed
boused	9	53	2288	2	boused
bowed	11	45	3342	2	b_owed
bowled	12	50	1814	2	bowled
bowsed	12	57	1597	2	bowsed
boxed	15	43	1861	2	b_oxed
braked	13	53	1869	2	braked
broke	11	60	1978	2	broke_
broken	12	40	1152	2	broken
broker	12	43	1424	2	broker
brooded	11	35	1093	2	brooded
broomed	12	41	1105	2	broomed
browed	12	52	1640	2	browed
bucked	15	51	2106	2	bucked
bulked	13	42	1674	2	bulked
bunked	13	51	1837	2	bunked
buoyed	12	3	669	2	buoyed
burked	13	52	2088	2	burked
busked	13	49	1770	2	busked
choked	16	49	1479	2	choked
cocked	15	50	2256	2	cocked
coked	12	47	3069	2	_coked
conked	13	50	1911	2	conked
cooed	8	45	3434	2	coo_ed
cooeed	9	59	1786	2	cooeed
cooker	12	47	2245	2	cooker
cookey	15	54	1433	2	cookey
cooled	9	52	2459	2	cooled
cooped	11	48	2161	2	cooped
corked	13	50	2078	2	corked
crooked	14	39	1095	2	crooked
docked	14	50	1833	2	docked
doomed	10	41	1329	2	doomed
evoked	14	45	788	2	evoked
fooled	10	43	1782	2	fooled
footed	10	44	1862	2	footed
forked	14	52	1714	2	forked
goofed	11	49	1138	2	goofed
goosed	8	68	1703	2	goosed
hocked	16	55	2130	2	hocked
hoked	13	53	2699	2	_hoked
holked	14	49	1366	2	holked
honked	14	45	1791	2	honked
hooded	11	46	1674	2	hooded
hoofed	13	46	1489	2	hoofed
hooker	13	48	2017	2	hooker
hookey	16	47	1393	2	hookey
hooped	12	55	1818	2	hooped
hooted	10	44	2266	2	hooted
hooved	13	47	1312	2	hooved
howked	17	73	1234	2	howked
joked	17	52	1791	2	_joked
jouked	18	56	815	2	jouked
konked	10	40	1058	2	konked
locked	13	49	2166	2	locked
looed	6	46	2613	2	loo_ed
looker	10	48	1695	2	looker
loomed	9	46	1676	2	loomed
looped	9	52	1717	2	looped
loosed	7	55	2089	2	loosed
looted	7	44	2111	2	looted
mocked	15	47	1661	2	mocked
mooed	8	51	2398	2	moo_ed
mooned	9	42	1664	2	mooned
moored	9	38	1417	2	moored
mooted	9	41	2037	2	mooted
nocked	13	46	1738	2	nocked
noosed	7	50	1802	2	noosed
oohed	9	42	1421	2	_oohed
oozed	15	42	1426	2	_oozed
pocked	15	48	1898	2	pocked
poked	12	54	2539	2	_poked
pooed	8	52	2624	2	poo_ed
poohed	12	39	1252	2	poohed
pooled	9	46	1981	2	pooled
pooped	11	39	1594	2	pooped
porked	13	47	1762	2	porked
rebooked	15	22	650	2	rebooked
rocked	13	50	2232	2	rocked
roofed	10	52	1474	2	roofed
roomed	9	52	1854	2	roomed
roosed	7	56	2160	2	roosed
rooted	7	54	2400	2	rooted
smoked	13	43	1172	2	smoked
snooked	12	37	1149	2	snooked
soaked	11	47	1759	2	soaked
socked	13	47	2150	2	socked
sooted	7	39	2259	2	sooted
spoked	13	44	1389	2	spoked
spooked	14	45	1047	2	spooked
stoked	11	47	1829	2	stoked
stooked	12	43	1230	2	stooked
toked	10	56	2649	2	_toked
tooled	7	49	1890	2	tooled
tooted	7	46	2012	2	tooted
troked	11	41	1458	2	troked
wooded	11	42	1368	2	wooded
wooed	9	44	1987	2	woo_ed
woofed	13	45	1120	2	woofed
wooled	10	37	1550	2	wooled
worked	14	53	1470	2	worked
yocked	16	41	1442	2	yocked
yoked	13	48	2162	2	_yoked
yolked	14	36	715	2	yolked
zonked	20	42	947	2	zonked
zoomed	18	36	1036	2	zoomed
zooned	16	40	1108	2	zooned

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.340	525561.8
2	DLD Change Limit	82551	177	2.550	32372.9
3	Display Results	177	177	0.060	2950.0
	(SQL Overall)	178691	177	2.950	60573.2