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

182 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
spireme1147836(None) 
spirem104214161spirem_
spiremes12397621spiremes
spirems11499561spirems
bireme10310142_bireme
siree55238812s_ire_e
soiree62919482soire_e
spire75828692spir__e
spirea84015632spire_a
spireas94412512spireas
spired94921862spire_d
spires84628112spire_s
spree74830862sp_re_e
supreme1137892supreme
trireme935262trireme
apiece10510083api_ece
aspirate1039943aspirate
aspire8612123aspir__e
aspired1068173aspire_d
aspirer967903aspire_r
aspirers1066493aspirers
aspires9612043aspire_s
biremes1138773_biremes
creme94319323__creme
epicene1148593epicene
epigene1037893epigene
epimere1186983epimere
episome1157813episome
epitome1157743epitome
extreme1645653extreme
firemen1238773_firemen
hiree85427803_hire_e
pareve114613013_pareve
piece96717993_pi_ece
pierce104010393_pierce
pikemen1535333_pikemen
pinene82915643_pinene
pirate82322883_pirate
pree67044733_p_re_e
premed114617763_p_remed
premen105017803_p_remen
premie103617993_p_remie
prese75228383_p_rese
prime96525603_p_rime
puree74632843_pure_e
pyrene113210733_pyrene
saree55044663s_are_e
scheme1379633s_cheme
scree720031713s_cre_e
scrieve12448333scrieve
secrete9311073secrete
seme65836653s___eme
sememe10129983s_ememe
serene63522353s_erene
seriema938403seriema
shire84727133shir__e
shires95225573shire_s
shrieve13417683shrieve
sidemen1037943s_idemen
siege66718443s_i_ege
sieve84918843s_i_eve
sire46150413s_ir__e
sired66134283s_ire_d
sirees64624583s_irees
siren54525823s_ire_n
sirens65318153s_irens
sires55945373s_ire_s
sirree64017343s_irree
slieve9359273sli_eve
slime74925753sli__me
soirees72411643soirees
spacemen1445413spacemen
spahee11313443spahe_e
spare75135563spar__e
spared95427493spare_d
sparely123410673sparely
sparer84524963spare_r
sparers94519613sparers
spares84834553spare_s
sparest94616423sparest
sparge94216053spar_ge
sparkle133710213sparkle
sparse84516343spar_se
speired103811103speire_d
sperm93216023sper_m_
sperms102512603sper_ms
sphene113412403sp_hene
sphere113313663sp_here
spicae104313703spi_cae
spicate113214193spicate
spice95528813spi__ce
spiced115218313spice_d
spicer104719313spice_r
spicers113815553spicers
spicery14499013spicery
spices104326033spice_s
spicey134414233spice_y
spicule11269933spicule
spider94516803spide_r
spiders103914413spiders
spidery13308203spidery
spied85427713spi_e_d
spiegel1034553spi_egel
spiel74623913spi_e_l
spieled104811883spi_eled
spieler93111233spi_eler
spiels85317953spi_els
spier75728033spi_e_r
spiered104412463spiered
spiers84421743spi_ers
spies76037623spi_e_s
spike114922843spi__ke
spiked134915553spike_d
spikelet1446533spikelet
spiker124315663spike_r
spikers135311993spikers
spikes124520713spike_s
spikey155411333spike_y
spile75230083spi__le
spiled94621993spile_d
spiles84227913spile_s
spinage10289653spinage
spinate93114813spinate
spindle103210093spindle
spine76534423spi__ne
spined95423943spine_d
spinel85317333spine_l
spinelle1046223spinelle
spinels94512443spinels
spines85132033spine_s
spinet85629753spine_t
spinets94714813spinets
spinose937943spinose
spinule9299993spinule
spiracle1255803spiracle
spiraea9407983spiraea
spiraeas10286233spiraeas
spiral83715343spir_al
spiraled1137733spiraled
spirals93212513spirals
spirant9814293spirant
spirier93214073spirier
spiriest102513453spiriest
spiring103918183spiring
spirit83519923spir_it
spirited1148973spirited
spirits94112623spirits
spiroid10219823spiroid
spirt75032953spir__t
spirted103913073spirted
spirts85317133spir_ts
spirula9257703spirula
spirulae10216573spirulae
spiry105017353spir__y
spite75430663spi__te
spited94820443spite_d
spites84127333spite_s
spittle937923spittle
spore75428593spor__e
spored94821793spore_d
spores84726613spore_s
sporule937273sporule
spread9312533sp_read
sprees85620643sp_rees
sprent84522383sp_rent
sprier84119063sprie_r
spriest92718643spriest
springe103913983springe
sprite84421773sp_rite
spruce103910873sp_ruce
sprue74717633sp_r_ue
spume95817313sp__ume
spurge93711323spur_ge
spurtle937453spurtle
stime76521803sti__me
styrene10116693styrene
supremer1246483supremer
supremes1238363supremes
supremo1145723supremo
triremes1035523triremes
triseme936543triseme
wiremen1236903_wiremen

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 Limit1340271826.64020184.8
3Display Results1821820.0632888.9
 (SQL Overall)1786911827.10925135.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.