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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

312 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
scroop	10	29	978	(None)
scoop	9	56	1716	1	sc_oop
scroops	11	28	825	1	scroops
coop	8	72	3865	2	_c_oop
crook	11	52	1757	2	_crook
croon	7	55	2278	2	_croon
crop	8	76	2863	2	_cr_op
croup	9	56	1678	2	_croup
droop	8	58	1482	2	_droop
saloop	8	42	1258	2	saloop
school	11	4	1072	2	school
scoops	10	54	1436	2	sc_oops
scoot	7	57	2915	2	sc_oot
scop	8	59	2552	2	sc__op
scrap	9	71	2040	2	scr_ap
scrimp	12	51	1058	2	scrimp
scrip	9	66	1919	2	scr_ip
scrod	8	51	1507	2	scr_od
scrods	9	41	1161	2	scrods
scroll	8	3	1017	2	scroll
scrooch	14	4	496	2	scrooch
scrooge	10	3	718	2	scrooge
scrooped	13	5	640	2	scrooped
scrota	8	3	1020	2	scrota
sloop	7	61	1891	2	s_loop
snoop	7	53	1717	2	s_noop
stoop	7	58	2154	2	s_toop
strook	10	4	1030	2	strook
strop	7	74	2224	2	str_op
swoop	10	52	1343	2	s_woop
troop	7	64	1753	2	_troop
achoo	10	3	1508	3	achoo_
across	8	3	1264	3	across
barhop	13	31	964	3	barhop
bloop	9	61	1615	3	_bloop
broo	6	51	2982	3	_broo_
brood	8	46	2024	3	_brood
brook	11	47	1776	3	_brook
broom	9	50	2221	3	_broom
broos	7	51	2641	3	_broos
carhop	13	36	1076	3	carhop
cartop	10	42	1356	3	cartop
chomp	14	48	1566	3	_chomp
chook	14	60	1504	3	_chook
chop	11	60	2492	3	_c_hop
clomp	11	56	1570	3	_clomp
cloot	7	61	2705	3	_cloot
clop	8	69	2989	3	_c_lop
comp	10	67	3125	3	_c_omp
coo	5	95	6636	3	_c_oo_
coof	9	66	4327	3	_c_oof
cook	10	72	3693	3	_c_ook
cool	6	69	4049	3	_c_ool
coon	6	72	4894	3	_c_oon
coops	9	62	2964	3	_c_oops
coopt	9	59	2985	3	_c_oopt
coos	6	74	5649	3	_c_oos
coot	6	78	6038	3	_c_oot
cop	7	111	6237	3	_c__op
coup	8	67	2979	3	_c_oup
cramp	11	51	2069	3	_cramp
crap	8	57	3184	3	_cr_ap
creep	9	52	1810	3	_creep
crimp	11	56	1580	3	_crimp
crisp	9	50	1462	3	_crisp
croak	11	52	1663	3	_croak
croc	8	57	2373	3	_cr_oc
croci	9	58	1813	3	_croci
crock	13	59	2199	3	_crock
crocs	9	57	2243	3	_crocs
croft	10	56	2268	3	_croft
crone	7	52	3133	3	_crone
crony	10	59	1867	3	_crony
crooks	12	49	1441	3	_crooks
croons	8	54	1842	3	_croons
crops	9	61	2523	3	_crops
crore	7	49	2287	3	_crore
cross	7	51	2450	3	_cross
croton	8	44	1545	3	_croton
croupe	10	51	1443	3	_croupe
croups	10	43	1255	3	_croups
croupy	13	45	873	3	_croupy
crow	9	64	2813	3	_cr_ow
crowd	11	58	1562	3	_crowd
crown	10	56	2008	3	_crown
crows	10	57	2731	3	_crows
croze	16	47	1945	3	_croze
crump	11	56	1642	3	_crump
cruor	7	3	1045	3	_cruor
drool	6	54	1610	3	_drool
droops	9	51	1096	3	_droops
droopy	12	45	824	3	_droopy
drop	7	53	2440	3	_dr_op
enroot	6	6	1599	3	enroot
escalop	11	4	478	3	escalop
escrow	11	3	591	3	escr_ow
escrows	12	3	580	3	escrows
goop	7	58	2948	3	__goop
groom	8	53	1798	3	_groom
group	8	54	1392	3	_group
hoop	9	61	2998	3	__hoop
karoo	9	25	1958	3	karoo_
karoos	10	24	1580	3	karoos
kroon	9	45	1448	3	_kroon
loop	6	78	3501	3	__loop
maroon	8	31	1820	3	maroon
orlop	7	4	1090	3	_orlop
poop	8	65	3281	3	__poop
preop	9	47	1587	3	_preop
proof	10	52	2153	3	_proof
prop	8	59	3281	3	_pr_op
reroof	9	3	1500	3	reroof
romp	8	59	2657	3	__romp
rood	5	67	3300	3	__rood
roof	7	57	3883	3	__roof
rook	8	55	3203	3	__rook
room	6	62	3508	3	__room
root	4	56	5592	3	__root
roup	6	66	2769	3	__roup
saloon	6	44	1802	3	saloon
saloops	9	35	1013	3	saloops
sannop	8	3	737	3	sannop
sargo	6	54	2441	3	sargo_
sargos	7	43	1827	3	sargos
sarod	6	53	2587	3	sar_od
sarode	7	53	1751	3	sarode
sarods	7	49	1857	3	sarods
sarong	7	39	1487	3	sarong
saros	5	52	3806	3	sar_os
sartor	6	3	1388	3	sartor
scallop	11	23	764	3	scallop
scalp	9	52	1798	3	sc_alp
scamp	11	57	1731	3	sc_amp
scarp	9	57	2410	3	sc_arp
scaup	9	55	1599	3	sc_aup
schlep	13	4	709	3	schlep
schmo	12	45	1020	3	schmo_
schmoe	13	32	833	3	schmoe
schmoos	14	34	751	3	schmoos
schmos	13	37	915	3	schmos
schnook	16	5	448	3	schnook
schnoz	20	3	565	3	schnoz
schools	12	4	911	3	schools
schorl	11	7	981	3	schorl
schrod	12	4	788	3	schrod
schrods	13	3	743	3	schrods
scion	7	22	1499	3	sc_ion
scions	8	26	1224	3	scions
scoff	13	44	1334	3	sc_off
scold	8	54	1486	3	sc_old
scollop	11	27	543	3	scollop
scone	7	46	2183	3	sc_one
scooch	13	22	812	3	scooch
scooped	12	46	1174	3	sc_ooped
scooper	11	38	1203	3	sc_ooper
scoots	8	53	1594	3	scoots
scope	9	48	2148	3	sc_ope
scops	9	58	2019	3	sc_ops
scorch	13	19	809	3	scorch
score	7	55	2674	3	sc_ore
scored	9	46	2113	3	scored
scorer	8	48	1826	3	scorer
scores	8	47	2592	3	scores
scoria	8	5	1350	3	scoria
scorn	7	58	1745	3	sc_orn
scorns	8	57	1302	3	scorns
scot	6	62	4261	3	sc__ot
scots	7	40	2591	3	sc_ots
scour	7	53	1553	3	sc_our
scout	7	50	3145	3	sc_out
scow	9	60	2142	3	sc__ow
scowl	10	120	1297	3	sc_owl
scows	10	66	1780	3	sc_ows
scrag	8	59	1617	3	scr_ag
scrags	9	57	1380	3	scrags
scram	9	106	2162	3	scr_am
scrams	10	52	1662	3	scrams
scrape	10	59	1757	3	scrape
scrappy	16	23	447	3	scrappy
scraps	10	60	1724	3	scraps
scrawl	11	20	809	3	scrawl
screak	12	53	1106	3	screak
scream	10	48	1425	3	scream
scree	7	200	3171	3	scr_ee
screed	9	57	1893	3	screed
screen	8	52	1602	3	screen
screes	8	50	2397	3	screes
screw	10	93	1854	3	scr_ew
screws	11	55	1389	3	screws
screwup	14	4	297	3	screwup
screwy	14	65	946	3	screwy
scribe	10	46	1353	3	scribe
scried	9	58	1730	3	scried
scries	8	52	2682	3	scries
scrim	9	54	1974	3	scr_im
scrimps	13	51	790	3	scrimps
scrimpy	16	48	613	3	scrimpy
scrims	10	46	1593	3	scrims
scrips	10	53	1603	3	scrips
script	10	57	1790	3	script
scrive	11	54	1494	3	scrive
scroggy	14	24	384	3	scroggy
scrolls	9	3	806	3	scrolls
scrooges	11	3	716	3	scrooges
scrooping	14	4	659	3	scroop~~ing~~
scrootch	15	4	281	3	scrootch
scrotal	9	3	849	3	scrotal
scrotum	11	4	513	3	scrotum
scrouge	10	3	635	3	scrouge
scrub	9	49	1420	3	scr_ub
scrubs	10	42	1031	3	scrubs
scruff	14	3	796	3	scruff
scrum	9	54	1820	3	scr_um
scrums	10	46	1425	3	scrums
scry	9	60	1776	3	scr__y
scudo	8	54	1221	3	scudo_
sculp	9	53	1484	3	sc_ulp
scup	8	48	2238	3	sc__up
sermon	8	4	1355	3	sermon
serosa	6	3	1302	3	serosa
serous	6	50	2356	3	serous
serow	8	67	2044	3	ser_ow
serows	9	60	1639	3	serows
servo	8	45	1668	3	servo_
servos	9	38	1272	3	servos
sheroot	10	4	1437	3	sheroot
shnook	13	6	634	3	shnook
shoo	7	59	2989	3	s_hoo_
shook	12	49	2016	3	s_hook
shool	8	45	2315	3	s_hool
shoon	8	40	2201	3	s_hoon
shoos	8	42	2636	3	s_hoos
shoot	8	42	3591	3	s_hoot
shop	9	56	2984	3	s__hop
shrimp	13	47	877	3	shrimp
shroff	15	3	850	3	shroff
shroud	10	3	877	3	shroud
shrove	12	54	1223	3	shrove
sickroom	16	4	394	3	sickroom
simoom	10	3	750	3	simoom
simoon	8	5	806	3	simoon
sirup	7	40	1491	3	sir_up
sloops	8	55	1362	3	s_loops
slop	6	65	3387	3	s__lop
snood	6	46	1616	3	s_nood
snook	9	51	1557	3	s_nook
snool	5	51	1864	3	s_nool
snoops	8	43	1417	3	s_noops
snoopy	11	44	947	3	s_noopy
snoot	5	50	3014	3	s_noot
soap	6	58	3113	3	s__oap
sook	8	49	3339	3	s__ook
soon	4	62	4050	3	s__oon
soot	4	57	6106	3	s__oot
sop	5	75	5786	3	s___op
sordor	7	3	1022	3	sordor
sorgo	6	47	1972	3	sorgo_
sorgos	7	45	1466	3	sorgos
sorrow	9	33	944	3	sorrow
soup	6	62	3291	3	s__oup
soursop	9	4	303	3	soursop
spoof	10	50	1901	3	s_poof
spook	11	54	1604	3	s_pook
spool	7	52	1904	3	s_pool
spoon	7	47	1944	3	s_poon
spoor	7	50	1635	3	s_poor
sprout	8	4	1940	3	sprout
stomp	9	56	1666	3	s_tomp
stood	6	55	1771	3	s_tood
stook	9	52	1821	3	s_took
stool	5	56	1989	3	s_tool
stoops	8	59	1789	3	s_toops
stop	6	65	3203	3	s__top
stoup	7	55	1707	3	s_toup
stowp	10	56	1423	3	s_towp
strap	7	79	2526	3	str_ap
strep	7	71	2085	3	str_ep
strip	7	75	2434	3	str_ip
strobe	8	45	1381	3	strobe
strode	7	52	1597	3	strode
stroke	10	51	1617	3	stroke
stroll	6	3	1160	3	stroll
stroma	8	43	1307	3	stroma
strong	7	49	1488	3	strong
stroppy	14	20	509	3	stroppy
strops	8	62	2038	3	strops
stroud	7	3	1038	3	stroud
strove	9	50	1479	3	strove
strow	8	89	2057	3	str_ow
strown	9	68	1209	3	strown
strows	9	67	1827	3	strows
stroy	8	77	2039	3	str_oy
stroys	9	59	1460	3	stroys
sucrose	9	3	930	3	sucrose
sunroof	10	4	705	3	sunroof
sunroom	9	4	701	3	sunroom
swoon	8	50	1478	3	s_woon
swoops	11	49	1092	3	s_woops
swoopy	14	48	728	3	s_woopy
swop	9	51	2050	3	s__wop
syrup	10	30	1096	3	syr_up
sysop	10	3	719	3	s_ysop
tromp	9	58	1580	3	_tromp
troops	8	57	1278	3	_troops
trooz	14	50	1615	3	_trooz
trop	6	68	3330	3	_tr_op
unroof	9	4	1019	3	unroof
unroot	6	3	1555	3	unroot
uproot	8	3	1412	3	uproot
varoom	11	4	1141	3	varoom
vroom	10	53	1247	3	_vroom
whoop	13	42	1144	3	_whoop

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	112716	0.423	422437.4
2	DLD Change Limit	112716	312	5.750	19602.8
3	Display Results	312	312	0.093	3354.8
	(SQL Overall)	178691	312	6.266	28517.6