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

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

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.

83 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
rookeries	13	13	817	(None)
cookeries	15	12	1063	1	cookeries
crookeries	16	4	613	1	crookeries
rockeries	15	12	897	1	rockeries
booteries	11	3	1277	2	booteries
cooperies	13	11	1331	2	cooperies
crockeries	18	5	711	2	crockeries
fooleries	12	4	874	2	fooleries
mockeries	17	12	826	2	mockeries
monkeries	15	12	991	2	monkeries
robberies	13	10	739	2	robberies
rocketries	16	4	589	2	rocketries
rogueries	10	4	700	2	rogueries
rookies	11	39	1710	2	rook__ies
roperies	10	3	1576	2	r_operies
roseries	8	3	1731	2	r_oseries
spookeries	16	5	429	2	spookeries
bakeries	14	3	1219	3	_bakeries
bloomeries	14	4	610	3	bloomeries
bobberies	12	10	789	3	bobberies
boiseries	11	4	1104	3	boiseries
bookers	13	40	1661	3	booker__s
bookies	13	38	1940	3	book__ies
boweries	13	3	1229	3	_boweries
brogueries	13	4	481	3	brogueries
broideries	13	4	635	3	broideries
brookies	14	5	914	3	brook__ies
congeries	12	3	1640	3	congeries
cookers	13	46	1946	3	cooker__s
cookies	13	37	1927	3	cook__ies
coteries	10	4	2270	3	_coteries
dodgeries	12	4	659	3	dodgeries
doggeries	12	4	667	3	doggeries
doweries	12	4	1193	3	_doweries
drolleries	11	4	544	3	drolleries
fakeries	15	5	983	3	_fakeries
fopperies	16	6	601	3	fopperies
forgeries	13	3	1000	3	forgeries
groceries	12	4	950	3	groceries
groggeries	13	5	470	3	groggeries
hookers	14	49	1652	3	hooker__s
hookies	14	40	1744	3	hook__ies
hosieries	12	4	921	3	hosieries
jobberies	20	11	542	3	jobberies
joineries	16	4	810	3	joineries
lookers	11	40	1407	3	looker__s
lotteries	9	3	1107	3	lotteries
moperies	12	3	1387	3	_moperies
nookies	11	34	1496	3	nook__ies
oogenies	9	3	1158	3	_oogenies
orogenies	10	4	1053	3	orogenies
orreries	8	3	1012	3	_orreries
ozokerites	23	6	202	3	ozokerites
poperies	12	3	1679	3	_poperies
potteries	11	3	1359	3	potteries
recoveries	15	4	746	3	recoveries
reveries	11	25	1851	3	r_everies
rifleries	12	4	768	3	rifleries
robotries	11	4	732	3	robotries
rockabies	17	4	422	3	rockabies
rockers	13	39	1655	3	rocker__s
roofers	10	50	1390	3	roofer__s
roofies	10	30	1441	3	roo__fies
rooftrees	12	4	240	3	rooftrees
rookery	14	39	831	3	rooker__y
rookie	10	36	1326	3	rook__ie_
rookier	11	40	1238	3	rook__ier
rookiest	12	29	1217	3	rook__iest
roomers	9	54	1641	3	roomer__s
roomettes	11	4	654	3	roomettes
roomies	9	30	1724	3	roo__mies
roosers	7	42	1788	3	rooser__s
rooters	7	45	2293	3	rooter__s
rosaries	8	3	1278	3	r_osaries
rotaries	8	3	1569	3	r_otaries
ruderies	9	3	1133	3	r_uderies
sorceries	11	4	993	3	sorceries
spooferies	15	4	370	3	spooferies
toggeries	11	4	621	3	toggeries
trickeries	16	4	714	3	trickeries
voleries	11	3	1323	3	_voleries
zoogenies	19	4	683	3	zoogenies
zoometries	21	4	707	3	zoometries

Search took 7 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	148641	0.406	440125.6
2	DLD Change Limit	148641	83	6.373	23323.6
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	6.825	26181.8