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

179 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
spectre1129777(None) 
specter113111731specter
spectra11275831spectra
spectres12268681spectres
sceptre1135052sceptre
secure8513532s_ecure
specie10412222spec_ie
speckle15297552speckle
spectate12248832spectate
specters122811062specters
spectral12246192spectral
spectrum1444072spectrum
spelter94113702spelter
aperture1046383aperture
aspect10612823aspect__
aspects1146743aspect_s
centre84316643_centre
decare93919153_decare
electee92513243electee
electret10411993electret
electro92810033electro
epicure1136823epicure
erecter93113393erecter
expecter1936513expecter
hectare1238463_hectare
lecture9149513_lecture
metre74821303_me_tre
pecker144615363_pecker
pectase112410363_pectase
pectate112214693_pectate
pecten102711103_pecten
pectic122913873_pectic
pectin102615533_pectin
pectize20259913_pectize
pelter83321623_pelter
peltry11288653_peltry
pere66450263_pe__re
perter84422283_perter
pester84827593_pester
pestle83215843_pestle
peter74427593_pe_ter
petrel83111533_pe_trel
petter83924773_petter
pettle84116053_pettle
pewter114013673_pewter
peytrel1264253_peytrel
picture1158613_picture
plectra1145783plectra
precure11312553precure
respecter1347443respecter
scare75334463s__care
scepter1138363scepter
sceptred1343653sceptred
sceptres1244993sceptres
score75526743s__core
seater64534163s_eater
secede93311993s_ecede
secern81010223s_ecern
secret8325063s_ec_ret
sect67443623s_ect__
sectary1238273s_ectary
sectile9311973s_ectile
sector83415933s_ector
sectored1138063s_ectored
sectors93116453s_ectors
sects75622893s_ect_s
secured1059723s_ecured
securer958253s_ecurer
secures9613163s_ecures
seethe93712483s_eethe
selectee10910493selectee
sempre102710093s_empre
sente56432883s_ent_e
sentry92912053s_entry
sere46153473s_e__re
setae56026223s_e_tae
settee63721023s_ettee
setter64023723s_etter
settle63915663s_ettle
severe94016083s_evere
sheathe1348993sheathe
sheeter103814913sheeter
shelter103214963shelter
sheltie10109913sheltie
sincere9310553sincere
sinecure1044323sinecure
skeeter113410413skeeter
skelter113610003skelter
smectic1336613smectic
smectite1245773smectite
smelter93311913smelter
space95325673spac__e
spacer104917793spacer_
spacers113813873spacers
spacier114011633spacier
spackle15369573spackle
spare75135563sp__are
spate74731583sp_at_e
spathe115115693sp_athe
spatter94016523spatter
speaker133311213speaker
spear75821063spe_ar_
speared104314423spe_ared
spearer93913663spe_arer
spears84019473spe_ars
spec85821973spec___
specced14266703specced
special11310303special
speciate12209583speciate
species11314133species
specify1764993specify
specimen1444423specimen
speck135115653spec__k
specked16329013specked
speckled17255833speckled
speckles16268133speckles
specks144312703spec_ks
specs96916673spec__s
spectacle1544083spectacle
spectated14236593spectated
spectates13228813spectates
spectrums1543173spectrums
specula11187413specula
speeder103811073speeder
speer74623903spe_er_
speered103614813spe_ered
speers85019953spe_ers
speir75315363spe_ir_
speired103811103spe_ired
speirs85013233spe_irs
speise84614253spe_ise
speller95415153speller
spelt75430193spelt__
spelters103912243spelters
spelts84614643spelt_s
speltz174010123spelt_z
speltzes1944003speltzes
spence103813793spe_nce
spencer113610973spencer_
spencers12269193spencers
spender103713693spender
spense83912433spe_nse
spent75532833spent__
sperm93216023spe__rm
spewer115112153spewer_
spewers124210663spewers
sphere113313663sp_here
spicae104313703spic_ae
spicate113214193spicate
spice95528813spic__e
spicer104719313spicer_
spicers113815553spicers
spicery14499013spicery
spicier115112463spicier
spicule11269933spicule
spire75828693sp__ire
spite75430663sp_it_e
spitter94015183spitter
spittle937923spittle
splore81611303sp_lore
spore75428593sp__ore
sporter93616553sporter
spotter94514883spotter
spouter94213223spouter
sprite84421773sprit_e
spurter94013003spurter
spurtle937453spurtle
sputter94014053sputter
stacte82113913stact_e
stere55328543ste__re
sucre75019103s_uc_re
svelte9319753svelt_e
svelter10359673svelter
sweater103712723sweater
sweeter103212003sweeter
sweetie10157873sweetie
swelter103711173swelter
sweltry1333413sweltry
theatre10358493theatre

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271796.95319276.1
3Display Results1791790.0632841.3
 (SQL Overall)1786911797.42224075.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.