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

408 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
spirals9321251(None) 
spinals93911861spinals
spiral83715341spiral_
spitals93011591spitals
apicals1159922apicals
espials937092espi_als
pibals103813082_pibals
pipals104213642_pipals
sacrals93311792sacrals
serials73919742serials
sials54227242s_i_als
sisals63013572s_isals
skirls10449822skir_ls
spicas104715822spica_s
spiels85317952spi_els
spills84717462spi_lls
spinal84915312spinal_
spinels94512442spinels
spiracle1255802spiracle
spiracles1345662spiracles
spiraea9407982spiraea
spiraeas10286232spiraeas
spiraled1137732spiraled
spirally1348022spirally
spirant9814292spirant
spirants1088282spirants
spireas94412512spireas
spirems11499562spirems
spires84628112spir_es
spirits94112622spirits
spirts85317132spir_ts
spirula9257702spirula
spirulas10207202spirulas
spital83813872spital_
sporal82915452sporal_
sprags95715822sp_rags
sprats85819932sp_rats
sprawls12176372sp_rawls
sprays115913642sp_rays
swirls94010132swir_ls
admirals1144353admirals
aerials74017553aerials
animals94111703animals
apical10913903apical_
appals104812943ap_pals
appeals11378673appeals
aspirant1048863aspirant
aspirants1145233aspirants
aspirata1054993aspirata
aspirate1039943aspirate
aspirates1139613aspirates
aspirers1066493aspirers
aspires9612043aspir_es
aspirins1037733aspirins
astrals75515243astrals
bharals1236733bharals
birls74023163_bir_ls
borals86721913_borals
bridals1038623bridals
burials93612083burials
capitals12209443capitals
caporals1238923caporals
chiral114614413chiral_
chorals124614113chorals
citrals91111673citrals
corals85325143_corals
corrals93713853corrals
cuirass934973cuirass
despisals1243503despisals
dials64925343_di_als
dirams94413703_dirams
dirls64720503_dir_ls
epical10413393epical_
epidurals1242193epidurals
epigrams1346113epigrams
epinaos936283epinaos
espial839543espi_al_
ferals94216643_ferals
finals94316163_finals
florals104210063florals
girls64518393_gir_ls
goorals838703goorals
gorals76917653_gorals
hospitals1443903hospitals
liras56021983_lira_s
mbiras1077153mbira_s
morals85324633_morals
murals84016763_murals
nairas6312783naira_s
opals75718353op__als
operas8312453opera_s
orals55826483__orals
pals66951353_p__als
paras76143043_para_s
parols84722613_parols
parrals94414573parrals
peals75235493_p_eals
pearls84715393_pearls
pedals94316033_pedals
perils84121853_perils
petals84719813_petals
phials1158873_phials
pial65636703_pi_al_
pians75126963_pi_ans
pias66542553_pi_a_s
pibal95217323_pibal_
pical95524373_pical_
picas94626523_pica_s
piculs103511753_piculs
pikas114218093_pika_s
pilafs113511023_pilafs
pilaus84114133_pilaus
pilaws11399433_pilaws
pills74130973_pi_lls
pimas94725103_pima_s
pinas75434453_pina_s
pineals93212843_pineals
pipal95118353_pipal_
piracy1339473_piracy
pirana8713263_pirana
piranas9912603_piranas
pirate82322883_pirate
pirates93020333_pirates
piraya1167713_piraya
pirayas1277483_pirayas
pirns76020093_pir_ns
pitas77427673_pita_s
pixels15478533_pixels
plurals936913plurals
portals94015563_portals
prams96125513_p_rams
praos74923563_p_raos
prats76333393_p_rats
praus74621753_p_raus
prays105022433_p_rays
prills84015613_prills
purls74723353_pur_ls
pyrans11411063_pyrans
rials55026673_ri_als
ripraps1134943ripraps
rivals94213183_rivals
riyals94111083_riyals
sabals84618863s_abals
sabras85116363sabra_s
sacral83414413sacral_
safrols1036863safrols
sahiwals1443643sahiwals
saigas74114293saiga_s
sails55738103sai__ls
salals65120083s_alals
sals46851673s___als
sambals115213483sambals
sandals82715203sandals
sarans64224433s_arans
satraps95011643satraps
saurels749303saurels
scarabs1137293scarabs
scillas9310473scillas
scrags95713803s_crags
scrams105216623s_crams
scraps106017243s_craps
scrawls12177283s_crawls
seals54839693s__eals
seidels838393seidels
seitans73312303seitans
sendals81912263sendals
sepals85217373s_epals
sepias83616103sepi_a_s
seracs84418573s_eracs
serails73318363s_erails
serais64326133s_erais
seral56336383s_eral_
serial64625863serial_
servals103410743servals
severals1137593severals
sheals94420643s_heals
shibahs15275643shibahs
shiels95418923shi_els
shikars1436183shikars
shills94519613shi_lls
shires95225573shir_es
shirks134814123shir_ks
shirrs94413173shir_rs
shirts94918343shir_ts
shivahs16375723shivahs
shivas124512413shiva_s
shoals94215793s_hoals
shorans102812413shorans
shorls94516203shor_ls
shrills10389933shrills
sial45938833s_i_al_
sibyls1135303s_ibyls
sigils73912363s_igils
signals8359163signals
sikas94617023s_ika_s
sills55135993s_i_lls
simars84916933s_imars
simas75727553s_ima_s
sirdars8228213s_irdars
sirees64624583s_irees
sirens65318153s_irens
sires55945373s_ir_es
sirrahs10377303sirrahs
sirras63814863s_irras
sirs44338333s_ir__s
sirups83710533s_irups
sisal54217733s_isal_
sitars65417593s_itars
sizars154812623s_izars
skills104313923ski_lls
skirl96012913skir_l_
skirrs10448193skir_rs
skirts104111503skir_ts
skoals10438243s_koals
smirks124910123smir_ks
snarls64016873snar_ls
snivels10336903snivels
socials999633socials
soils55327983soi__ls
soirees72411643soirees
soras55041013s_ora_s
sorels63921163s_orels
sorrels7310723sorrels
sovrans1036483sovrans
spaes76029973sp__aes
spails84817823sp_ails
spale74929213sp__ale
spales84728103sp__ales
spall74919303sp__all
spalls84217343sp_alls
spams94922193sp__ams
spans74528733sp__ans
sparable121611983sparable
sparables13167163sparables
sparely123410673sparely
sparers94519613sparers
spares84834553spar_es
sparges104016343sparges
sparids103512123sparids
sparkle133710213sparkle
sparkles143210493sparkles
sparkly16348133sparkly
sparks124616363spar_ks
spars75431543sp__ars
spas67036723sp__a_s
spats75031383sp__ats
spays105520513sp__ays
speaks125114583sp_eaks
speans85417143sp_eans
spears84019473sp_ears
specials1238033specials
speels85116393sp_eels
speils84116223sp_eils
speirs85013233speir__s
spells84617683sp_ells
sperms102512603sper_ms
spheral1238423spheral_
spica94717943spica__
spicae104313703spica_e
spicate113214193spicate
spicers113815553spicers
spices104326033spi_ces
spicily1438653spicily
spicks144814993spi_cks
spics94123243spi__cs
spicula11259293spicula
spicule11269933spicule
spicules12219803spicules
spiders103914413spiders
spiegels1133873spiegels
spiel74623913spi_el_
spiers84421743spi_ers
spies76037623spi__es
spiffs14328473spi_ffs
spigots1037793spigots
spikers135311993spikers
spikes124520713spi_kes
spikily1635873spikily
spiks114117473spi__ks
spile75230083spi__le
spiles84227913spi_les
spill74821163spi__ll
spilt75532223spi__lt
spilths12356023spilths
spinach1435403spinach
spinage10289653spinage
spinages11289293spinages
spinally1338023spinally
spinate93114813spinate
spindle103210093spindle
spindles112710353spindles
spindly13257383spindly
spinel85317333spinel_
spines85132033spi_nes
spinets94714813spinets
spinors939423spinors
spinous9310443spinous
spins75327983spi__ns
spintos939133spintos
spinula9257903spinula
spinule9299993spinule
spinules10249333spinules
spiraling1237953spiraling
spirality1446433spirality
spiralled1244403spiralled
spire75828693spir__e
spirea84015633spir_ea
spired94921863spir_ed
spirem104214163spir_em
spireme11478363spireme
spiremes12397623spiremes
spirier93214073spirier
spiriest102513453spiriest
spirilla1045073spirilla
spiring103918183spiring
spirit83519923spir_it
spirituals1253553spirituals
spiroid10219823spiroid
spirt75032953spir__t
spirted103913073spirted
spirulae10216573spirulae
spiry105017353spir__y
spitball1244493spitball
spitballs1344073spitballs
spites84127333spi_tes
spits74429553spi__ts
spittle937923spittle
spittles1038333spittles
spitzes1849183spitzes
spivs105114243spi__vs
splats84817303sp_lats
splays114910873sp_lays
spoils84614533sp_oils
spools85115913sp_ools
spores84726613spor_es
sporrans1045523sporrans
sports84619183spor_ts
sporule937273sporule
sporules1037703sporules
spousals1064353spousals
sprag86418693sp_ra_g
sprain83614863sp_rain
sprains93013593sp_rains
sprang95713523sp_rang
sprangs104610053sp_rangs
sprat76635973sp_ra_t
sprawl11188063sp_rawl
sprawly15166043sp_rawly
spray106720063sp_ra_y
spreads1039763spreads
sprees85620643sp_rees
sprigs94814773sp_rigs
springals1245373springals
springs104415923springs
sprints94113773sprints
sprites94220333sprites
sprits85122533sp_rits
sprues84515763sp_rues
sprugs94010173sp_rugs
spryly1435513sp_ryly
spurgall1143263spurgall
spurgalls1243093spurgalls
spurges104111653spurges
spurns84811383spur_ns
spurs74621523spur__s
spurtle937453spurtle
spurtles1037783spurtles
spurts84814973spur_ts
squeals1636513squeals
steals64020063s_teals
sterols7313443sterols
stills64118573sti_lls
stipels9418953stipels
stirks104914243stir_ks
stirpes95011293stirpes
stirps85011823stir_ps
stirs55921623stir__s
straps87721783s_traps
strass67117223s_trass
straws98718673s_traws
strays96417933s_trays
sunrays1037083sunrays
surahs94515543s_urahs
sural55931263s_ural_
suras55336333s_ura_s
surras65919533surra_s
sutras64818593sutra_s
swills94213363swi_lls
swirl84514143swir_l_
swirly12439253swir_ly
swivels13396773swivels
thirams1236823thirams
thirls95012063thir_ls
ticals83214713_ticals
tirls54519803_tir_ls
trials64319883tri_als
tribals9610753tribals
twirls9478123twir_ls
urials64415193uri_als
urinals7610253urinals
vesperals1443933vesperals
vials85822383_vi_als
vinals94716483_vinals
viral86419593_viral_
virls85618603_vir_ls
vitals94514303_vitals
whirls124710533whir_ls
zirams17438643_zirams

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 Limit1340274086.72019944.5
3Display Results4084080.1402914.3
 (SQL Overall)1786914087.26624592.8
 
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.