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

425 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
spirems1149956(None) 
spireas94412511spireas
spirem104214161spirem_
spireme11478361spireme
spiremes12397621spiremes
spires84628111spire_s
aspirers1066492aspirers
aspires9612042aspire_s
shires95225572shire_s
sirees64624582s_irees
sirens65318152s_irens
sires55945372s_ire_s
soirees72411642soirees
sparers94519612sparers
spares84834552spare_s
sperms102512602sper_ms
spicers113815552spicers
spices104326032spice_s
spiders103914412spiders
spiels85317952spi_els
spiers84421742spi_ers
spies76037622spi_e_s
spikers135311992spikers
spikes124520712spike_s
spiles84227912spile_s
spinels94512442spinels
spines85132032spine_s
spinets94714812spinets
spiraeas10286232spiraeas
spirals93212512spirals
spire75828692spire__
spirea84015632spire_a
spired94921862spire_d
spirits94112622spirits
spirts85317132spir_ts
spites84127332spite_s
spores84726612spore_s
sprees85620642sp_rees
airers64922313_airers
apices104916263apice_s
apres75426403ap_re_s
aspire8612123aspire__
aspired1068173aspire_d
aspirer967903aspire_r
aspirins1037733aspirins
aspises9611643aspise_s
bireme10310143_bireme
biremes1138773_biremes
chirms135113983chir_ms
cires74932913_cire_s
dirams94413703_dirams
empires1139853empire_s
epiderms1345043epiderms
epigrams1346113epigrams
epimers11109493epimers
espies83716803espi_e_s
expirers1735123expirers
expires1638683expire_s
firers94922683_firers
fires85740753_fire_s
firms105217423_fir_ms
harems115513823_harems
heiress1036813heiress
hirees95117293_hirees
hirers94518063_hirers
hires86134343_hire_s
inspirers1143963inspirers
inspires1037623inspire_s
ires45639283__ire_s
items7499613__items
maihems1444303maihems
mires75640883_mire_s
moires8915633moire_s
opines84820703opine_s
opiums10307073opi_ums
oppress1135993oppress
ospreys1233143osp_reys
pareos87023773_pareos
parers85530743_parers
pares77164483_pare_s
pareus85420743_pareus
peres76246643_pere_s
perms95524513_per_ms
piers75926333_pi_ers
pies66949603_pi_e_s
pikers124717393_pikers
pikes115031033_pike_s
piles74742613_pile_s
pileus84514943_pileus
pines76048863_pine_s
pipers104318663_pipers
pipes96030143_pipe_s
pipets105714773_pipets
pirns76020093_pir_ns
pixels15478533_pixels
pixes144323173_pixe_s
poems95715553_p_oems
pores75849033_pore_s
prams96125513_p_rams
prees75937173_p_rees
preps96220693_p_reps
press75425953_p_ress
preys105717783_p_reys
priers84521193_priers
pries74339533_prie_s
primes104225263_primes
prims95425933_p_rims
prisms104915503_prisms
proems104711163_proems
proms95426413_p_roms
purees84721683_purees
pyres105523883_pyre_s
quires154015753quire_s
rems66237723___rems
respires10311903respire_s
sabres85520863sabre_s
sachems14348903sachems
sacrums11388043sacrums
saices84221803saice_s
sailers73822323sailers
sapiens9310173sapi_ens
sarees65329943s_arees
satires72617573satire_s
saurels749303saurels
scarers94618513scarers
scares85033003scare_s
scorers94115323scorers
scores84725923score_s
scrams105216623s_crams
screams114810623s_creams
screes85023973s_crees
screws115513893s_crews
scries85226823scrie_s
scrims104615933s_crims
scrums104614253s_crums
secrets9311773secrets
seems75525023s__eems
seeress7311573seeress
seidels838393seidels
seiners74219273seiners
seines65029903seine_s
seisers73816393seisers
seises64026713seise_s
seisms84912143sei_sms
seizers164112503seizers
seizes154317533seize_s
seres55448893s_ere_s
seriema938403seriema
seriemas1047193seriemas
series64540973serie_s
serums83916303s_erums
sharers104720623sharers
shares95236413share_s
shiels95418923shi_els
shiers94921753shi_ers
shies86136553shi_e_s
shims104422553shi__ms
shiners104015943shiners
shines95028913shine_s
shire84727133shire__
shirkers15319583shirkers
shirks134814123shir_ks
shirrs94413173shir_rs
shirts94918343shir_ts
shivers133714833shivers
shives124921413shive_s
shores94830413shore_s
shreds105613053s_hreds
shrews129313923s_hrews
shrieks14377673shrieks
sices75637273s_ice_s
sides65838363s_ide_s
sikes96236083s_ike_s
sims65737173s_i__ms
sines55954823s_ine_s
sinews94210623s_inews
sipes76036953s_ipe_s
sippers113117753sippers
sippets113310183sippets
sire46150413s_ire__
sired66134283s_ire_d
siree55238813s_ire_e
siren54525823s_ire_n
sirras63814863s_irras
sirrees73410573sirrees
sirs44338333s_ir__s
sirups83710533s_irups
sises55233833s_ise_s
sites56045433s_ite_s
sivers95324153s_ivers
sixes124526363s_ixe_s
sizers155215813s_izers
sizes146727763s_ize_s
skiers104713703ski_ers
skies95026833ski_e_s
skims114517193ski__ms
skirls10449823skir_ls
skirrets12244013skirrets
skirrs10448193skir_rs
skirters12337243skirters
skirts104111503skir_ts
skites104418043skite_s
skivers14409703skivers
skives134113943skive_s
slicers94114923slicers
slices84022853slice_s
sliders83515223sliders
slides73922183slide_s
slimes84722043slime_s
slims75423653sli__ms
slipes84921413slipe_s
slivers104115253slivers
smarms105712533smar_ms
smilers94113853smilers
smiles84522293smile_s
smileys12336323smileys
smirkers14316353smirkers
smirks124910123smir_ks
smiters93414363smiters
smites83921923smite_s
snarers74216663snarers
snares65329033snare_s
snipers93311773snipers
snipes83917393snipe_s
snivels10336903snivels
snorers74313803snorers
snores64324323snore_s
soarers74118093soarers
soiree62919483soire_e
sopites93817173sopite_s
sorels63921163s_orels
sores55454283s_ore_s
sorrels7310723sorrels
spacers113813873spacers
spaces104722633space_s
spaders104214473spaders
spades94222583spade_s
spaes76029973sp_ae_s
spahees1238263spahees
spales84728103spale_s
spams94922193sp__ams
spare75135563spare__
spared95427493spare_d
sparely123410673sparely
sparer84524963spare_r
sparest94616423sparest
spargers11389733spargers
sparges104016343sparges
sparids103512123sparids
sparkers144111313sparkers
sparks124616363spar_ks
spars75431543spar__s
spasms10418973sp_asms
spates85028173spate_s
spearers103711143spearers
specs96916673sp__ecs
speeds94316053sp_eeds
speels85116393sp_eels
speers85019953sp_eers
speired103811103speire_d
speirs85013233speir__s
speises93813933speise_s
sperm93216023sper_m_
spewers124210663spewers
spews105015923sp__ews
spheres123114353spheres
spicas104715823spi_cas
spice95528813spice__
spiced115218313spice_d
spicer104719313spice_r
spicery14499013spicery
spicey134414233spice_y
spicks144814993spi_cks
spics94123243spi__cs
spider94516803spide_r
spidery13308203spidery
spied85427713spi_e_d
spiegels1133873spiegels
spiel74623913spi_e_l
spielers10319653spielers
spier75728033spi_e_r
spiered104412463spiered
spiffs14328473spi_ffs
spigots1037793spigots
spike114922843spike__
spiked134915553spike_d
spiker124315663spike_r
spikey155411333spike_y
spiks114117473spi__ks
spile75230083spile__
spiled94621993spile_d
spillers103311703spillers
spills84717463spi_lls
spilths12356023spilths
spinals93911863spinals
spine76534423spine__
spined95423943spine_d
spinel85317333spine_l
spinet85629753spine_t
spinless10238703spinless
spinners103810863spinners
spinneys13335553spinneys
spinors939423spinors
spinous9310443spinous
spins75327983spi__ns
spintos939133spintos
spiraea9407983spiraea
spiral83715343spir_al
spirant9814293spirant
spirants1088283spirants
spirier93214073spirier
spiriest102513453spiriest
spiring103918183spiring
spirit83519923spir_it
spiroid10219823spiroid
spirt75032953spir__t
spirted103913073spirted
spirula9257703spirula
spirulas10207203spirulas
spiry105017353spir__y
spitals93011593spitals
spite75430663spite__
spited94820443spite_d
spits74429553spi__ts
spitters104113383spitters
spitzes1849183spitzes
spivs105114243spi__vs
spleens937103spleens
splicers12338113splicers
splices113914383splice_s
splines94718893spline_s
splores91910953splore_s
spodes94817433spode_s
spoilers10238633spoilers
spokes124417213spoke_s
spore75428593spore__
spored94821793spore_d
sporters103714063sporters
sports84619183spor_ts
sprags95715823sp_rags
sprats85819933sp_rats
sprays115913643sp_rays
spread9312533sp_read
spreads1039763sp_reads
spree74830863sp_re_e
sprent84522383sp_rent
sprier84119063sprie_r
spriest92718643spriest
sprigs94814773sp_rigs
springs104415923springs
sprints94113773sprints
sprites94220333sprites
sprits85122533sp_rits
sprues84515763sp_rues
sprugs94010173sp_rugs
spues75025383sp_ue_s
spumes1021314883spume_s
spurges104111653spurges
spurners10288493spurners
spurns84811383spur_ns
spurrers10338463spurrers
spurreys13364603spurreys
spurs74621523spur__s
spurters103311703spurters
spurts84814973spur_ts
squires163812843squire_s
squirms18376343squir_ms
starers74522313starers
stares66038753stare_s
starets73515923starets
stems75219953s__tems
stereos74314973stereos
steres63929533stere_s
sties55132983sti_e_s
stiles64328773stile_s
stimes85920573stime_s
stipels9418953stipels
stipes84524053stipe_s
stirks104914243stir_ks
stirpes95011293stirpes
stirps85011823stir_ps
stirrers8266943stirrers
stirs55921623stir__s
stivers103613543stivers
storers75018683storers
stores65533663store_s
storeys10559653storeys
storms85814633stor_ms
streams94713373s_treams
streps86218063s_treps
stress66616673s_tress
strews96817103s_trews
strums84716453s_trums
subitems1245493subitems
sucres84218893sucre_s
suiters73618883suiters
suites63727403suite_s
supines94216383supine_s
suppress1236443suppress
supreme1137893supreme
supremes1238363supremes
supremo1145723supremo
supremos1245813supremos
surreys10489443surreys
suspires1038203suspire_s
swarms116112173swar_ms
swims105514143swi__ms
swipes114114333swipe_s
swirls94010133swir_ls
swivels13396773swivels
swives123915183swive_s
swivets13436963swivets
syrens94911993s_yrens
systems1234683systems
thirams1236823thirams
tires55437493_tire_s
trireme935263trireme
triremes1035523triremes
umpires1137813umpire_s
vireos94212453_vireos
vires84529683_vire_s
wirers94617893_wirers
wires86034913_wire_s
zaires1539703zaire_s
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 Limit1340274256.73619897.1
3Display Results4254250.1403035.7
 (SQL Overall)1786914257.28224538.7
 
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.