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 “scourers” 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.

354 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
scourers1034853(None) 
scorers94115321sco_rers
scourer93910431scourer_
scourgers1234381scourgers
scouters103411321scouters
corers85231072_co_rers
couriers103213172_couriers
coursers104412302_coursers
courters103015372_courters
couters93827302_couters
curers84923192_c_urers
pourers93513672_pourers
savourers1243832savourers
scarers94618512sc_arers
scaupers12378172scaupers
scoffers16286132scoffers
scolders11288992scolders
scoopers124210192scoopers
scooters103511032scooters
scorer84818262sco_rer_
scores84725922sco_re_s
scorners10228492scorners
scoters93313812sco_ters
scoured103811152scoure_d
scourger1134722scourger_
scourges1136532scourges
scours84913592scou__rs
scouses93313242scouse_s
scouter93313322scouter_
scouthers1445992scouthers
scowders14276232scowders
scowlers13257372scowlers
securers1057152securers
shouters113510622shouters
snorers74313802sno_rers
soarers74118092s_oarers
sourer63620212s_ourer_
souters74422602s_outers
spouters104011162spouters
storers75018682sto_rers
stoures74614162stoure_s
tourers73512742_tourers
abjurers1733943abjurers
accouters1344863accouters
accusers12285903accusers
acquirers2043413acquirers
adjurers1634373adjurers
adorers84411733ado_rers
allurers8286773allurers
armourers1154063armourers
arousers84810983arousers
assurers866313assurers
augurers9114813augurers
borers85122683_bo_rers
carers85133963_c_arers
causers94014793_causers
chousers134610203chousers
churners13316893_churners
churrs115111513_chur_rs
clouters10399803clouters
coalers94419353_coalers
coaters93525793_coaters
coaxers164311083_coaxers
cobbers134114753_cobbers
cockers153618333_cockers
codders114114453_codders
coders95426983_co_ders
codgers115113933_codgers
coercers1237653_coercers
coffers154112693_coffers
coherers132310733_coherers
coilers93619903_coilers
coiners93620753_coiners
colorers10312183_colorers
colourers1136473colourers
colters93522443_colters
colures9315143_colure_s
combers134516623_combers
comers105328083_co_mers
confers124120093_confers
congers104223233_congers
conjurers18126233_conjurers
conkers133721043_conkers
conners94023113_conners
cooers84324563_co_oers
cookers134619463_cookers
coolers93522493_coolers
coopers114019483_coopers
cooters94525723_cooters
copers104629843_co_pers
copiers114215963_copiers
coppers133519753_coppers
copters113621283_copters
corders104520883_corders
corer75538873_co_rer_
cores76361853_co_re_s
corkers134118853_corkers
corners94723313_corners
corulers1039773_corulers
coshers123618183_coshers
costers94128333_costers
cotters94323443_cotters
couchers153513863_couchers
cougars1038443_cougars
coughers14399963_coughers
coulees9315513_coulees
coulters103614313_coulters
counters103320193_counters
coupes105022523_coupe_s
couplers123311323_couplers
courier93617893_courier_
courser94114803_courser_
courses94218893_courses
courter94516483_courter_
courtiers1146693_courtiers
courts84216173_cour_ts
couter84930223_couter_
coverers132712123_coverers
covers114627963_co_vers
cowers114625533_co_wers
cubers105318353_c_ubers
curbers115514383_c_urbers
curer75030753_c_urer_
cures75645433_c_ure_s
curets84922343_c_urets
curlers94218073_c_urlers
currs75624393_c_ur_rs
cursers94317163_c_ursers
devourers1344093devourers
discoursers1443593discoursers
dourer74215273_dourer_
dousers84817273_dousers
endurers9317953endurers
ensurers8279373ensurers
espousers1143383espousers
favourers1543123favourers
figurers12254873figurers
floorers11227573floorers
flouters11419273flouters
focusers13134373focusers
gougers94911763_gougers
groupers11358643groupers
grousers93810733grousers
grouters95910083grouters
honourers1245573honourers
housers104717813_housers
injurers15286123injurers
insurers83710133insurers
labourers1144713labourers
lecturers11124233lecturers
louvers10359103_louvers
lurers64217493__lurers
manurers1037593manurers
maturers1037373maturers
mourners1036913_mourners
mousers95216443_mousers
outers64230173__outers
pourer84516043_pourer_
pouters94221873_pouters
procurers1345033procurers
roarers73812743_roarers
rousers75220143_rousers
routers74822873_routers
saluters8319863saluters
saucers93712133s_aucers
saugers83914053s_augers
saurels749303s_aurels
savorers1157223savorers
savourer1134473savourer_
scalers93817263sc_alers
scalpers123710863scalpers
scammers14339773scammers
scampers143611033scampers
scanners10379703scanners
scarer84524613sc_arer_
scares85033003sc_are_s
scarfers13408463scarfers
scarpers124712513scarpers
scatters103612753scatters
scauper11379453scauper_
scaurs85512053scau__rs
scepters1237793scepters
schemers1576713schemers
schmeers1574833schmeers
schnorrers1542573schnorrers
schooners1445663schooners
schussers1442553schussers
sciurids1143343sciurids
scoffer15317023scoffer_
scolder103210343scolder_
sconces113811453sconce_s
scones84521303sco_ne_s
scooper113812033scooper_
scooter93312873scooter_
scopes104719593sco_pe_s
scorchers16145513scorchers
score75526743sco_re__
scored94621133sco_re_d
scorner9259763scorner_
scorns85713023sco_r_ns
scoter83815483sco_ter_
scoundrels1341503scoundrels
scour75315533scou__r_
scourge1035653scour_ge
scourged1234573scourged
scouring112810853scouring
scourings12235293scourings
scouse84113633scouse__
scouted104112033scoute_d
scouther1356943scouther_
scouths12527893scou_ths
scouts84817943scou__ts
scowder13286873scowder_
scowler12248193scowler_
scrapers125510533scrapers
screes85023973sc__rees
screwers13358063screwers
screws115513893sc__rews
scribers12307963scribers
scrouges1136683scrouge_s
scroungers1343183scroungers
scrubbers1543373scrubbers
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510483scullers
scummers14277783scummers
scunners10357303scunners
scuppers1446543scuppers
scurfs113210813sc_ur_fs
scurry11419593sc_ur_ry
scutes85219193sc_ute_s
scutters103311023scutters
seconders1236953seconders
securer958253securer_
secures9613163secure_s
seducers1145383seducers
sharers104720623s_harers
shearers113911323shearers
shnorrers1243533shnorrers
shockers17319463shockers
shoers94518333sho__ers
shooters112811583shooters
shoppers153010763shoppers
shores94830413sho_re_s
shoulders1334233shoulders
shouter103213083shouter_
shovers134613003sho_vers
showerers1545073showerers
showers134612683sho_wers
slobbers12398523slobbers
sloggers10418783sloggers
slopers94213093slo_pers
slotters84012403slotters
slouchers14185623slouchers
smearers10308623smearers
smokers13389323smo_kers
smolders11287193smolders
smothers13349933smothers
smoulders1243143smoulders
snarers74216663s_narers
sneerers8309803sneerers
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
snorer64316763sno_rer_
snores64324323sno_re_s
snorters83410583snorters
soakers114114953s_oakers
soapers93715923s_oapers
soarer64522243s_oarer_
sobbers114114263s_obbers
sobers85218863s_o_bers
socagers1196363socagers
soccers1138393s_occers
soirees72411643s_oirees
sojourners1761773sojourners
solders83517773s_olders
solvers104414253s_olvers
sonders83820713s_onders
sooners73916643s_ooners
soothers113913433soothers
sorels63921163s_o_rels
sorer56236593s_o_rer_
sores55454283s_o_re_s
sorners73416873s_orners
sorrels7310723s_orrels
sorters74221133s_orters
soucars938423s_oucars
sounders93214113s_ounders
sources9312173s_ources
soured74921863s_oure_d
sourest7515713s_ourest
sourness839543s_ourness
sours55230503s_ou__rs
souses64229243s_ouse_s
souter64225923s_outer_
southers114214453s_outhers
sowers94923443s_o_wers
sparers94519613s_parers
spearers103711143spearers
splurgers1253073splurgers
spoilers10238633spoilers
spongers1137603spongers
spoofers13307323spoofers
spoolers10349363spoolers
spores84726613spo_re_s
sporters103714063sporters
spotters104313383spotters
spouses92912813spouse_s
spouter94213223spouter_
spurners10288493s_purners
spurrers10338463spurrers
spurters103311703s_purters
squarers17338023squarers
starers74522313s_tarers
steerers82511353steerers
stirrers8266943stirrers
stockers143411073stockers
stokers114515183sto_kers
stompers123610043stompers
stoners74817953sto_ners
stookers12449793stookers
stoopers103711303stoopers
stopers94217373sto_pers
stoppers123910593stoppers
storer64721673sto_rer_
stores65533663sto_re_s
storeys10559653sto_reys
stoure64814943stoure__
stours65015633stou__rs
stoutens8255273stoutens
stouter74012053stouter_
stovers103713733sto_vers
subers85722643s__ubers
succorers13124203succorers
suers55128483s__u_ers
sugarers936303sugarers
supers84622403s__upers
surer54833103s__urer_
surfers103614133s__urfers
surgers83517483s__urgers
sutures7314223suture_s
swearers11328583swearers
swobbers15355593swobbers
swooners11336863swooners
swoopers13317523swoopers
swotters11448483swotters
tabourers1144673tabourers
tourer64115073_tourer_
touters74018353_touters
troupers10359443troupers
trousers83910633trousers
usurers766363_usurers
vapourers1443373vapourers

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461623547.36019859.0
3Display Results3543540.1402528.6
 (SQL Overall)1786913547.92322553.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.