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

309 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
brazils186775(None) 
brails84621291bra_ils
brasils9410971brasils
brazil1779621brazil_
frazils1956121frazils
bails75933522b_a_ils
basils85717472b_asils
bezils1711310602b_ezils
braids95015692bra_ids
brail75525552bra_il_
brains85125472bra_ins
braizes183112452braizes
brasil8713862brasil_
brawls115214332bra_wls
braxies16711462braxies
brazas175812432braz_as
brazens18418712brazens
brazers184513942brazers
brazes175522192braz_es
brazier183911472brazier
braziers19397192braziers
brazilin1944382brazilin
brazilins2043962brazilins
brazing193715112brazing
broils84114172br_oils
crazies183413852crazies
crazily2136922crazily
drails74716952dra_ils
frails93716472fra_ils
frazil1847222frazil_
grails77518782gra_ils
rails55937402_ra_ils
trails64622512tra_ils
uracils939372uracils
ails45654713__a_ils
anils56326723__anils
aramids102810513aramids
archils12510533archils
argils75213623ar_gils
arils58732203__arils
avails939693ava_ils
axils127217503__axils
baals76122703b_a_als
babels105216723b_abels
babies106123653b_abies
babuls105413643b_abuls
bagels95712313b_agels
bail65042803b_a_il_
baits76630583b_a_its
baizas173810823b_aizas
baizes174315053b_aizes
balls76236413b_a_lls
bals66354043b_a__ls
barbels114514433barbels
barbies114519593barbies
barrels94514363barrels
barrios9310773barrios
basics104915123b_asics
basil75122273b_asil_
basins85722763b_asins
basis75429863b_asi_s
batiks1239373b_atiks
bawls105719323b_a_wls
bazars174613113b_azars
bazoos173212623b_azoos
beadily1378843beadily
beamily1477393beamily
beanies93821093beanies
bedrails1136293bedra_ils
benzins1838693benzins
benzols1836673benzols
benzyls2133673benzyls
bewails1277553bewails
bezels173712283b_ezels
bezil163812883b_ezil_
bharals1236733bharals
bialies93618413bialies
bialis83617163biali_s
blains84516373bla_ins
blazers184811683blazers
blazes174817353blaz_es
blazing193612393blazing
blazons1836163blazons
boatels93510233boatels
boils75427193b__oils
boozily2135623boozily
borals86721913bora__ls
brabble10349973brabble
brabbles11349753brabbles
bracers114616703bracers
braces108427773bra_ces
braches144621223braches
brachials16206943brachials
brachs134415753bra_chs
bracing123817613bracing
bracings13369293bracings
braciola1245273braciola
braciolas1345073braciolas
braciole1246973braciole
bracioles1346493bracioles
bracts105617773bra_cts
bradawls1443673bradawls
brads85528293bra__ds
braes75735053bra__es
brags85625103bra__gs
brahmas1436733brahmas
braid85822263bra_i_d
brailed103914013bra_iled
braille939713braille
brailles1039493brailles
brain76229383bra_i_n
brainily1337313brainily
brainy114815643bra_iny
braise84318753bra_ise
braises93818873braises
braize174113113bra_ize
brakes124923123bra_kes
brakier133812363brakier
brakiest143912243brakiest
braking143917713braking
braless92910563braless
bramble133710033bramble
brambles14308973brambles
brambly16296253brambly
brandies11714563brandies
brands95118943bra_nds
branks124817383bra_nks
brans75437433bra__ns
brantails1146313brantails
brants85723053bra_nts
bras65746453bra___s
brashes124518463brashes
brashly15427613brashly
brasier94516753brasier
brasiers103710513brasiers
brasilin1046963brasilin
brasilins1146243brasilins
brass75428023bra__ss
brasses93818353brasses
brassies103613533brassies
brassily1336623brassily
brats75336013bra__ts
brattle9249253brattle
brattles10199333brattles
bravas114913323bra_vas
bravely15428233bravely
bravers124715523bravers
braves115524083bra_ves
bravi104715753bravi__
braving133714613braving
bravoes12418533bravoes
bravos114711393bra_vos
brawl106217963bra_wl_
brawlie12198153brawlie
brawly144312353bra_wly
brawnily1644083brawnily
brawns115614083bra_wns
braws106425193bra__ws
brayers124511903brayers
braying134416313braying
brays106723113bra__ys
braza165214253braz__a
braze165423453braz__e
brazed184717083braz_ed
brazen174812453braz_en
brazenly2263833brazenly
brazer174917533braz_er
brazilein2041993brazilein
brazileins2141793brazileins
breezily2243653breezily
brewis11469983brewi_s
bridals1038623bridals
bries74942153br__ies
brigs85823223br__igs
brill74819953br__ill
brills84916293br_ills
brims94721623br__ims
brinies93317913brinies
brins75533973br__ins
brios74725723br__ios
bris65539613br__i_s
briss75824273br__iss
brits76433083br__its
broil74918223br_oil_
bromals1139743bromals
bromids12278603bromids
bromins112513783bromins
brucins1158003brucins
bruins86014953br_uins
bruits85714453br_uits
brulzies1933983brulzies
bulbils11338333bulbils
cavils114014393_cavils
craals84113303cra_als
crasis85020473crasi_s
crawls114712083cra_wls
crazes174720133craz_es
crazier183610743crazier
craziest19319923craziest
crazing193914583crazing
derails84216393dera_ils
diazins1739183diazins
drail65020973dra_il_
drains73719403dra_ins
drawls105511393dra_wls
emails84412343ema_ils
ervils948773er_vils
fails85631483_fa_ils
flails94313003fla_ils
fragile1147843fragile
frail85220213fra_il_
frazzle18305223frazzle
frazzles19284813frazzles
fuzils18407963_fuzils
ghazies2036913ghazies
ghazis1935203ghazi_s
glazily2035383glazily
graals74112913gra_als
gracile102512603gracile
graciles112511613graciles
gracilis11247033gracilis
gradins93416233gradins
grail64622873gra_il_
grains74223093gra_ins
gratins84119183gratins
gratis74819243grati_s
gravels113611143gravels
gravies11314093gravies
grazers175112453grazers
grazes164519643graz_es
grazier173611133grazier
graziers18387123graziers
grazing183514553grazing
grazings19337263grazings
grazioso1862793grazioso
hails85231643_ha_ils
hazels185710083_hazels
hazily2179063_hazily
jails125422943_ja_ils
jezails2334163jezails
kails95525213_ka_ils
kraals10378433kra_als
kraits104912203kra_its
lazies154418783_lazies
lazily1859713_lazily
mails76037783_ma_ils
mazily20610393_mazily
nails55730403_na_ils
nazis145216083_nazi_s
orals55826483ora__ls
orchils1277703orchils
pails75833063_pa_ils
praxis154012253praxi_s
quails153412643qua_ils
rabies85226023_rabies
racily11715173_racily
radials83614633_radials
radios74018673_radios
radius73914873_radius
ragis66325603_ragi_s
raias54631123_ra_ias
raids65827513_ra_ids
rail46147763_ra_il_
rains55140233_ra_ins
rais45252623_ra_i_s
rakis95323443_raki_s
ramies84630463_ramies
ramtils938413_ramtils
ranids75118703_ranids
ranis55235833_rani_s
rapids94913893_rapids
ratals64219583_ratals
ratels64518213_ratels
ratios64922673_ratios
ravels94717073_ravels
ravins94622563_ravins
rawins95617623_rawins
razees154314763_razees
razers154919613_razers
razes145032703_raz_es
razing164524543_razing
razors154711663_razors
razzes144910073_razzes
reoils64516873_reoils
roils54826793_r_oils
sails55738103_sa_ils
serails73318363sera_ils
snails64816653sna_ils
spails84817823spa_ils
swails94913123swa_ils
tails55634193_ta_ils
teazels16406893teazels
tragics10338083tragics
traiks104013713tra_iks
trail55126773tra_il_
trains64725343tra_ins
traits65121983tra_its
tramels93812493tramels
travails1146083travails
travels104711293travels
trawls94412393tra_wls
triazins1738353triazins
uracil8311543uracil_
uranias72113813uranias
uranyls1034453uranyls
uraris63817273urari_s
vails85825933_va_ils
vakils1337593_vakils
wails86631483_wa_ils

Search took 9 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.1561145455.1
2DLD Change Limit1340273098.65615483.7
3Display Results3093090.1062915.1
 (SQL Overall)1786913098.91820037.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.