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

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

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.

59 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
brooking	15	37	1070	(None)
booking	14	36	1838	1	b_ooking
broking	14	35	1482	1	br_oking
brooding	12	29	1137	1	brooding
brooming	13	29	1114	1	brooming
crooking	15	36	1134	1	crooking
rooking	12	35	1736	1	_rooking
blocking	17	45	1057	2	blocking
blooding	12	24	1065	2	blooding
blooming	13	29	943	2	blooming
blooping	13	24	884	2	blooping
bonking	14	41	1637	2	b_onking
boobing	12	36	1391	2	b_oobing
booing	9	45	2164	2	b_oo_ing
bookings	15	35	873	2	b_ookings
booming	12	37	1622	2	b_ooming
booting	10	38	2136	2	b_ooting
boozing	19	40	1216	2	b_oozing
borking	14	47	1617	2	b_orking
braking	14	39	1771	2	br_aking
breaking	15	39	1425	2	breaking
bricking	17	39	1140	2	bricking
brisking	15	32	947	2	brisking
broiling	11	31	1201	2	broiling
brokings	15	31	771	2	br_okings
bronzing	20	3	769	2	bronzing
brookie	13	4	737	2	brooki_e
brookies	14	5	914	2	brookies
brookite	14	4	550	2	brookite
browning	14	29	964	2	browning
browsing	14	31	935	2	browsing
cooking	14	38	1897	2	_cooking
croaking	15	37	1216	2	croaking
crocking	17	43	1344	2	crocking
crooning	11	31	1211	2	crooning
drooling	10	26	1042	2	drooling
drooping	12	26	880	2	drooping
drouking	14	3	644	2	drouking
frocking	18	30	957	2	frocking
grokking	13	3	481	2	grokking
grooming	12	30	951	2	grooming
grooving	13	28	671	2	grooving
hooking	15	37	1669	2	_hooking
looking	12	34	1504	2	_looking
proofing	14	3	931	2	proofing
provoking	19	3	513	2	provoking
rocking	14	36	1963	2	_rocking
roofing	11	38	1435	2	_roofing
rooming	10	41	1704	2	_rooming
roosing	8	40	1813	2	_roosing
rooting	8	35	2243	2	_rooting
snooking	13	30	1058	2	snooking
spooking	15	26	980	2	spooking
stooking	13	27	1114	2	stooking
troaking	13	33	1097	2	troaking
trocking	15	36	1242	2	trocking
troking	12	35	1410	2	tr_oking
trooping	11	27	1027	2	trooping
vrooming	14	28	735	2	vrooming

Search took 8 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	121059	0.156	1145455.1
2	DLD Change Limit	121059	59	6.876	17606.0
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	7.062	25303.2