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

205 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
spiraea940798(None) 
spiraeas10286231spiraeas
spirea84015631spir_ea
aspirata1054992aspirata
pirana8713262_pirana
piraya1167712_piraya
spicae104313702spicae_
spiral83715342spira_l
spiraled1137732spiraled
spirals93212512spirals
spirant9814292spirant
spire75828692spir_e_
spireas94412512spireas
spired94921862spir_ed
spirem104214162spir_em
spires84628112spir_es
spirier93214072spirier
spirted103913072spirted
spirula9257702spirula
aspirant1048863aspirant
aspiratae1143353aspiratae
aspirate1039943aspirate
aspirated1247703aspirated
aspirates1139613aspirates
aspire8612123aspir_e_
aspired1068173aspir_ed
aspirer967903aspir_er
aspires9612043aspir_es
parae76335703_parae_
perea75026443_per_ea
picara10311903_picara
pilea75123953_pi_lea
pinata83817223_pinata
piracy1339473_piracy
piragua1044643_piragua
piranas9912603_piranas
piranha12126363_piranha
pirate82322883_pirate
pirated102515613_pirated
pirates93020333_pirates
pirayas1277483_pirayas
pitaya1186603_pitaya
psoralea1083433psoralea
purana8712933_purana
shire84727133shir_e_
shires95225573shir_es
shirked153710463shirked
shirker143711343shirker
shirred113710503shirred
sifaka1353553s_ifaka
sire46150413s_ir_e_
sired66134283s_ir_ed
siree55238813s_ir_ee
sirees64624583s_irees
siren54525823s_ir_en
sires55945373s_ir_es
sirra54416323s_ir_ra
sirree64017343s_irree
skirled12348183skirled
skirred12347083skirred
skirret11278173skirret
skirted12388613skirted
skirter11338483skirter
smirked14307233smirked
smirker13327423smirker
soiree62919483soir_ee
soirees72411643soirees
spae65034323sp__ae_
spaed85522273sp__aed
spaes76029973sp__aes
spare75135563spar_e_
spared95427493spar_ed
sparer84524963spar_er
spares84834553spar_es
sparge94216053sparge_
sparged113512763sparged
sparger103613083sparger
sparges104016343sparges
sparked143513143sparked
sparker133914363sparker
sparred104512863sparred
sparse84516343sparse_
sparser94311483sparser
speared104314423speared
spearer93913663spearer
speired103811103speir_ed
spelaean1043213spelaean
spica94717943spi__ca
spicas104715823spica_s
spicate113214193spicate
spicated13309903spicated
spice95528813spi_ce_
spiced115218313spi_ced
spicer104719313spi_cer
spices104326033spi_ces
spicey134414233spi_cey
spicier115112463spicier
spicula11259293spicula
spider94516803spi_der
spied85427713spi__ed
spiegel1034553spiegel
spiel74623913spi__el
spieled104811883spieled
spieler93111233spieler
spier75728033spi__er
spiered104412463spiered
spies76037623spi__es
spiffed16257103spiffed
spike114922843spi_ke_
spiked134915553spi_ked
spiker124315663spi_ker
spikes124520713spi_kes
spikey155411333spi_key
spikier13369983spikier
spile75230083spi_le_
spiled94621993spi_led
spiles84227913spi_les
spilled103613623spilled
spiller92914333spiller
spinach1435403spinach
spinage10289653spinage
spinages11289293spinages
spinal84915313spina_l
spinals93911863spinals
spinate93114813spinate
spine76534423spi_ne_
spined95423943spi_ned
spinel85317333spi_nel
spines85132033spi_nes
spinet85629753spi_net
spinier93715163spinier
spinner93912263spinner
spinney12438923spinney
spinula9257903spinula
spiracle1255803spiracle
spiracles1345663spiracles
spiralled1244403spiralled
spirally1348023spirally
spirants1088283spirants
spireme11478363spireme
spiremes12397623spiremes
spirems11499563spirems
spiriest102513463spiriest
spirilla1045073spirilla
spiring103918183spiring
spirit83519923spir_it
spirited1148973spirited
spirits94112623spirits
spiroid10219823spiroid
spirt75032953spir__t
spirts85317133spir_ts
spirulae10216573spirulae
spirulas10207203spirulas
spiry105017353spir__y
spital83813873spita_l
spitals93011593spitals
spite75430663spi_te_
spited94820443spi_ted
spites84127333spi_tes
spitted103912703spitted
spitter94015183spitter
spitzes1849183spitzes
sporal82915453spora_l
spore75428593spor_e_
spored94821793spor_ed
spores84726613spor_es
sported104015433sported
sporter93616553sporter
sprag86418693sp_ra_g
sprags95715823sp_rags
sprain83614863sp_rain
sprang95713523sp_rang
sprat76635973sp_ra_t
sprats85819933sp_rats
sprawl11188063sp_rawl
spray106720063sp_ra_y
sprayed13398903sp_rayed
sprayer12369043sp_rayer
sprays115913643sp_rays
spread9312533sp_read
spree74830863sp_r_ee
sprees85620643sp_rees
sprier84119063sp_rier
sprite84421773sprite_
sprites94220333sprites
sprue74717633sp_rue_
sprues84515763sp_rues
spryer11418533sp_ryer
spurge93711323spurge_
spurges104111653spurges
spurned10339263spurned
spurner9269653spurner
spurred103610623spurred
spurrer93710223spurrer
spurrey12307813spurrey
spurted103111973spurted
spurter94013003spurter
stirpes95011293stirpes
stirred8359703stirred
stirrer7338233stirrer
strata63616283s_trata
striae65422273striae_
striata7379953striata
subarea939403subarea
swirled11308223swirled

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.516346300.4
2DLD Change Limit1340272056.65620136.3
3Display Results2052050.0633254.0
 (SQL Overall)1786912057.23524698.1
 
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.