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

276 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
brattles1019933(None) 
battles94517681b_attles
brattle9249251brattle_
brattled11196721brattled
brittles10178651brittles
prattles10189401prattles
rattles73217301_rattles
battle85217862b_attle_
battled104213122b_attled
battler94113382b_attler
battlers104110972b_attlers
battues94610192b_attues
bottles94216272b_ottles
brabbles11349752brabbles
bractless1335542bractless
bractlet1239282bractlet
bractlets1344752bractlets
brailles1039492brailles
brambles14308972brambles
brattices1345552brattices
brattier1047662brattier
brattiest1148102brattiest
bristles101510432bristles
brittle9168602brittle_
brittled11186092brittled
brittler10165982brittler
brittlest11146192brittlest
prattle9208832prattle_
prattled11246532prattled
prattler10166342prattler
prattlers11195322prattlers
rattle64717612_rattle_
rattled84012952_rattled
rattler74012742_rattler
rattlers83510292_rattlers
sprattles1174882sprattles
tattles73616282_tattles
twattles1154382twattles
wattles103814072_wattles
wrastles11328932wrastles
arables91814973ara_bles
babbles104416323b_abbles
baffles153710683b_affles
bales76250083b_a__les
bangles103617413b_angles
banties94324763b_anties
barbules1238043barbules
barites94322333barit_es
barytes124611153baryt_es
bastes85330383b_ast_es
bastiles10313353bastiles
batches144019613b_atches
bates75846343b_a_t_es
bathes116524833b_a_thes
bathless13127383b_athless
batted95623653b_att_ed
batten85217123b_att_en
battens95313263b_attens
batter84928873b_att_er
batters94626013b_atters
battier93515713b_attier
battiest104115553b_attiest
battiks1337143b_attiks
batts76727563b_att__s
battue84311003b_attue_
baubles113611863b_aubles
bawties124214313b_awties
beadles103414733bea_dles
beagles103212123bea_gles
beasties102514653beasties
beatless103311593bea_tless
beauties10229523beauties
beetles9312083b_eetles
belittles1143873belittles
berates94126863bera_t_es
blasties102113623blasties
blatted104812713blatt_ed
blatter94415653blatt_er
blatters104414093blatters
boatels93510233boatel_s
borates94823013bora_t_es
bottle84916073b_ottle_
bottled104611233b_ottled
bottler94211883b_ottler
bottlers103810013b_ottlers
brabble10349973brabble_
brabbled12337633brabbled
brabbler11397373brabbler
brabblers12335563brabblers
bracelet12310693bracelet
bracelets1345963bracelets
braces108427773bra__ces
braches144621223bra_ches
bracioles1346493bracioles
bracted12410933bract_ed
bracteoles1443413bracteoles
bracts105617773bract__s
braes75735053bra___es
brailed103914013bra_iled
braille939713braille_
brailled1147193brailled
brailler1036883brailler
braillers1135553braillers
brails84621293bra_il_s
brainless1136403brainless
braises93818873bra_ises
braizes183112453bra_izes
brakeless1544993brakeless
brakes124923123bra__kes
braless92910563bra__less
bramble133710033bramble_
brambled15316733brambled
branches153613803branches
brandies11714563brandies
brandless1236123brandless
brants85723053brant__s
brashes124518463bra_shes
brasils9410973brasil_s
brasses93818353bra_sses
brassies103613533brassies
brats75336013bra_t__s
brattice1245693brattice
bratticed1443283bratticed
brattiness1255833brattiness
brattish1346973brattish
brattling1236003brattling
bratty1159683bratt__y
braves115524083bra__ves
bravoes12418533bra_voes
brawled133910123bra_wled
brawler124310233bra_wler
brawlers13408643bra_wlers
brawls115214333bra_wl_s
braxies16711463bra_xies
brazes175522193bra__zes
brazils1867753brazil_s
breathes134212903breathes
breathless1543533breathless
brickles162810283brickles
bricoles122610303bricoles
bridles104114473br_idles
brindles113710223brindles
bristle91910103bristle_
bristled11187343bristled
britches15278683britches
brittlely1442473brittlely
brittly12165973brittl_y
britts84813443britt__s
brothels13277073brothels
brutes86118683br_ut_es
burettes1048943burett_es
bustles93816323b_ustles
butles84423913b__utles
buttes84822563b_utt_es
butties93217953b_utties
cantles94721413_cantles
castles94917733_castles
catties94023053_catties
cattle85118903_cattle_
chattels13286793chattels
crackles164111273crackles
cradles103114133cra_dles
crankles143510153crankles
cratches153012543cratches
crates85736063cra_t_es
cuittles1045903cuittles
cuttles93613923_cuttles
dartles84014133_dartles
dottles83912283_dottles
drabbles13308523drabbles
draftees12225253draftees
draggles1145963draggles
dratted9358593dratt_ed
embattles1342973embattles
embrittles1452003embrittles
fatties103018203_fatties
fettles103912733_fettles
frazzles19284813frazzles
grabbles13339893grabbles
graciles112511613graciles
grackles15309183grackles
grantees92510973grantees
granules939933granules
grapples13348123grapples
grateless10277573grateless
grates75429893gra_t_es
gristles9189203gristles
grottoes9276753grottoes
gruntles9287233gruntles
guttles83011933_guttles
hantles104117513_hantles
kettles113411613_kettles
kittles113012493_kittles
lattes65324203_latt_es
littles73212783_littles
mantles94820703_mantles
mattes85624533_matt_es
mettles94115023_mettles
mottles93415803_mottles
nettles73214083_nettles
oracles93212423ora_cles
orates64328613ora_t_es
patties93425143_patties
pettles93916483_pettles
pottles93816983_pottles
prates84633163pra_t_es
pretties10615133pretties
protyles13249833protyles
rabbles113517973_rabbles
raddles93615703_raddles
raffles133611843_raffles
raggles93813283_raggles
rales54947493_ra__les
rambles113118313_rambles
rankles113114543_rankles
rassles73513923_rassles
ratables10159723_ratables
ratals64219583_ratal_s
ratches123620463_ratches
ratels64518213_ratel_s
rates55352013_ra_t_es
ratholes11312413_ratholes
ratines75328583_ratines
ratites74920683_ratites
rattans73411953_rattans
ratted74923343_ratt_ed
ratteen7329113_ratteen
ratteens8256053_ratteens
ratten64217383_ratt_en
rattens74213403_rattens
ratter64326313_ratt_er
ratters74422473_ratters
rattier74015593_rattier
rattiest83516113_rattiest
rattly94111543_rattl_y
rattons73815323_rattons
retiles74426993_retiles
retitles83612593_retitles
rootles73215633_rootles
rottes64524833_rott_es
rustles73416413_rustles
rutiles74315843_rutiles
scuttles1056503scuttles
settles73916003_settles
shuttles1136543shuttles
skatoles1236143skatoles
skittles1245763skittles
spatzles1935303spatzles
spittles1038333spittles
sprattle1054763sprattle_
sprattled1263303sprattled
startles82111963startles
tatties74120343_tatties
tattle64115653_tattle_
tattled84311483_tattled
tattler73112213_tattler
tattlers8369693_tattlers
throttles1254353throttles
tittles73413253_tittles
trachles13311753trachles
tramples122610203tramples
trestles83012553trestles
twattle1064273twattle_
twattled1273463twattled
urates65027763ura_t_es
vittles103211113_vittles
warstles11368803warstles
wattle94314213_wattle_
wattled113610503_wattled
wattless11268723_wattless
whittles1496673whittles
wrangles1237463wrangles
wrassles11376713wrassles
wrastle10368993wrastle_
wrastled12346433wrastled
wrestles113310063wrestles

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461622768.09618053.6
3Display Results2762760.1102509.1
 (SQL Overall)1786912768.35921377.1
 
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.