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

237 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
spiraled113773(None) 
spiralled1244401spiralled
aspirated1247702aspirated
pirated102515612_pirated
skirled12348182skir_led
sparkled15317732sparkled
spicated13309902spicated
spieled104811882spi_eled
spiled94621992spi__led
spilled103613622spi_lled
spindled12287642spindled
spiracle1255802spiracle_
spiracles1345662spiracles
spiraea9407982spira_ea
spiral83715342spiral__
spirally1348022spirally
spirals93212512spiral_s
spired94921862spir__ed
spirited1148972spirited
spirted103913072spir_ted
sprawled1434522sp_rawled
sprayed13398902sp_rayed
swirled11308222swir_led
appealed1335603appealed
asperated1239313asperated
aspirate1039943aspirate_
aspirates1139613aspirates
aspired1068173aspir__ed
birled94416993_bir_led
circled1237583_circled
dialed84716453_di_aled
dirled84514903_dir_led
epilated11310753epilated
girdled10217453_girdled
hirpled13157133_hirpled
hirsled11118113_hirsled
kirtled12287033_kirtled
muraled10410833_muraled
operated11512223operated
opiated1039483opi_ated
paled85538723_p__aled
paraded114014263_paraded
parled94626283_par_led
paroled104217623_paroled
pealed95322803_p_ealed
pearled10411543_pearled
pedaled113711883_pedaled
periled10316313_periled
petaled103614143_petaled
phrased1387383_phrased
pickled164011883_pickled
picrated132110113_picrated
piddled123311253_piddled
piffled16366403_piffled
piled85232993_pi__led
pilled94222753_pi_lled
pimpled14289183_pimpled
pirate82322883_pirate_
pirates93020333_pirates
portaled11239203_portaled
prated94924923_p_rated
prayed124815433_p_rayed
prilled104712993_prilled
psoralea1083433psoralea
psoralen1063453psoralen
purfled13248723_purfled
purled94520743_pur_led
purpled12299773_purpled
pyralid1347983_pyralid
rivaled1138933_rivaled
sailed74327763sai__led
sandaled1039243sandaled
scaled94822443s__caled
scraped124313133s_craped
scrawled1445913s_crawled
sealed74328363s__ealed
sepaled10510593s_epaled
separated1237713separated
seriated92717023seriated
serrated92513433serrated
shaled105023953s__haled
shilled113313623shi_lled
shingled13358323shingled
shirked153710463shir_ked
shirred113710503shir_red
shoaled113810973s_hoaled
shrilled1246863shrilled
sialid7314943s_i_alid
sickled144713433s_ickled
sidled84215173s_i_dled
signaled1035393signaled
singled93914683s_ingled
sired66134283s_ir__ed
siruped1036013s_iruped
sizzled16367883s_izzled
skiffled19244423skiffled
skilled123110863ski_lled
skirred12347083skir_red
skirted12388613skir_ted
skoaled12226063s_koaled
smiled93716433smi__led
smirched1634673smirched
smirked14307233smir_ked
snarled83612363snar_led
sniffled15276443sniffled
sniggled11275743sniggled
sniveled1255463sniveled
soiled73822473soi__led
spaced114517253sp__aced
spackled17297803spackled
spaded103816753sp__aded
spaed85522273sp__a_ed
spale74929213sp__ale_
spales84728103sp__ales
spalled103113133sp_alled
spangled1236153spangled
sparable121611983sparable_
sparables13167163sparables
spared95427493sp__ared
sparged113512763spar_ged
sparked143513143spar_ked
sparkle133710213sparkle_
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparred104512863spar_red
spayed124213613sp__ayed
speaned103411523sp_eaned
speared104314423sp_eared
speckled17255833speckled
speeled103712453sp_eeled
speiled104412123sp_eiled
speired103811103speir__ed
spelled103714733sp_elled
spicae104313703spica_e_
spicate113214193spicate_
spiced115218313spi__ced
spicule11269933spicule_
spicules12219803spicules
spied85427713spi___ed
spieler93111233spi_eler
spiered104412463spi_ered
spiffed16257103spi_ffed
spiffied17234823spiffied
spiked134915553spi__ked
spikelet1446533spikelet
spile75230083spi__le_
spiles84227913spi__les
spiller92914333spi_ller
spinage10289653spinage_
spinages11289293spinages
spinal84915313spinal__
spinally1338023spinally
spinals93911863spinal_s
spinate93114813spinate_
spindle103210093spindle_
spindler11297983spindler
spindles112710353spindles
spined95423943spi__ned
spinule9299993spinule_
spinules10249333spinules
spiraeas10286233spiraeas
spiraling1237953spiraling
spirality1446433spirality
spirant9814293spira_nt
spirants1088283spirants
spire75828693spir__e_
spirea84015633spir__ea
spirem104214163spir__em
spireme11478363spireme_
spiremes12397623spiremes
spires84628113spir__es
spirier93214073spir_ier
spirilla1045073spirilla
spiroid10219823spir_oid
spirula9257703spirul_a
spirulae10216573spirulae
spirulas10207203spirulas
spital83813873spital__
spitals93011593spital_s
spited94820443spi__ted
spitted103912703spi_tted
spittle937923spittle_
spittles1038333spittles
splayed13357813sp_layed
spoiled104811353sp_oiled
spooled104613523sp_ooled
sporal82915453sporal__
spored94821793spor__ed
sported104015433spor_ted
sporule937273sporule_
sporules1037703sporules
spraddled14203463sp_raddled
sprained1138433sp_rained
sprattled1263313sp_rattled
sprawler1334643sp_rawler
sprayer12369043sp_rayer
sprigged13316223sprigged
springed123911323springed
sprinkled1633713sprinkled
sprinted113411163sprinted
spritzed2044803spritzed
spruced12307533sp_ruced
spurgalled1441763spurgalled
spurned10339263spur_ned
spurred103610623spur_red
spurted103111973spur_ted
spurtle937453spurtle_
spurtles1037783spurtles
squealed1885353squealed
staled74728103s__taled
startled9208563startled
stickled15298973stickled
stifled113511093sti_fled
stilled83314783sti_lled
stippled1345303stippled
stipuled1134453stipuled
stirred8359703stir_red
strafed114413333s_trafed
straked125415343s_traked
strawed114813613s_trawed
strayed114513283s_trayed
striated93414153striated
supinated1237883supinated
swilled113611833swi_lled
swindled13307623swindled
swingled13337433swingled
swiveled1544163swiveled
swizzled2053013swizzled
thirled11328093thir_led
tirled74714363_tir_led
twirled11385983twir_led
upgraded13215683upgraded
uprated103213323up_rated
upscaled13144873upscaled
vialed105112593_vi_aled
whirled14368043whir_led

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622377.12320519.7
3Display Results2372370.0932548.4
 (SQL Overall)1786912377.37224239.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.