Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

282 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
scroops1128825(None) 
scoops105414361sc_oops
scroop10299781scroop_
coops96229642_c_oops
crooks124914412_crooks
croons85418422_croons
crops96125242_cr_ops
croups104312552_croups
droops95110962_droops
saloops93510132saloops
schools1249112schools
scoop95617162sc_oop_
scoots85315942sc_oots
scops95820192sc__ops
scraps106017242scr_aps
scrimps13517902scrimps
scrips105316032scr_ips
scrods94111612scr_ods
scrolls938062scrolls
scrooch1444962scrooch
scrooge1037182scrooge
scrooges1137162scrooges
scrooped1356412scrooped
sloops85513622s_loops
snoops84314172s_noops
stoops85917892s_toops
strops86220382str_ops
swoops114910922s_woops
troops85712782_troops
across8312643acr_oss
apropos1138843apropos
barhops14288113barhops
bloops106611343_bloops
broods95416383_broods
brooks125813883_brooks
brooms104915873_brooms
broos75126413_broo_s
carhops14329703carhops
chomps155112223_chomps
chooks155312793_chooks
chops125019873_c_hops
clomps125212233_clomps
cloots85113693_cloots
clops95924853_c_lops
comps115526053_c_omps
coofs105924713_c_oofs
cooks115429143_c_ooks
cools75632633_c_ools
coons76737283_c_oons
coop87238653_c_oop_
coopt95929853_c_oopt
coopts105814583_c_oopts
coos67456493_c_oo_s
coots75636843_c_oots
cops86751373_c__ops
corps95927043_c_orps
coups95522473_c_oups
cramps125615563_cramps
craps95328643_cr_aps
creeps104213623_creeps
crimps124613453_crimps
crisps104411513_crisps
croaks125812983_croaks
crocks145118423_crocks
crocs95722433_cr_ocs
crocus104813173_crocus
crofts114910593_crofts
crones84729243_crones
crook115217573_croo_k
croon75522783_croo_n
crop87628633_cr_op_
crores86121163_crores
cross75124503_cr_oss
crotons93714373_crotons
croup95616783_croup_
croupe105114433_croupe
croupes114613103_croupes
croupy13458733_croupy
crowds124910763_crowds
crowns115615113_crowns
crows105727313_cr_ows
crozes174417663_crozes
crumps124514343_crumps
cruors838643_cruors
drools74412813_drools
droop85814823_droop_
droopy12458243_droopy
drops85719503_dr_ops
enroots738713enroots
escalops1244673escalops
escrows1235803escr_ows
goops86620963__goops
grooms94512523_grooms
groups94210513_groups
hoops105621073__hoops
karoos102415813karoo_s
kroons103711243_kroons
loops75723963__loops
maroons92615553maroons
oops65232673___oops
orlops847303_orlops
poops94422413__poops
preops104911943_preops
proofs114511683_proofs
props95726883_pr_ops
reroofs1037943reroofs
romps94617543__romps
roods65125283__roods
roofs85321153__roofs
rooks95325043__rooks
rooms75324683__rooms
roots55933673__roots
roups75118903__roups
saloons74415323saloons
saloop84212583saloop_
sannops936693sannops
sarcous9312933sarcous
sargos74318273sargo_s
sarodes84216143sarodes
sarods74918573sar_ods
sarongs84511803sarongs
saros55238063sar_o_s
saroses73619333saroses
sartors7314973sartors
scallops12297393scallops
scalps104315233sc_alps
scamps125014173sc_amps
scarious10610203scarious
scarps104718603sc_arps
scaups105411933sc_aups
schleps1445483schleps
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153schmo_s
schnaps1443703schnaps
schnooks1754243schnooks
school11410723schoo_l
schorls1248353schorls
schrods1337433schrods
scions82612243sc_ions
scoffs14347503sc_offs
scolds95011233sc_olds
scollops12235703scollops
scones84521303sc_ones
scooch13228123sc_ooch
scooped124611753sc_ooped
scooper113812033sc_ooper
scoopers124210193sc_oopers
scoot75729153sc_oo_t
scop85925523sc__op_
scope94821483sc__ope
scopes104719593sc_opes
scorers94115323scorers
scores84725923sc_ores
scorns85713023sc_orns
scots74025913sc__ots
scours84913593sc_ours
scouts84817943sc_outs
scowls11549593sc_owls
scows106617803sc__ows
scrags95713803scr_ags
scrams105216623scr_ams
scrap97120403scr_ap_
scrape105917573scr_ape
scrapes116217663scrapes
scrappy16234473scrappy
scrawls12177283scrawls
screaks13469363screaks
screams114810623screams
screeds106210293screeds
screens95212183screens
screes85023973scr_ees
screws115513893scr_ews
screwups1542293screwups
scribes113713203scribes
scries85226823scr_ies
scrimp125110583scrimp_
scrimpy16486133scrimpy
scrims104615933scr_ims
scrip96619193scr_ip_
script105717903scr_ipt
scripts11509373scripts
scrives124414273scrives
scrod85115073scr_o_d
scroggy14243843scroggy
scroll8310173scr_oll
scrooches1645703scrooches
scrooping1446593scrooping
scrootch1542813scrootch
scrota8310203scr_ota
scrotal938493scrotal
scrotum1145133scrotum
scrotums1243983scrotums
scrouge1036353scrouge
scrouges1136683scrouges
scrubs104210313scr_ubs
scruffs1554173scruffs
scrums104614253scr_ums
sculps104611753sc_ulps
scups95316653sc__ups
serious73616283serious
sermons9311783sermons
serosas7312663serosas
serous65023563ser_ous
serows96016393ser_ows
servos93812723servo_s
sheroots1137863sheroots
shnooks1485583shnooks
shooks134515633s_hooks
shools94919013s_hools
shoos84226363s_hoo_s
shoots94619363s_hoots
shops104222903s__hops
shrimps14516753shrimps
shroffs1634363shroffs
shrouds1136023shrouds
sickrooms1743433sickrooms
simooms1135573simooms
simoons937943simoons
sirups83710533sir_ups
sloop76118913s_loop_
slops75026013s__lops
snoods74312453s_noods
snooks104412833s_nooks
snools65715883s_nools
snoop75317173s_noop_
snoopy11449473s_noopy
snoots64216683s_noots
soaps75120713s__oaps
sooks94425453s__ooks
soots55536213s__oots
sops65244563s___ops
sordors8310013sordors
sorgos74514663sorgo_s
soroses73117493soroses
sorosis72611973sorosis
sorrows10278403sorrows
soups75322943s__oups
soursops1043213soursops
spoofs114011813s_poofs
spooks124312933s_pooks
spools85115913s_pools
spoons84116023s_poons
spoors84014033s_poors
sprouts949983sprouts
stomps105612833s_tomps
stooks105115373s_tooks
stools65117023s_tools
stoop75821543s_toop_
stops74827283s__tops
stoups85313273s_toups
stowps115710583s_towps
straps87721783str_aps
streps86218063str_eps
strips85719653str_ips
strobes93813263strobes
strokes114316323strokes
strolls739183strolls
strook10410303stroo_k
strop77422243str_op_
stroppy14205093stroppy
strouds837803strouds
strows96718273str_ows
stroys95914603str_oys
sucroses1039943sucroses
sunroofs1144763sunroofs
sunrooms1045723sunrooms
swoons94511143s_woons
swoop105213433s_woop_
swoopy14487283s_woopy
swops105913973s__wops
syrups11277953syr_ups
sysops1136013s_ysops
tromps104911703_tromps
troop76417533_troop_
unroofs1035783unroofs
unroots738563unroots
uproots937143uproots
varooms1248883varooms
vrooms11398713_vrooms
whoops14487863_whoops
woops104917523__woops

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340272826.08022043.9
3Display Results2822820.0933032.3
 (SQL Overall)1786912826.57927160.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.