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

164 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
spectres1226868(None) 
specters122811061specters
spectre11297771spectre_
sceptres1244992sceptres
secures9613162s_ecures
species11314132spec_ies
speckles16268132speckles
spectates13228812spectates
specter113111732spect_er
spectra11275832spectr_a
spectral12246192spectral
spectrum1444072spectrum
spectrums1543172spectrums
spelters103912242spelters
speltzes1944002speltzes
apertures1146473apertures
aspects1146743aspect__s
centres93817123_centres
decares102818533_decares
electees10238723electees
electress1146113electress
electret10411993electret
electrets1146543electrets
electros102811743electros
epicures1246513epicures
erecters102611613erecters
expecters2045473expecters
hectares1338853_hectares
lectures101310153_lectures
metres85121563_me_tres
peckers153312673_peckers
pectase112410363_pectase
pectases122411193_pectases
pectates122213953_pectates
pecten102711103_pect_en
pectens11189203_pectens
pectines121914683_pectines
pectins112315233_pectins
pectizes21229783_pectizes
pelters93720313_pelters
peltries10313023_peltries
peres76246643_pe__res
pesters93827093_pesters
pestles93217693_pestles
peters86624593_pe_ters
petrel83111533_pe_trel
petrels9279373_pe_trels
petters93722363_petters
pettles93916483_pettles
pewters124113353_pewters
peytrel1264253_peytrel
peytrels1363373_peytrels
pictures1249343_pictures
precures12312903precures
respecters1445863respecters
scares85033003s__cares
scepters1237783scepters
sceptre1135043sceptre_
sceptred1343653sceptred
scores84725923s__cores
seaters74028943s_eaters
secedes103711983s_ecedes
secerns987733s_ecerns
secret8325063s_ec_ret
secrets9311773s_ec_rets
sectaries11312243s_ectaries
sectored1138063s_ectored
sectors93116443s_ectors
sects75622893s_ect__s
secure8513533s_ecure_
secured1059723s_ecured
securer958253s_ecurer
securers1057153s_ecurers
securest1058583s_ecurest
seethes103613743s_eethes
selectees1147013selectees
senores73218113s_enores
sentries81318053s_entries
seres55448893s_e__res
settees73513633s_ettees
setters73822063s_etters
settles73916003s_ettles
sheathes14610193sheathes
sheeters113111863sheeters
shelters113412813shelters
shelties111111383shelties
sinecures1144543sinecures
skeeters12298963skeeters
skelters12349373skelters
sketches1746823sketches
smectites1344623smectites
smelters103310513smelters
spacers113813873spacer_s
spaces104722633spac__es
spackles16319953spackles
spares84834553sp__ares
spates85028173sp_at_es
spathes125116533sp_athes
spatters103914703spatters
speakers14299453speakers
speared104314423spe_ared
spearer93913663spe_arer
spearers103711143spe_arers
spears84019473spe_ar_s
specced14266703spec_ced
specials1238033specials
speciates13229233speciates
specie10412223spec_ie_
specifies1647573specifies
specimen1444423specimen
specimens1543403specimens
specious1247483specious
specked16329013spec_ked
speckle15297553speckle_
speckled17255833speckled
specks144312703spec__ks
specs96916673spec___s
spectacles1643913spectacles
spectate12248833spectate
spectated14236593spectated
speeches1537413speeches
speeders11339313speeders
speered103614813spe_ered
speers85019953spe_er_s
speired103811103spe_ired
speirs85013233spe_ir_s
speises93813933spe_ises
speisses10245693speisses
spellers102812753spellers
spelter94113703spelt_er
spelts84614643spelt__s
spencers12269193spencer_s
spences113413923spe_nces
spenders113211743spenders
spenses92913573spe_nses
sperms102512603spe__rms
spewers124210653spewer_s
spheres123114353sp_heres
spiceries1349313spiceries
spicers113815553spicer_s
spices104326033spic__es
spicules12219803spicules
spires84628113sp__ires
spites84127333sp_it_es
spitters104113383spitters
spittles1038333spittles
spitzes1849183sp_itzes
splores91910953sp_lores
spores84726613sp__ores
sporters103714063sporters
spotters104313383spotters
spouters104011163spouters
sprites94220333sprit_es
spritzes1946943spritzes
spurters103311703spurters
spurtles1037783spurtles
sputters104012873sputters
stactes91914633stact_es
steres63929533ste__res
sucres84218893s_uc_res
sweaters113811063sweaters
sweeties11159723sweeties
swelters113110193swelters
theatres11298633theatres

Search took 9 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.1731032896.0
2DLD Change Limit1461621647.84318636.0
3Display Results1641640.0632603.2
 (SQL Overall)1786911648.07922118.0
 
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.