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 “bracelets” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
bracelets134596(None) 
bracelet12310691bracelet_
bractlets1344751bractlets
brachets154311982brac_hets
brackets163310432brac_kets
bractless1335542bractless
bractlet1239282bractlet_
brakeless1544992brakeless
branchlets1743802branchlets
graceless12226892graceless
traceless11228642traceless
backless162910633b_ackless
backsets1638853b_acksets
ballets93719513b_a_llets
baseless1099563b_aseless
blacklegs1843913blacklegs
bladeless1234303bladeless
blameless1334733blameless
brabblers12335563brabblers
brabbles11349753brabble_s
braceros12397723brace_ros
bracers114616703brac__ers
braces108427773brac__e_s
braches144621223brac_he_s
brachet144020313brac_het_
bracioles1346493braciole_s
brackens16327923brac_kens
bracket154117233brac_ket_
bracteoles1443413bracteole_s
bracts105617773brac___ts
braillers1135553braillers
brailles1039493braille_s
brainless1136403brainless
braless92910563bra__less
brambles14308973bramble_s
branchless1743303branchless
branchlet1647183branchlet_
brandless1236123brandless
brattles10199333brattle_s
braveness14237763braveness
brawlers13408643bra_wlers
brevets12519393br__evets
brickles162810283brickle_s
bricoles122610303bricole_s
brineless1136243brineless
brockets16328123broc_kets
brooklets1543683brooklets
brucellas1343283brucellas
capelets1268603_capelets
crackles164111273crackle_s
craterlets1243503craterlets
drupelets1242683drupelets
faceless13269173_faceless
frameless1435533frameless
graciles112511613gracile_s
grackles15309183grackle_s
gradeless11236703gradeless
grateless10277583grateless
graveless13226693graveless
laceless10239853_laceless
lancelets1144833lancelets
oracles93212423orac_le_s
placeless1335613placeless
platelets1165763platelets
praelects1354353pra_elects
priceless1336883priceless
princelets1443463princelets
racemes1139093_raceme_s
rachets124516833_rac_hets
rackets134916873_rac_kets
racquets1944763_racquets
ravelers113310863_ravelers
relets64025673_r__elets
sarcenets1146953sarcenets
spaceless1335733spaceless
tercelets1144813tercelets
trachles13311753trachle_s
trackless15246723trackless
travelers12266773travelers
truceless11235393truceless
wavelets1436153_wavelets

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 Filter1786911486410.420425454.8
2DLD Change Limit148641817.22020587.4
3Display Results81810.0332454.5
 (SQL Overall)178691817.67323288.3
 
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.