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

282 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
bromals113974(None) 
bromal10313651bromal_
aromas81018612aroma_s
biomass1155992biomass
borals86721912b_orals
bridals1038622bridals
broads94515152bro_ads
brogans1049662brogans
broils84114172bro_ils
bromate11313552bromate
bromates12413142bromates
bromes104719762brom_es
bromids12278602bromids
bromins112513782bromins
bromos104213312brom_os
brumal1049502brumal_
formals123312892formals
normals92510902normals
romans84620242_romans
royals93711262_royals
abnormals1342773abnormals
abomas101113583aboma_s
animals94111703animals
anomaly1238843anomaly
argals75517713ar_gals
aroma71220143aroma__
arousals866273arousals
avowals1335013avowals
baals76122703b__aals
bals66354043b___als
baobabs1044443baobabs
bemas96424283b_ema_s
bemoans1138253bemoans
benomyls1542983benomyls
bharals1236733bharals
bifocals1543703bifocals
bimahs13508303b_imahs
bimas95521743b_ima_s
binomials1343903binomials
biogas94310913bioga_s
biomes103815253biom_es
biotas84313923biota_s
bitmaps1344253bitmaps
bloats85215763blo_ats
boars75229603b_o_ars
boas66150833b_o_a_s
boats75635153b_o_ats
bogans95714813b_ogans
boils75427193b_o_ils
bolas74733763b_ola_s
bolls75531313b_o_lls
bombes124916823b_ombes
bombs115818823b_om_bs
boomers114115913boomers
booms95427123boom__s
boral75831703b_oral_
boras75938303b_ora_s
bordels103911973bordels
boreal84817213boreal_
boreas85421733borea_s
borstals1037463borstals
botas75328783b_ota_s
botels84815803b_otels
bowels114315593b_owels
bowls106121433b_o_wls
boyars115611983b_oyars
boylas113011723b_oylas
bradawls1443673bradawls
brads85528293br__ads
braes75735053br__aes
brags85625103br__ags
brahmas1436733brahma_s
brails84621293br_ails
bramble133710033bramble
brambles14308973brambles
brambly16296253brambly
brans75437433br__ans
bras65746453br__a_s
brasils9410973brasils
brass75428023br__ass
brats75336013br__ats
bravas114913323brava_s
brawls115214333br_awls
braws106425193br__aws
brays106723113br__ays
brazas175812433braza_s
brazils1867753brazils
breads95419203br_eads
breaks124816423br_eaks
breams104815043br_eams
briars84814823br_iars
bridal9511453bridal_
brills84916293br_ills
brims94721623brim__s
broach133611113bro_ach
broad84817693bro_a_d
broadly1337153broadly
brocade1238533brocade
brocades1358713brocades
brocatels1344193brocatels
brocks145214153bro_cks
brocoli1146353brocoli
brocolis1247303brocolis
brogan9311043broga_n
brogues10719823brogues
broil74918223bro_il_
brokage1436673brokage
brokages1536253brokages
brokers133111913brokers
brolly114510853bro_lly
bromated1339173bromated
brome94421973brom__e
bromelin1246343bromelin
bromelins1346463bromelins
bromic122412693brom_ic
bromid112612893brom_id
bromide12269583bromide
bromides13219363bromides
bromin102615693brom_in
bromine112915243bromine
bromines122514253bromines
bromism1337623bromism
bromisms1436403bromisms
bromize20238823bromize
bromizes21258333bromizes
bromo95217203brom__o
broncos11188073broncos
broncs101611153bro_ncs
bronzes183510403bronzes
broods95416383bro_ods
brooks125813883bro_oks
broomball1553133broomball
broomballs1652903broomballs
brooms104915873bro_oms
broos75126413bro__os
bros65635663bro___s
broses86524403bro_ses
brothels13277073brothels
broths115013923bro_ths
browns116415633bro_wns
brows105425983bro__ws
browses124712693browses
brumes106417073brum_es
brumous11107443brumous
brutal859383brutal_
bubals103513843b_ubals
bummalo1353793bummalo
bummalos1442873bummalos
burials93612083burials
buttals938503buttals
byroads1335293byro_ads
ceramals1246513ceramals
chorals124614113chorals
chromas142512693chroma_s
chromyls18244733chromyls
coals76129603_co_als
comal95125133_comal_
comas95833003_coma_s
copals105018943_copals
corals85325143_corals
cormels113813373cormels
coronals103312903coronals
corrals93713853corrals
craals84113303cr_aals
croaks125812983cro_aks
dismals102010243dismals
domal85619203_domal_
dorsals84110843dorsals
dramas95814663drama_s
drolls75312393dro_lls
dromons1038193dromons
drools74412813dro_ols
fibromas1544403fibroma_s
florals104210063florals
foals85721693_fo_als
formal113215203formal_
formats123113573formats
formols12299413formols
formyls15235703formyls
fromage1336753fromage
fromages1437073fromages
frontals1146273frontals
gimmals12225823gimmals
goals65521293_go_als
goorals838703goorals
gorals76917653_gorals
graals74112913gr_aals
gramas94317203grama_s
gremials1136133gremials
groans74815063gro_ans
groats74816653gro_ats
grovels11427813grovels
growls104711113gro_wls
hamals114816823_hamals
hammals14409223hammals
jouals1338923_jouals
kormas124511233korma_s
kraals10378433kr_aals
locals83714503_locals
mammals10389273mammals
modals93914453_modals
morals85324633_morals
mortals93914003mortals
myomas1338303myoma_s
nomads94711603_nomads
nomas74726413_noma_s
nopals84914023_nopals
normal83213533normal_
opals75718353__opals
orals55826483__orals
ordeals877993ordeals
ovals85413393__ovals
portals94015563portals
primal104014623primal_
primas104418103prima_s
proas75028803pro_a_s
prolans9314273prolans
promos105116423prom_os
prompts1337473prompts
proms95426413prom__s
propels113412843propels
propyls14308193propyls
protyls12298463protyls
prowls115511083pro_wls
ramal74622243_ramal_
ratals64219583_ratals
reals55038653_r_eals
remails94714563_remails
remans84823003_remans
remaps105012873_remaps
rials55026673_r_ials
rivals94213183_rivals
riyals94111083_riyals
roads66523623_ro_ads
roams74919613_ro_ams
roans54926443_ro_ans
roars55622243_ro_ars
robalo838933_robalo
robalos937683_robalos
roils54826793_ro_ils
rolls55326233_ro_lls
romaji1534893_romaji
romajis1635913_romajis
roman75424823_roma_n
romano84912943_romano
romanos94311483_romanos
romeos84013173_romeos
romps94617543_rom_ps
roms67038963_rom__s
rotas54827723_rota_s
rotls55620163_ro_tls
rowans95715343_rowans
rowels94515453_rowels
royal85014703_royal_
shoals94215793sho_als
skoals10438243sko_als
somans84619303_somans
somas76030373_soma_s
stomal85213313stomal_
stomas84816323stoma_s
stromal93010593stromal_
tamals84116633_tamals
tomans85419133_tomans
totals63115163_totals
tramels93812493tramels
trials64319883tr_ials
tribals9610753tribals
troaks104410603tro_aks
trocars959043trocars
trolls64613943tro_lls
trommels12254333trommels
trompes114111623trompes
tromps104911703trom_ps
tronas63816903trona_s
trotyls10236033trotyls
trowels10358363trowels
urials64415193ur_ials
urinals7610263urinals
vocals113811583_vocals
wadmals1335513wadmals
womans114613653_womans
wormils1236733wormils

Search took 7 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 Limit1340272826.39020974.5
3Display Results2822820.1102563.6
 (SQL Overall)1786912826.90625874.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.