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

275 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
brattle924925(None) 
battle85217861b_attle
brattled11196721brattled
brattles10199331brattles
brittle9168601brittle
prattle9208831prattle
rattle64717611_rattle
battled104213122b_attled
battler94113382b_attler
battles94517682b_attles
battue84311002b_attue
bottle84916072b_ottle
brabble10349972brabble
bractlet1239282bractlet
braille939712braille
bramble133710032bramble
brattice1245692brattice
brattier1047662brattier
bratty1159682bratt_y
bristle91910102bristle
brittled11186092brittled
brittler10165982brittler
brittles10178652brittles
brittly12165972brittly
cattle85118902_cattle
prattled11246532prattled
prattler10166342prattler
prattles10189402prattles
rattled84012952_rattled
rattler74012742_rattler
rattles73217302_rattles
rattly94111542_rattly
sprattle1054762sprattle
tattle64115652_tattle
twattle1064272twattle
wattle94314212_wattle
wrastle10368992wrastle
arable81821003ara_ble
babble94017113b_abble
baffle14399873b_affle
bale66353843b_a__le
bangle94018953b_angle
barbule1137943barbule
barite84224813barit_e
baryte115312883baryt_e
baste74829983b_ast_e
bastile9313913bastile
bate66552423b_a_t_e
bathe105822883b_a_the
batt65053873b_att__
batted95623653b_atted
batten85217123b_atten
batter84928873b_atter
battier93515713b_attier
battik1238093b_attik
battlers104110973b_attlers
batts76727563b_att_s
battu75216613b_att_u
battues94610193b_attues
batty105422243b_att_y
bauble103813213b_auble
bawtie113812143b_awtie
beadle93314683bea_dle
beagle93612593bea_gle
beastie92412433beastie
beastly1277563beastly
beatable121612243beatable
beetle8311673b_eetle
belittle1044053belittle
berate84729023bera_t_e
bitable11312203bitable
blastie92411393blastie
blate75933783bla_t_e
blatted104812713blatted
blatter94415653blatter
boatable121610263boatable
boatel84314093boatel_
boatels93510233boatels
borate85026153bora_t_e
bottled104611233b_ottled
bottler94211883b_ottler
bottles94216273b_ottles
brabbled12337633brabbled
brabbler11397373brabbler
brabbles11349753brabbles
brace95629273bra__ce
bracelet12310693bracelet
braciole1246973braciole
bract96332723bract__
bracted12410933bracted
bracteole1343313bracteole
bractless1335543bractless
bractlets1344753bractlets
bracts105617773bract_s
brae65639113bra___e
brail75525553bra_il_
brailed103914013bra_iled
brailled1147193brailled
brailler1036883brailler
brailles1039493brailles
brails84621293bra_ils
braise84318753bra_ise
braize174113113bra_ize
brake116025343bra__ke
brambled15316733brambled
brambles14308973brambles
brambly16296253brambly
brant74742173brant__
brants85723053brant_s
brashly15427613brashly
brasil8713863brasil_
brasils9410973brasils
brassie93411523brassie
brat66055543bra_t__
brats75336013bra_t_s
bratticed1443283bratticed
brattices1345553brattices
brattiest1148103brattiest
brattish1346973brattish
brattling1236003brattling
brave104925503bra__ve
bravely15428233bravely
bravure1254393bravure
brawl106217963bra_wl_
brawled133910123bra_wled
brawler124310233bra_wler
brawlie12198153brawlie
brawls115214333bra_wls
brawly144312353bra_wly
braze165423453bra__ze
brazil1779623brazil_
brazils1867753brazils
breathe123711843breathe
brickle15279933brickle
bricole112810493bricole
bridle94115463br_idle
brindle104210103brindle
bristled11187343bristled
bristles101510433bristles
bristly12178063bristly
britt75732233britt__
brittlely1442473brittlely
brittlest11146193brittlest
britts84813443britt_s
brothel12318193brothel
brutal859383brutal_
brute75321783br_ut_e
brutely1235933brutely
burette939853burett_e
bustle84015483b_ustle
butle75023103b__utle
butte74924293b_utt_e
cantle84522153_cantle
castle84918963_castle
cattie85221023_cattie
chattel12388893chattel
crackle153611253crackle
cradle93313163cra_dle
crankle133610063crankle
crate76537403cra_t_e
cuittle946403cuittle
cuttle84113893_cuttle
dartle73714833_dartle
dottle74212503_dottle
drabble12238883drabble
draftee11379523draftee
draggle1056103draggle
dratted9358593dratted
embattle1253273embattle
embrittle1342383embrittle
fettle93713123_fettle
fragile1147843fragile
frazzle18305223frazzle
grabble12339643grabble
gracile102512603gracile
grackle14338893grackle
grantee83217133grantee
granule839473granule
grapple12378003grapple
grate64932883gra_t_e
gratine84719193gratine
gristle8169223gristle
gruntle8257053gruntle
guttle74111973_guttle
hantle94318203_hantle
irate55627983ira_t_e
irately1047683irately
kettle104311613_kettle
kittle104012173_kittle
latte55426303_latt_e
little63312163_little
mantle84420923_mantle
matte75626843_matt_e
mettle83815723_mettle
mottle84116053_mottle
nettle64514583_nettle
oracle84313293ora_cle
orate55133303ora_t_e
pattee84323383_pattee
pattie84020963_pattie
pettle84116053_pettle
pottle84416103_pottle
prate75135983pra_t_e
prattlers11195323prattlers
prebattle1343013prebattle
protyle12229453protyle
rabble103818243_rabble
rackle123917293_rackle
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rale45050563_ra__le
ramble104519973_ramble
rankle103414883_rankle
raptly11338913_raptly
rassle63813203_rassle
ratable91717553_ratable
ratal55025113_ratal_
ratals64219583_ratals
rate45458763_ra_t_e
ratel54224883_ratel_
ratels64518213_ratels
rathe85821923_ra_the
rathole10312053_rathole
ratine65131823_ratine
ratite65022423_ratite
rattan63613603_rattan
ratted74923343_ratted
ratteen7329113_ratteen
ratten64217383_ratten
ratter64326313_ratter
rattier74015593_rattier
rattlers83510293_rattlers
ratton64116123_ratton
ratty84819593_ratt_y
retile65929673_retile
retitle73913093_retitle
rootle63214453_rootle
rotte54625933_rott_e
rustle63615413_rustle
rutile65217683_rutile
scuttle936463scuttle
settle63915663_settle
shuttle1046093shuttle
skatole1135683skatole
skittle1135523skittle
spatzle1834573spatzle
spittle937923spittle
sprattled1263303sprattled
sprattles1174883sprattles
startle72511123startle
tattie64817513_tattie
tattled84311483_tattled
tattler73112213_tattler
tattles73616283_tattles
throttle1164073throttle
tittle63613323_tittle
trachle12311853trachle
tractile10311073tractile
trample11299703trample
trestle72611363trestle
twattled1273463twattled
twattles1154383twattles
urate55432163ura_t_e
vibratile1443663vibratile
vittle94711753_vittle
warstle10328013warstle
wattled113610503_wattled
wattles103814073_wattles
whittle13106103whittle
wrangle1137383wrangle
wrassle10357173wrassle
wrastled12346433wrastled
wrastles11328933wrastles
wrestle10298843wrestle

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 Limit1340272757.37618170.7
3Display Results2752750.0932957.0
 (SQL Overall)1786912757.62523434.9
 
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.