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

109 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
bractlet123928(None) 
bracelet12310691bracelet
bractlets1344751bractlets
bracelets1345962bracelets
brachet144020312brac_het
bracket154117232brac_ket
bracted12410932bract_ed
bractless1335542bractless
branchlet1647182branchlet
brattle9249252brattle_
brattled11196722brattled
brattles10199332brattles
backlit15911903b_acklit
backset15314193b_ackset
ballet84733973b_a_llet
battle85217863b_attle_
battled104213123b_attled
battler94113383b_attler
battles94517683b_attles
blackleg1734233blackleg
brabble10349973brabble_
brabbled12337633brabbled
brabbler11397373brabbler
brabbles11349753brabbles
brace95629273brac__e_
braced115420603brac__ed
bracer104620583brac__er
braces108427773brac__es
braches144621223brac_hes
brachets154311983brac_hets
braciole1246973braciole_
bracioles1346493bracioles
bracken15409813brac_ken
brackets163310433brac_kets
bract96332723brac___t
bracteal1245563bracteal
bracteate1345353bracteate
bracteole1343313bracteole_
bracteoles1443413bracteoles
bracts105617773bract__s
brailed103914013bra_iled
braille939713braille_
brailled1147193brailled
brailler1036883brailler
brailles1039493brailles
bramble133710033bramble_
brambled15316733brambled
brambles14308973brambles
branchlets1743803branchlets
brattier1047663brattier
brattiest1148103brattiest
brawled133910123bra_wled
brawler124310233bra_wler
brickle15279933brickle_
brickles162810283brickles
bricole112810493bricole_
bricoles122610303bricoles
bristle91910103bristle_
bristled11187343bristled
bristles101510433bristles
brittle9168603brittle_
brittled11186093brittled
brittler10165983brittler
brittles10178653brittles
brittlest11146193brittlest
brocket154013383broc_ket
brooklet1456403brooklet
crackle153611253crackle_
crackled17428863crackled
crackles164111273crackles
flatlet10312253fla_tlet
fracted1339373fract_ed
frontlet1147653frontlet
fruitlet1146883fruitlet
gantlet83616243_gantlet
gracile102512603gracile_
graciles112511613graciles
grackle14338893grackle_
grackles15309183grackles
mantlet93620993_mantlet
martlet93419153_martlet
oracle84313293orac_le_
oracles93212423orac_les
partlet92720363_partlet
plantlet10310013plantlet
prattle9208833prattle_
prattled11246533prattled
prattler10166343prattler
prattles10189403prattles
rachet115028973_rac_het
racket125229423_rac_ket
rackle123917293_rackle_
racquet1838743_racquet
ratchet124218333_ratchet
rattle64717613_rattle_
rattled84012953_rattled
rattler74012743_rattler
rattles73217303_rattles
rootlet73015733_rootlet
tartlet72218483_tartlet
trachle12311853trachle_
trachled1438313trachled
trachles13311753trachles
tractate10411003tractate
tractile10311073tractile_
wrastle10368993wrastle_
wrastled12346433wrastled
wrastles11328933wrastles
wristlet1138643wristlet

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621097.11020557.2
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.57923577.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.