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

358 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
scepters123778(None) 
scepter1138351scepter_
sceptres1244991sceptres
accepters15114602accepters
centers94420602_centers
copters113621282_copters
scatters103612752scatters
sceptered1444722sceptered
sceptics1455662sceptics
sceptre1135042scept_re
sceptred1343652sceptred
scooters103511032scooters
scoters93313812sc_oters
scouters103411322scouters
scripters13116672scripters
scuppers1446542scuppers
scutters103311022scutters
seaters74028942s_eaters
septets998952s_eptets
setters73822062s_etters
sheeters113111862sheeters
shelters113412812shelters
skeeters12298962skeeters
skelters12349372skelters
smelters103310512smelters
specters122811062specters
spelters103912242spelters
steppers12289282steppers
sumpters1238022sumpters
sweaters113811062sweaters
swelters113110192swelters
abetters1057173abetters
acceptees15113693acceptees
accepter14144933accepter_
acceptors15114783acceptors
adapters1136103adapters
adepter1036113adepter_
adopters1136693adopters
ascenders1235683ascenders
assenters966993assenters
asserters956393asserters
averters11249513averters
beaters94925043_beaters
beepers113612383beep_ers
belters93819413_belters
betters94422093_betters
bleaters103412323bleaters
canters94827733_canters
capers105428143_cap_ers
cappers134419403_cappers
captors113914983_captors
carters95327253_carters
casters94729903_casters
caters85336503_c_aters
ceders93817673_ce_ders
ceilers93912533_ceilers
censers94313903_censers
center84421413_center_
centners1057243_centners
centres93817123_centres
cepes94424463_cep_e_s
certes84623083_certe_s
cetes75731103_ce_te_s
chapters154012133chapters
cheaters133613513cheaters
ciphers14379993_ciphers
citers85022983_c_iters
coaters93525793_coaters
colters93522443_colters
cooters94525723_cooters
copers104629843_cop_ers
copiers114215963_copiers
coppers133519753_coppers
copter109822013_copter_
costers94128333_costers
cotters94323443_cotters
couters93827303_couters
craters95021893_craters
cuppers133712213_cuppers
cutters94218963_cutters
cyphers17316753_cyphers
decenters122410373decenters
deters74724683_de_ters
diesters92513603diesters
dieters83216433die_ters
diopters1137693diopters
eaters65535953__eaters
enters64425643__enters
erecters102611613erecters
escapers12337413escap_ers
esters64627733__esters
excerpters2143183excerpters
festers104121393_festers
fetters103517903_fetters
fretters113410303fretters
getters84216103_getters
greeters92610113greeters
heaters104225223_heaters
hefters134312003_hefters
incenters112510303incenters
inceptors1345773inceptors
jeepers16399193jeep_ers
jesters144118193_jesters
keepers133410983keep_ers
keesters12319593keesters
kelters113813753_kelters
kiesters123310153kiesters
lepers84817323_lep_ers
letters73819853_letters
meeters94714543_meeters
melters93918313_melters
meters85625833_me_ters
nesters74422793_nesters
netters73618583_netters
neuters74212273_neuters
peepers113713673peep_ers
pelters93720313_pelters
peppers103311443_peppers
pesters93827093_pesters
peters86624593_pe_ters
petters93722363_petters
pewters124113353_pewters
pleaters103613793pleaters
presters103419003presters
questers17168763questers
receptors1356923receptors
reciters102613113reciters
reenters82915303reenters
renters74224813_renters
resters74130403_resters
salters73622253s_alters
saluters8319863saluters
samplers12299403samplers
sappers113518903s_appers
saunters82911753saunters
scalers93817263sc_alers
scalpers123710863scalpers
scammers14339773scammers
scampers143611033scampers
scamsters1334993scamsters
scanners10379703scanners
scanter94215183scanter_
scapes105122263scap_e_s
scarers94618503sc_arers
scarfers13408463scarfers
scarpers124712513scarpers
scatter93815173scatter_
scaupers12378173scaupers
scenery1236553sce_nery
scenes84520353sce_ne_s
scented102811883scente_d
scentless1135113scentless
scents85317023scent__s
sceptering1545793sceptering
sceptic1337833scept_ic
sceptral1244513sceptral
schemers1576703schemers
schmeers1574833schmeers
scimiters1345123scimiters
scoffers16286133scoffers
scolders11288993scolders
scoopers124210193scoopers
scooter93312873scooter_
scopes104719593scop_e_s
scorers94115313sc_orers
scorners10228493scorners
scoter83815483sc_oter_
scourers10348533scourers
scouter93313323scouter_
scouthers1445993scouthers
scowders14276223scowders
scowlers13257363scowlers
scrapers125510523scrapers
scrappers1545853scrappers
screamers13236253screamers
screeners1136723screeners
screwers13358053screwers
scribers12307953scribers
scripter12137773scripter_
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510483scullers
sculptors1343993sculptors
scummers14277783scummers
scunners10357303scunners
scupper1367423scupper_
scutes85219193sc_ute_s
scutter93512173scutter_
sealers74323553s_ealers
seamers94719433s_eamers
seater64534153s_eater_
secateurs1142723secateurs
seceders11277963seceders
secpars1138413secp_ars
sectors93116443s_ectors
securers1057153securers
seders74420283s_e_ders
seeders83017113s_eeders
seekers113712333s_eekers
seemers93814333s_eemers
seepier92912013seepier_
seers55136383s_e__ers
seiners74219273s_einers
seisers73816393s_eisers
seizers164112503s_eizers
sellers73721313s_ellers
seltzers1735063s_eltzers
semesters1139123semesters
senders83022353s_enders
sepses84515883s_epse_s
septet8921133s_epte_t
septics112810433s_eptics
septs75420603s_ept__s
septums1135743s_eptums
sergers83815633s_ergers
servers103214833s_ervers
sestets7911473s_estets
settees73513633s_ettees
setter64023723s_etter_
settlers8289023s_ettlers
severs94121123s_e_vers
sewers94719713s_e_wers
sextets1497143s_extets
shapers124016893shap_ers
shatters113313913shatters
shearers113911323shearers
sheathers1557553sheathers
shedders13267433shedders
sheers94322403she__ers
sheeter103814913sheeter_
shellers112812573shellers
shelter103214963shelter_
shelvers14388813shelvers
shepherd1744373shepherd
shepherds1843223shepherds
shewers134312043she_wers
shifters14319863shifters
shippers153012313shippers
shooters112811583shooters
shoppers153010763shoppers
shouters113510623shouters
shunters113210753shunters
shutters113611353shutters
shysters14106463shysters
sifters103714793s_ifters
sighters122510603sighters
simpers113014123simp_ers
sinters74024083s_inters
sippers113117753s_ippers
sisters73721593s_isters
sitters74221553s_itters
skaters113512963s_katers
skeeter113410413skeeter_
skelter113610003skelter_
skeptics1653863skeptics
skewers14498373ske_wers
skippers16318203skippers
skirters12337243skirters
skitters12349553skitters
slappers123710943slappers
slaters73123733s_laters
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
slippers123711233slippers
slitters84014133slitters
slopers94213093slop_ers
slotters84012403slotters
smatters104011713smatters
smearers10308623smearers
smellers10329763smellers
smelter93311913smelter_
smeltery13274963smeltery
smiters93414363s_miters
snappers123510173snappers
sneakers12308643sneakers
sneerers8309803sneerers
sneers64016173sne__ers
sneezers17246143sneezers
snifters11318613snifters
snipers93311773snip_ers
snippers12299723snippers
snorters83410583snorters
soapers93715923soap_ers
sorters74221133s_orters
souters74422603s_outers
spatters103914703spatters
speakers14299453speakers
spearers103711143spearers
specter113111733specter_
spectres12268683spectres
speeders11339313speeders
speers85019953s__peers
spellers102812753spellers
spelter94113703spelter_
spencers12269193spencers
spenders113211743spenders
spewers124210653spe_wers
spiers84421743s__piers
spitters104113383spitters
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
spurters103311703spurters
sputters104012873sputters
staplers103111203staplers
starters83714773starters
staters73922343s_taters
stealers83412203stealers
steamers103410873steamers
steepers103011373steepers
steerers82511353steerers
steers63820983ste__ers
stemmers12378443stemmers
stentors839733stentors
stepper113010853stepper_
steppes113110693steppe_s
stertors8310923stertors
stinters83312753stinters
stopers94217373stop_ers
stoppers123910593stoppers
stutters83210473stutters
subcenters1446163subcenters
suiters73618883s_uiters
sumpter1138873sumpter_
supers84622403s_up_ers
suppers113314703s_uppers
svelter10359673svelter_
swappers15358083swappers
swatters113911793swatters
swearers11328583swearers
sweater103712723sweater_
sweepers13348163sweepers
sweetens11255433sweetens
sweeter103212003sweeter_
swelter103711173swelter_
swervers1455213swervers
swifters14277483swifters
swotters11448483swotters
syphers15317273s_yphers
teeters74018303_teeters
tempters12257293tempters
tenters73921103_tenters
testers74124543_testers
tetters74320473_tetters
theaters114211903theaters
treaters83615843treaters
tweeters11287143tweeters
ureters7311823ure_ters
venters103717733_venters
vetters104016323_vetters
weepers123511973weep_ers
welters103516063_welters
westers105221963_westers
wetters103817753_wetters
whetters14246653whetters
wresters112711733wresters
zesters163517293_zesters

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.1561145455.1
2DLD Change Limit1461623587.61019206.6
3Display Results3583580.1402557.1
 (SQL Overall)1786913587.90622601.9
 
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.