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

265 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
braille93971(None) 
brailled1147191brailled
brailler1036881brailler
brailles1039491brailles
bailee84526012b_ailee
bailie83818362b_ailie
barilla9310322barilla
brabble10349972brabble
braciole1246972braciole
brail75525552brai_l_
brailed103914012brailed
braillers1135552braillers
brails84621292brai_ls
braise84318752brai_se
braize174113112brai_ze
bramble133710032bramble
brattle9249252brattle
brawlie12198152brawlie
bridle94115462br_idle
brill74819952br_ill_
brillo84211002br_illo
brills84916292br_ills
faille93414742_faille
frailly1337312frailly
grille74315742gr_ille
rille55728732_r_ille
taille63116922_taille
aisle55223193__aisle
arable81821003ara_ble
armilla936993armilla
armillae1045563armillae
article9310923article
babble94017113b_abble
bacilli1146393bacilli
baffle14399873b_affle
bail65042803b_ai_l_
bailable1238583b_ailable
bailed94726653b_ailed
bailees93914383b_ailees
bailer85425253b_ailer
bailey115015673b_ailey
bailies94120203b_ailies
bailor83412603b_ailor
bails75933523b_ai_ls
baize164717393b_ai_ze
bale66353843b_a__le
ball66043323b_a_ll_
balled94926893b_a_lled
baller83825203b_a_ller
ballet84733973b_a_llet
balls76236413b_a_lls
bally105530103b_a_lly
bangle94018953b_angle
barbule1137943barbule
barillas10310193barillas
barite84224813bari_te
bastille1047993bastille
battle85217863b_attle
bauble103813213b_auble
beadle93314683bea_dle
beagle93612593bea_gle
belle75827833b__elle
bernicle1245443bernicle
bible95119423b__ible
bile66147183b__i_le
bilge87618913b__ilge
bill67239943b__ill_
billed94224903b__illed
biller84923483b__iller
billet86029723b__illet
billie85019173b__illie
bills75632863b__ills
billy105525363b__illy
birle75023633b__irle
boulle84614613b_oulle
brabbled12337633brabbled
brabbler11397373brabbler
brabbles11349753brabbles
brace95629273bra__ce
bracelet12310693bracelet
braciola1245273braciola
bracioles1346493bracioles
bractlet1239283bractlet
brae65639113bra___e
braid85822263brai__d
braided114013213braided
braider105112993braider
braids95015693brai_ds
brailing113514793brailing
brailling1247773brailling
braillist1146193braillist
brain76229383brai__n
brained103816103brained
brainier102510233brainier
brainily1337313brainily
brainless1136403brainless
brains85125473brai_ns
brainy114815643brai_ny
braised104014803braised
braises93818873braises
braizes183112453braizes
brake116025343bra__ke
brambled15316733brambled
brambles14308973brambles
brambly16296253brambly
brashly15427613brashly
brasil8713863brasil_
brasilin1046963brasilin
brasils9410973brasils
brassie93411523brassie
brattled11196723brattled
brattles10199333brattles
brave104925503bra__ve
bravely15428233bravely
bravure1254393bravure
brawl106217963bra_wl_
brawled133910123brawled
brawler124310233brawler
brawlier13267043brawlier
brawls115214333bra_wls
brawly144312353bra_wly
braze165423453bra__ze
brazil1779623brazil_
brazilin1944383brazilin
brazils1867753brazils
bribe94820783br_i_be
bribee104316363br_ibee
brickle15279933brickle
bricole112810493bricole
bride86425533br_i_de
bridge103711883br_idge
bridled113611143br_idled
bridler103811073br_idler
bridles104114473br_idles
brie65837903br_i__e
brillos9369183br_illos
brindle104210103brindle
brine75132273br_i_ne
bristle91910103bristle
brittle9168603brittle
broil74918223broi_l_
broiled103811423broiled
broiler92911753broiler
broils84114173broi_ls
brolly114510853br_olly
bruise83412873brui_se
canaille1048413canaille
cariole9818343cariole
crackle153611253crackle
cradle93313163cra_dle
crankle133610063crankle
dariole8711163dariole
drabble12238883drabble
draggle1056103draggle
drail65020973drai_l_
drails74716953drai_ls
drill64718263dr_ill_
drilled94711673dr_illed
driller84311883dr_iller
drills74414203dr_ills
failles102914133_failles
fille84327403__fille
fragile1147843fragile
frail85220213frai_l_
frailer10319943frailer
frails93716473frai_ls
frailty1335663frailty
fraise94214913frai_se
frazzle18305223frazzle
friable122612563friable
frill84917563fr_ill_
frilled113911603fr_illed
friller104111743fr_iller
frills94414223fr_ills
frilly124111443fr_illy
gerbille1144613gerbille
grabble12339643grabble
gracile102512603gracile
grackle14338893grackle
grail64622873grai_l_
grails77518783grai_ls
granule839473granule
grapple12378003grapple
grill64617893gr_ill_
grilled94012833gr_illed
griller84513353gr_iller
grilles83715023gr_illes
grills74314803gr_ills
grilse7399503gr_ilse
grisaille1042393grisaille
krill94213643kr_ill_
krills104211283kr_ills
maile75232223_mai_le
maill74420793_maill_
maills84215283_maills
manille92613273manille
mille75029133__mille
mouille937843mouille
oracle84313293ora_cle
orally93113593ora_lly
oriole6814293or_iole
prairie938333prairie
praise84419413prai_se
praline93019743praline
prattle9208833prattle
prill74117943pr_ill_
prilled104712993pr_illed
prills84015613pr_ills
rabble103818243_rabble
rackle123917293_rackle
raddle84816173_raddle
radiale83813523_radiale
radicle103510713_radicle
raffle123910703_raffle
raggle83712883_raggle
rail46147763_rai_l_
railed74727543_railed
railer64524933_railer
raillery1134953_raillery
rails55937403_rai_ls
raise54828053_rai_se
rale45050563_ra__le
rally84725903_ra_lly
rallye95110163_rallye
ramble104519973_ramble
ramilie9310283_ramilie
ramillie1045863_ramillie
rankle103414883_rankle
rassle63813203_rassle
rattle64717613_rattle
rifle85518333_r_ifle
rile45650533_r_i_le
rill45140903_r_ill_
rilled74525653_r_illed
rilles64725503_r_illes
rillet64828853_r_illet
rills55032713_r_ills
rocaille1045383rocaille
rouille737493rouille
spadille1145193spadille
tailles72516473_tailles
tenaille846813tenaille
trachle12311853trachle
trail55126773trai_l_
trailed83415673trailed
trailer73015393trailer
trailless935963trailless
trails64622513trai_ls
trainee72817793trainee
traipse935873traipse
trample11299703trample
triable92515393triable
trifle94012883tr_ifle
trill55122933tr_ill_
trilled84116313tr_illed
triller74215893tr_iller
trills64319853tr_ills
triple84215923tr_iple
tuille63012643_tuille
uralite71714103uralite
variole10711593variole
wrangle1137383wrangle
wrassle10357173wrassle
wrastle10368993wrastle
zorille1636673zorille

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.1561145455.1
2DLD Change Limit1340272656.81019680.9
3Display Results2652650.0962760.4
 (SQL Overall)1786912657.06225303.2
 
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.