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

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

80 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
scooped	12	46	1174	(None)
cooped	11	48	2160	1	_cooped
scooper	11	38	1203	1	scooper
scooted	10	36	1228	1	scooted
scoped	11	51	1665	1	sc_oped
scrooped	13	5	640	1	scrooped
snooped	10	37	1181	1	snooped
stooped	10	38	1383	1	stooped
swooped	13	41	875	1	swooped
blooped	12	39	854	2	blooped
comped	13	59	1987	2	_comped
cooed	8	45	3434	2	_coo_ed
cooeed	9	59	1786	2	_cooeed
cooked	13	59	2136	2	_cooked
cooled	9	52	2459	2	_cooled
cooper	10	42	2112	2	_cooper
coopted	12	37	1076	2	_coopted
coped	10	50	3684	2	_c_oped
copped	13	52	2125	2	_copped
couped	11	50	1931	2	_couped
drooped	11	36	843	2	drooped
hooped	12	55	1818	2	_hooped
looped	9	52	1717	2	_looped
pooped	11	39	1594	2	_pooped
scalped	12	44	1199	2	scalped
scamped	14	47	1196	2	scamped
scaped	11	55	1955	2	sc_aped
scarped	12	43	1440	2	scarped
schooled	14	4	705	2	schooled
scoffed	16	26	618	2	scoffed
scolded	11	35	886	2	scolded
scolloped	14	4	365	2	scolloped
sconced	12	35	917	2	sconced
scooched	16	20	668	2	scooched
scoop	9	56	1716	2	scoop__
scoopers	12	42	1019	2	scoopers
scoops	10	54	1436	2	scoop_s
scooter	9	33	1287	2	scooter
scope	9	48	2148	2	sc_ope_
scopes	10	47	1959	2	sc_opes
scored	9	46	2113	2	sc_ored
scorned	10	22	995	2	scorned
scoured	10	38	1115	2	scoured
scouted	10	41	1203	2	scouted
scowed	12	44	1383	2	sc_owed
scowled	13	39	819	2	scowled
scraped	12	43	1313	2	scraped
sculped	12	39	825	2	sculped
shooed	10	39	1608	2	shoo_ed
shooled	11	52	1266	2	shooled
shopped	15	35	1221	2	shopped
sloped	9	42	1685	2	s_loped
slopped	12	35	1144	2	slopped
snooded	9	41	1036	2	snooded
snooked	12	37	1149	2	snooked
snooled	8	45	1394	2	snooled
snooper	9	35	1153	2	snooper
snooted	8	42	1328	2	snooted
snoozed	17	34	1013	2	snoozed
soaped	9	58	1797	2	s_oaped
sooted	7	39	2259	2	s_ooted
sopped	11	48	1990	2	s_opped
souped	9	50	1767	2	s_ouped
spoofed	13	39	910	2	spoofed
spooked	14	45	1047	2	spooked
spooled	10	46	1352	2	spooled
spooned	10	34	1244	2	spooned
spoored	10	44	1129	2	spoored
stomped	12	41	1053	2	stomped
stooged	9	43	1073	2	stooged
stooked	12	43	1230	2	stooked
stooled	8	43	1389	2	stooled
stooper	9	38	1319	2	stooper
stoped	9	47	2101	2	s_toped
stopped	12	45	1220	2	stopped
swooned	11	36	859	2	swooned
swooper	12	38	917	2	swooper
swopped	15	43	767	2	swopped
trooped	10	40	1072	2	trooped
whooped	16	32	693	2	whooped

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.356	501941.0
2	DLD Change Limit	107671	80	2.876	37437.8
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.262	54779.6