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

103 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
bracelet1231069(None) 
bracelets1345961bracelets
bractlet1239281bractlet
brachet144020312brac_het
bracket154117232brac_ket
bractlets1344752bractlets
branchlet1647182branchlet
backlit15911903b_acklit
backset15314193b_ackset
ballet84733973b_a_llet
barreled1137843barreled
blackleg1734233blackleg
brabble10349973brabble_
brabbled12337633brabbled
brabbler11397373brabbler
brabbles11349753brabbles
brace95629273brac__e_
braced115420603brac__ed
bracer104620583brac__er
bracero11428743brace_ro
braceros12397723braceros
bracers114616703brace_rs
braces108427773brac__es
braches144621223brac_hes
brachets154311983brac_hets
braciole1246973braciole_
bracioles1346493bracioles
bracken15409813brac_ken
bracketed1855863bracketed
brackets163310433brac_kets
bract96332723brac___t
bracteate1345353bracteate
bracted12410933brac_ted
bracteole1343313bracteole_
bracteoles1443413bracteoles
bractless1335543bractless
brailed103914013bra_iled
braille939713braille_
brailled1147193brailled
brailler1036883brailler
brailles1039493brailles
brakeless1544993brakeless
brakemen1644843brakemen
bramble133710033bramble_
brambled15316733brambled
brambles14308973brambles
branchlets1743803branchlets
brattle9249253brattle_
brattled11196723brattled
brattles10199333brattles
bravely15428233bravel_y
bravest124211753brave_st
brawest123810483brawe_st
brawled133910123bra_wled
brawler124310233bra_wler
brazened20134903brazened
brevet115717333br__evet
brickle15279933brickle_
brickles162810283brickles
bricole112810493bricole_
bricoles122610303bricoles
brocket154013383broc_ket
brooklet1456403brooklet
brucella1243343brucella
capelet11517073_capelet
crackle153611253crackle_
crackled17428863crackled
crackles164111273crackles
craterlet1148413craterlet
drupelet1145663drupelet
graceless12226893graceless
gracile102512603gracile_
graciles112511613graciles
grackle14338893grackle_
grackles15309183grackles
graveled13417363graveled
lancelet1049473lancelet
oracle84313293orac_le_
oracles93212423orac_les
parceled1338343parceled
platelet10510733platelet
praelect1247533pra_elect
princelet1346533princelet
raceme1039733_raceme_
racemed1237013_racemed
racemes1139093_racemes
rachet115028973_rac_het
racket125229423_rac_ket
rackle123917293_rackle_
racquet1838743_racquet
raveled114113633_raveled
raveler104212463_raveler
relet54749823_r__elet
sarcenet10413313sarcenet
tercelet1049883tercelet
traceless11228643traceless
trachle12311853trachle_
trachled1438313trachled
trachles13311753trachles
trameled11309073trameled
traveled12349453traveled
traveler11328433traveler
wavelet13310943_wavelet

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.420425454.8
2DLD Change Limit1461621037.55019359.2
3Display Results1031030.0303433.3
 (SQL Overall)1786911038.00022336.4
 
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.