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

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

104 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
scoops	10	54	1436	(None)
coops	9	62	2964	1	_coops
scoop	9	56	1716	1	scoop_
scoots	8	53	1594	1	scoots
scops	9	58	2019	1	sc_ops
scroops	11	28	825	1	scroops
sloops	8	55	1362	1	sloops
snoops	8	43	1417	1	snoops
stoops	8	59	1789	1	stoops
swoops	11	49	1092	1	swoops
bloops	10	66	1134	2	bloops
chops	12	50	1987	2	_chops
clops	9	59	2485	2	_clops
comps	11	55	2605	2	_comps
coofs	10	59	2471	2	_coofs
cooks	11	54	2914	2	_cooks
cools	7	56	3263	2	_cools
coons	7	67	3728	2	_coons
coop	8	72	3865	2	_coop_
coopt	9	59	2985	2	_coopt
coopts	10	58	1458	2	_coopts
coos	6	74	5649	2	_coo_s
coots	7	56	3684	2	_coots
cops	8	67	5137	2	_c_ops
corps	9	59	2704	2	_corps
coups	9	55	2247	2	_coups
crops	9	61	2523	2	_crops
droops	9	51	1096	2	droops
goops	8	66	2096	2	_goops
hoops	10	56	2107	2	_hoops
loops	7	57	2396	2	_loops
oops	6	52	3267	2	__oops
poops	9	44	2241	2	_poops
saloops	9	35	1013	2	saloops
scalps	10	43	1523	2	scalps
scamps	12	50	1417	2	scamps
scarps	10	47	1860	2	scarps
scaups	10	54	1193	2	scaups
schools	12	4	911	2	schools
scions	8	26	1224	2	scions
scoffs	14	34	750	2	scoffs
scolds	9	50	1123	2	scolds
scollops	12	23	570	2	scollops
scones	8	45	2130	2	scones
scooch	13	22	812	2	scooch
scooped	12	46	1174	2	scooped
scooper	11	38	1203	2	scooper
scoopers	12	42	1019	2	scoopers
scoot	7	57	2915	2	scoo_t
scop	8	59	2552	2	sc_op_
scope	9	48	2148	2	sc_ope
scopes	10	47	1959	2	scopes
scores	8	47	2592	2	scores
scorns	8	57	1302	2	scorns
scots	7	40	2591	2	sc_ots
scours	8	49	1359	2	scours
scouts	8	48	1794	2	scouts
scowls	11	54	959	2	scowls
scows	10	66	1780	2	sc_ows
scraps	10	60	1724	2	scraps
scrips	10	53	1603	2	scrips
scrods	9	41	1161	2	scrods
scroop	10	29	978	2	scroop_
sculps	10	46	1175	2	sculps
scups	9	53	1665	2	sc_ups
shooks	13	45	1563	2	shooks
shools	9	49	1901	2	shools
shoos	8	42	2636	2	shoo_s
shoots	9	46	1936	2	shoots
shops	10	42	2290	2	s_hops
sloop	7	61	1891	2	sloop_
slops	7	50	2601	2	s_lops
snoods	7	43	1245	2	snoods
snooks	10	44	1283	2	snooks
snools	6	57	1588	2	snools
snoop	7	53	1717	2	snoop_
snoopy	11	44	947	2	snoopy
snoots	6	42	1668	2	snoots
soaps	7	51	2071	2	s_oaps
sooks	9	44	2545	2	s_ooks
soots	5	55	3621	2	s_oots
sops	6	52	4456	2	s__ops
soups	7	53	2294	2	s_oups
spoofs	11	40	1181	2	spoofs
spooks	12	43	1293	2	spooks
spools	8	51	1591	2	spools
spoons	8	41	1602	2	spoons
spoors	8	40	1403	2	spoors
stomps	10	56	1283	2	stomps
stooks	10	51	1537	2	stooks
stools	6	51	1702	2	stools
stoop	7	58	2154	2	stoop_
stops	7	48	2728	2	s_tops
stoups	8	53	1327	2	stoups
stowps	11	57	1058	2	stowps
strops	8	62	2038	2	strops
swoons	9	45	1114	2	swoons
swoop	10	52	1343	2	swoop_
swoopy	14	48	728	2	swoopy
swops	10	59	1397	2	s_wops
sysops	11	3	601	2	sysops
troops	8	57	1278	2	troops
whoops	14	48	786	2	whoops
woops	10	49	1752	2	_woops

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.360	496363.9
2	DLD Change Limit	82551	104	2.593	31836.1
3	Display Results	104	104	0.030	3466.7
	(SQL Overall)	178691	104	2.983	59903.1