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

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

72 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
bruxes15481102(None) 
brumes106417071brumes
brutes86118681brutes
bruxed16466981bruxed
cruxes154911561cruxes
blues75127042blu_es
blumes105917792blumes
boraxes163511632boraxes
boules84925972boules
bouses84931782bouses
boxes145625072b_oxes
braces108427772braces
braes75735052br_aes
brakes124923122brakes
braves115524082braves
braxies16711462braxies
brazes175522192brazes
bredes94818472bredes
brees75632552br_ees
breves115516422breves
bribes105918532bribes
brides94423512brides
bries74942152br_ies
brines85028852brines
brises84927612brises
bromes104719762bromes
broses86524402broses
brughs12509062brughs
bruins86014952bruins
bruise83412872bruise
bruises93212912bruises
bruits85714452bruits
brume95817982brume_
brunet84419292brunet
brunets9419552brunets
brunts85215452brunts
brushes124014662brushes
brute75321782brute_
bruted95113262bruted
bruts75922952bru_ts
brux136315272brux__
bruxism1843652bruxism
buries84633272buries
burkes124421312burkes
burses84425512burses
buses75936012b_uses
butes714535872b_utes
cruces105117542cruces
crudes96218622crudes
cruses88127712cruses
drupes94912652drupes
druses75517252druses
fluxes165212932fluxes
grues65721962gru_es
grumes94415552grumes
luxes124921502_luxes
oryxes1674522oryxes
praxes156215182praxes
prexes154915952prexes
prudes94215442prudes
prunes83419062prunes
raxes124729392_raxes
rexes124526952_rexes
rubes74928412_rubes
rues46044482_ru_es
rules55234252_rules
runes55530222_runes
ruses56136582_ruses
truces84916332truces
trues54925322tru_es
tuxes124316042_tuxes
uruses63616502uruses

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551722.20337472.1
3Display Results72720.0164500.0
 (SQL Overall)178691722.57969286.9
 
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.