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

84 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
bruins8601495(None) 
brains85125471brains
brins75533971br_ins
brucins1158001brucins
bruin75818331bruin_
bruits85714451bruits
burins84221891burins
ruins55822031_ruins
basins85722762basins
beduins1039122beduins
begins94415302begins
berlins93216012berlins
bins66548252b__ins
blains84516372blains
bluing94914482bluing
bluings10327962bluings
boudins10311312boudins
bourns84114062bourns
braids95015692braids
brails84621292brails
brain76229382brain_
brainy114815642brainy
brans75437432br_ans
brawns115614082brawns
brens75823362br_ens
bries74942152br_ies
brigs85823222br_igs
brims94721622br_ims
brin67038192br_in_
brine75132272br_ine
brines85028852br_ines
bring85528502br_ing
brings94618432br_ings
brink116122002br_ink
brinks124616312br_inks
briny104719662br_iny
brios74725722br_ios
bris65539612br_i_s
briss75824272br_iss
brits76433082br_its
broils84114172broils
bromins112513782bromins
browns116415632browns
brucin1049132brucin_
brucine1138272brucine
brucines1237762brucines
brughs12509062brughs
bruise83412872bruise
bruises93212912bruises
bruit76126722brui_t
brumes106417072brumes
brung84613912bru_ng
brunt75728752bru_nt
brunts85215452brunts
brutes86118682brutes
bruting102612992bruting
bruts75922952bru_ts
bruxes154811022bruxes
bruxing17236822bruxing
bunns74718292b_unns
buns66243722b_u_ns
burans85019302burans
buries84633272buries
burin75626062burin_
burns74926772b_urns
drains73719402drains
druids8368092druids
fruits94512492fruits
grains74223092grains
grins65427222gr_ins
groins73917202groins
orcins83313432orcins
orpins83614162orpins
purins83722652purins
quins144819852_quins
rains55140232_rains
reins56234562_reins
rins46153192_r_ins
ruin47430512_ruin_
ruing67221052_ruing
runs46438072_ru_ns
rutins63818392_rutins
trains64725342trains
truing73913932truing

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.1101624463.6
2DLD Change Limit82551842.40634310.5
3Display Results84840.0302800.0
 (SQL Overall)178691842.54670185.0
 
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.