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

384 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
stroma8431307(None) 
stoma75918271st_oma
stromal93010581stromal
struma84313271struma
aroma71220142_aroma
chroma132912472chroma
osteoma945422osteoma
sarcoma1147402sarcoma
scrota8310182scrota
serosa6313022serosa
soma65635292s__oma
stemma10328132stemma
stigma9226752stigma
stoa45425912st_o_a
stomal85213312st_omal
stomas84816322st_omas
stomp95616662st_omp
storm76520372storm_
storms85814612storms
stormy115510722stormy
strata63616282strata
stream84717282stream
stria55723202str_ia
strobe84513812strobe
strode75215972strode
stroke105116172stroke
stroll6311602stroll
stromata1047592stromata
strong74914882strong
strook10410302strook
strop77422242stro_p
strops86220382strops
stroud7310382stroud
strove95014792strove
strow88920572stro_w
strown96812092strown
strows96718272strows
stroy87720392stro_y
stroys95914602stroys
strum75619442strum_
strumae9368092strumae
strumas9419832strumas
strums84716452strums
tromp95815802_tromp
trona54118952_trona
tryma1037222_tryma
aboma91114603_aboma
acromia1139963acromia
aromas81018613_aromas
arroba898663arroba
asrama839193asrama
asthma11126563ast_hma
atheroma1354873atheroma
atma68121773at__ma
atom67824523at_om_
atoms76817563at_oms
atomy107415193at_omy
atria56022333atr_ia
aurora6411763aurora
bromal10313653_bromal
brome94421973_brome
bromo95217203_bromo
caeoma1039033caeoma
carom95025563carom_
caroms105619573caroms
chromas142512683chromas
chrome133214813chrome
chromo132811013chromo
chromy16309903chromy
coma87134853__coma
corona83817403corona
derma84918513der_ma
drama85117413_drama
estrone7413953estrone
estrous7712533estrous
estrum81810513estrum_
estrums9208603estrums
etyma1036583et_yma
extrema1675013extrema
fibroma1444123fibroma
from96923923_from_
glioma935953glioma
grama85620283_grama
herma105318883her_ma
karma113415003kar_ma
korma115913073kor_ma
krona93611793_krona
lipoma1046753lipoma
lordoma1056043lordoma
myoma1239273_myoma
myxoma2043943myxoma
narcoma1145823narcoma
neuroma946523neuroma
noma67529463__noma
osteomas1045323osteomas
ostomy1137823ost_omy
ostraca937823ostraca
ostraka1144833ostraka
ottoman946283ottoman
pastromi1256353pastromi
prima95019343_prima
proa66229963_pro_a
prom87631693_prom_
promo95619993_promo
proms95426403_proms
pyrola1139003pyrola
roam67132413__roam
rom59855633__rom_
roman75424823__roman
romp85926573__romp
roms67038963__roms
rota45834343__rota
samosa8510203samosa
sapota8310203sapota
sarcomas1247223sarcomas
sarod65325873saro_d
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063saro_s
satsuma943873satsuma
schema1388373schema
scleroma1274343scleroma
scoria8513483scoria
scotoma1155943scotoma
scram910621613scram_
scrams105216623scrams
scream104814243scream
scrim95419723scrim_
scrimp125110583scrimp
scrims104615933scrims
scrod85115063scro_d
scrods94111603scrods
scroll8310163scroll
scroop10299773scroop
scrotal938483scrotal
scrum95418193scrum_
scrums104614253scrums
senora63216153senora
sera46141393ser__a
seriema938403seriema
sermon8413553sermon
serosae7310243serosae
serosal7311143serosal
serosas7312663serosas
serous65023563serous
serovar1046143serovar
serow86720443sero_w
serows96016393serows
serum75223473serum_
serumal938783serumal
serums83916303serums
shrimp13478763shrimp
shroff1538493shroff
shroud1038763shroud
shrove125412223shrove
sigma84513823s_igma
sima64730783s__ima
sirra54416323sir_ra
sitcom1036893sitcom_
sitcoms1145533sitcoms
smegma1134113smegma
soba64927923s__oba
soca66330053s__oca
soda56329383s__oda
sodom8814903sodom_
sodoms989663sodoms
sodomy1276673sodomy
sofa75625603s__ofa
soja115619513s__oja
sola45541863s__ola
som59153803s__om_
soman75024903s__oman
somas76030373s__omas
some66040383s__ome
soms66239373s__oms
sora45746913s__ora
sororal7310653sororal
sorta57125413sor_ta
soya75724433s__oya
sprout8419403sprout
squama1736533squama
stadia7312143stadia
stamp95217363st_amp
stanza1537073stanza
stardom1037763stardom_
stardoms1136793stardoms
stasima955633stasima
steam76322923steam_
steams84916903steams
steamy115112373steamy
stela54019043st_ela
stella63612973stella
stem610628243st_em_
stemmas11256973stemmas
stemmy13417033stemmy
stems75219953st_ems
sterigma1144113sterigma
sterna63712763sterna
steroid81314853steroid
sterol6613323stero_l
sterols7313443sterols
stigmal10245913stigmal
stigmas10206633stigmas
stime76521793st_ime
stimy105114733st_imy
stoae55024263st_oae
stoai55417863st_oai
stoas55126023st_oas
stoat57135953st_oat
stob66724613st_o_b
stobs75718233st_obs
stock114417563st_ock
stogy95414083st_ogy
stoic7317243st_oic
stoke94922513st_oke
stole54928813st_ole
stomach1436033st_omach
stomata938533st_omata
stomate9313123st_omate
stomps105612833st_omps
stone55431183st_one
stony85818643st_ony
stood65517713st_ood
stooge73811663stooge
stook95218213st_ook
stooks105115373stooks
stool55619893st_ool
stools65117023stools
stoop75821543st_oop
stoops85917893stoops
stop66532033st_o_p
stope74727243st_ope
stops74827283st_ops
stopt76528353st_opt
storax1389783storax
store56333813st_ore
stored75524213stored
storer64721673storer
stores65533643stores
storey95217613storey
stork96819693st_ork
storks106115933storks
stormed1039043stormed
story86723033st_ory
stoss54316343st_oss
stot46347323st_o_t
stots54828543st_ots
stott56929783st_ott
stoup75517073st_oup
stour54916743st_our
stout57434053st_out
stove85220253st_ove
stow77325743st_o_w
stowp105614233st_owp
stows86622703st_ows
strafe95215973strafe
strain64919573strain
strait64025893strait
strake104017393strake
stramash1344553stramash
strand74514823strand
strang75718313strang
strap77925263str_ap
straps87721783straps
strass67117223strass
stratal72710603stratal
stratas73013573stratas
strath93216363strath
strati63518893strati
straw813321293str_aw
straws98718673straws
strawy1210312823strawy
stray88525573str_ay
strays96417933strays
streak104613623streak
streams94713373streams
streamy12509483streamy
streek104111413streek
streel64214023streel
street64125773street
strep77120853str_ep
streps86218063streps
stress66616673stress
stretta737293stretta
strew89220653str_ew
strewn96710003strewn
strews96817093strews
striae65422273striae
striata7379953striata
strick124813203strick
strict84821043strict
stride75420963stride
strife95318363strife
strike105619733strike
string75327563string
strip77524333str_ip
stripe85822443stripe
strips85719653strips
stript85222193stript
stripy115812743stripy
strive95020963strive
strobes93813263strobes
strobic1138243strobic
strobil936953strobil
strobila1044933strobila
stroked124613623stroked
stroker114113513stroker
strokes114316323strokes
strolls739183strolls
stromatic13410193stromatic
strongman1243733strongman
strontia845843strontia
strophe1239133strophe
stroppy14205093stroppy
strouds837793strouds
strowed115312143strowed
stroyed114110863stroyed
stroyer103510773stroyer
struck12489263struck
strung75213023strung
strunt64918913strunt
strut56030733str_ut
struts65616803struts
stum65526013st_um_
stump94616463st_ump
stums75320083st_ums
stupa74112313st_upa
stymy13358293st_ymy
summa94713313s_umma
sura45740293sur__a
surfman1236203surfman
surimi839103surimi
surra55521343sur_ra
sutra54217933sutr__a
tarama8412723tarama
toea46732333_t_oea
toga57027413_t_oga
tola45236333_t_ola
tom514358053_t_om_
toman75724053_t_oman
tomb89029653_t_omb
tome67543193_t_ome
toms68343493_t_oms
toom66532933_toom_
tora47545993_t_ora
torta55925353_torta
tram67034553_tram_
tramp96319773_tramp
trams75327673_trams
trauma838803_trauma
trim65329513_trim_
trims75021473_trims
tritoma948043_tritoma
troak95213573_troak
trocar848763_trocar
trock114817603_trock
trod57627953_tro_d
trode65322853_trode
trog57628213_tro_g
trogs67022603_trogs
troika1035493_troika
trois57226093_trois
troke94821053_troke
troll54416533_troll
trompe105611263_trompe
tromps104911703_tromps
tronas63816893_tronas
trone55131863_trone
troop76417533_troop
trooz145016153_trooz
trop66833303_tro_p
trope75725803_trope
trot46351313_tro_t
troth85622203_troth
trots56629943_trots
trout57332573_trout
trove85221923_trove
trow78031423_tro_w
trows88826183_trows
troy77429683_tro_y
troys86418613_troys
trump95615123_trump
zygoma2143493zygoma

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127163844.81323419.1
3Display Results3843840.1233122.0
 (SQL Overall)1786913845.07935182.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.