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

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

78 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
stooked	12	43	1230	(None)
snooked	12	37	1149	1	snooked
spooked	14	45	1047	1	spooked
stocked	14	43	1287	1	stocked
stoked	11	47	1829	1	st_oked
stooged	9	43	1073	1	stooged
stooker	11	38	1173	1	stooker
stooled	8	43	1389	1	stooled
stooped	10	38	1383	1	stooped
stroked	12	46	1362	1	stroked
booked	13	53	1950	2	_booked
brooked	14	36	1003	2	brooked
cooked	13	59	2136	2	_cooked
crooked	14	39	1094	2	crooked
hooked	14	53	2055	2	_hooked
looked	11	47	1707	2	_looked
rooked	11	49	1814	2	_rooked
scooped	12	46	1174	2	scooped
scooted	10	36	1227	2	scooted
shocked	17	46	1180	2	shocked
shooed	10	39	1607	2	shoo_ed
shooled	11	52	1265	2	shooled
smocked	16	39	822	2	smocked
smoked	13	43	1172	2	s_moked
snooded	9	41	1036	2	snooded
snooker	11	39	1030	2	snooker
snooled	8	45	1393	2	snooled
snooped	10	37	1181	2	snooped
snooted	8	42	1327	2	snooted
snoozed	17	34	1012	2	snoozed
soaked	11	47	1759	2	s_oaked
socked	13	47	2150	2	s_ocked
sooted	7	39	2258	2	s_ooted
spoked	13	44	1389	2	s_poked
spoofed	13	39	910	2	spoofed
spooled	10	46	1352	2	spooled
spooned	10	34	1244	2	spooned
spoored	10	44	1129	2	spoored
stacked	14	34	1612	2	stacked
staked	11	46	2194	2	st_aked
stalked	12	38	1117	2	stalked
steeked	12	40	1047	2	steeked
sticked	14	41	1463	2	sticked
stobbed	12	28	749	2	stobbed
stocker	13	37	1308	2	stocker
stodged	10	37	798	2	stodged
stoke	9	49	2251	2	st_oke_
stoker	10	44	1762	2	st_oker
stokes	10	48	2179	2	st_okes
stoled	7	45	2159	2	st_oled
stomped	12	41	1053	2	stomped
stoned	7	59	2314	2	st_oned
stood	6	55	1771	2	stoo__d
stooge	7	38	1166	2	stooge_
stooges	8	36	1148	2	stooges
stook	9	52	1821	2	stook__
stookers	12	44	979	2	stookers
stooks	10	51	1537	2	stook_s
stooper	9	38	1318	2	stooper
stoped	9	47	2101	2	st_oped
stopped	12	45	1220	2	stopped
stored	7	55	2421	2	st_ored
storied	8	5	1516	2	storied
stormed	10	3	904	2	stormed
stotted	8	35	1141	2	stotted
stowed	10	58	1720	2	st_owed
straked	12	54	1534	2	straked
stroke	10	51	1617	2	stroke_
stroker	11	41	1351	2	stroker
strokes	11	43	1632	2	strokes
strowed	11	53	1214	2	strowed
stroyed	11	41	1086	2	stroyed
swooned	11	36	859	2	swooned
swooped	13	41	875	2	swooped
toked	10	56	2649	2	_t_oked
tooled	7	49	1890	2	_tooled
tooted	7	46	2012	2	_tooted
troked	11	41	1458	2	_troked

Search took 4 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	78	3.156	34116.3
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	3.326	53725.5