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 “spires” with Change Limit: [1] [2]

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

227 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
spires8462811(None) 
aspires9612041aspires
shires95225571shires
sires55945371s_ires
spares84834551spares
spices104326031spices
spiers84421741spiers
spies76037621spi_es
spikes124520711spikes
spiles84227911spiles
spines85132031spines
spire75828691spire_
spirea84015631spirea
spireas94412511spireas
spired94921861spired
spirem104214161spirem
spirems11499561spirems
spirts85317131spirts
spites84127331spites
spores84726611spores
apices104916262apices
apres75426402ap_res
aspire8612122aspire_
aspired1068172aspired
aspirer967902aspirer
aspirers1066492aspirers
aspises9611642aspises
cires74932912_cires
empires1139852empires
espies83716802espi_es
expires1638682expires
fires85740752_fires
hires86134342_hires
inspires1037622inspires
ires45639282__ires
mires75640882_mires
moires8915632moires
opines84820702opines
pares77164482_pares
peres76246642_peres
piers75926332_piers
pies66949602_pi_es
pikes115031032_pikes
piles74742612_piles
pines76048862_pines
pipes96030142_pipes
pirns76020092_pirns
pixes144323172_pixes
pores75849032_pores
pries74339532_pries
pyres105523882_pyres
quires154015752quires
respires10311902respires
sabres85520862sabres
saices84221802saices
satires72617572satires
scares85033002scares
scores84725922scores
scries85226822scries
seines65029902seines
seises64026712seises
seizes154317532seizes
seres55448892s_eres
series64540972series
shares95236412shares
shiers94921752shiers
shies86136552shi_es
shines95028912shines
shire84727132shire_
shirks134814122shirks
shirrs94413172shirrs
shirts94918342shirts
shives124921412shives
shores94830412shores
sices75637272s_ices
sides65838362s_ides
sikes96236082s_ikes
sines55954822s_ines
sipes76036952s_ipes
sire46150412s_ire_
sired66134282s_ired
siree55238812s_iree
sirees64624582s_irees
siren54525822s_iren
sirens65318152s_irens
sirs44338332s_ir_s
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skiers104713702skiers
skies95026832ski_es
skirls10449822skirls
skirrs10448192skirrs
skirts104111502skirts
skites104418042skites
skives134113942skives
slices84022852slices
slides73922182slides
slimes84722042slimes
slipes84921412slipes
smiles84522292smiles
smirks124910122smirks
smites83921922smites
snares65329032snares
snipes83917392snipes
snores64324322snores
soiree62919482soiree
soirees72411642soirees
sopites93817172sopites
sores55454282s_ores
spaces104722632spaces
spades94222582spades
spaes76029972sp_aes
spales84728102spales
spare75135562spare_
spared95427492spared
sparer84524962sparer
sparers94519612sparers
sparest94616422sparest
sparges104016342sparges
sparks124616362sparks
spars75431542spar_s
sparse84516342sparse
spates85028172spates
speers85019952speers
speired103811102speired
speirs85013232speir_s
speises93813932speises
sperms102512602sperms
spheres123114352spheres
spicas104715822spicas
spice95528812spice_
spiced115218312spiced
spicer104719312spicer
spicers113815552spicers
spicey134414232spicey
spicks144814992spicks
spics94123242spi_cs
spider94516802spider
spiders103914412spiders
spied85427712spi_ed
spiel74623912spi_el
spiels85317952spiels
spier75728032spi_er
spiered104412462spiered
spiffs14328472spiffs
spike114922842spike_
spiked134915552spiked
spiker124315662spiker
spikers135311992spikers
spikey155411332spikey
spiks114117472spi_ks
spile75230082spile_
spiled94621992spiled
spills84717462spills
spine76534422spine_
spined95423942spined
spinel85317332spinel
spinels94512442spinels
spinet85629752spinet
spinets94714812spinets
spins75327982spi_ns
spiraea9407982spiraea
spiraeas10286232spiraeas
spiral83715342spiral
spirals93212512spirals
spireme11478362spireme
spiremes12397622spiremes
spirier93214072spirier
spiriest102513452spiriest
spirit83519922spirit
spirits94112622spirits
spirt75032952spir_t
spirted103913072spirted
spiry105017352spir_y
spite75430662spite_
spited94820442spited
spits74429552spi_ts
spitzes1849182spitzes
spivs105114242spi_vs
splices113914382splices
splines94718892splines
splores91910952splores
spodes94817432spodes
spokes124417212spokes
spore75428592spore_
spored94821792spored
sports84619182sports
spree74830862sp_ree
sprees85620642sprees
sprier84119062sprier
spriest92718642spriest
sprigs94814772sprigs
sprites94220332sprites
sprits85122532sprits
sprues84515762sprues
spues75025382sp_ues
spumes1021314882spumes
spurges104111652spurges
spurns84811382spurns
spurs74621522spur_s
spurts84814972spurts
squires163812842squires
stares66038752stares
steres63929532steres
sties55132982sti_es
stiles64328772stiles
stimes85920572stimes
stipes84524052stipes
stirks104914242stirks
stirpes95011292stirpes
stirps85011822stirps
stirs55921622stir_s
stores65533662stores
sucres84218892sucres
suites63727402suites
supines94216382supines
suspires1038202suspires
swipes114114332swipes
swirls94010132swirls
swives123915182swives
tires55437492_tires
umpires1137812umpires
vires84529682_vires
wires86034912_wires
zaires1539702zaires

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825512272.18637763.5
3Display Results2272270.0633603.2
 (SQL Overall)1786912272.59268939.4
 
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.