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

48 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
emblazers224370(None) 
emblazer2144561emblazer_
emblazes2135671emblaze_s
blazers184811682__blazers
embalmers1543772embalmers
emblaze2045772emblaze__
emblazed2244742emblaze_d
emblazoners2451432emblazoners
emblazons2242772emblazons
embracers15105152embracers
imblazes2144722imblaze_s
amblers115213563ambl__ers
bladers104214683__bladers
blamers115314213__blamers
blazer174414023__blazer_
blazes174817353__blaze_s
brazers184513943__brazers
elaters74420193e__laters
embalmer1444063embalmer_
embars103812883emb_a__rs
embers104116183emb___ers
embezzlers2261203embezzlers
embitters13334723embitters
emblazing2344853emblazing
emblazon2143023emblaz_on
emblazoner2351843emblazoner_
emblazonry2651273emblazonry
emblems1335043embl__ems
embodiers1443753embodiers
emborders1444573emborders
embossers1343413embossers
embowers15236453emb_owers
embraceors16112753embraceors
embracer1496463embracer_
embracery1893203embracery
embraces14128873embrace_s
empalers12226743em_palers
emplaces1438413emplace_s
emplanes1239503emplane_s
employers1644123employers
emulates10312573emulate_s
emulators1148183emulators
enslavers1243883enslavers
glazers174410043__glazers
imbalmers1543103imbalmers
imblaze2044323imblaze__
imblazed2243763imblaze_d
mazers173917093_m__azers

Search took 7 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 Limit148641486.42323142.0
3Display Results48480.0133692.3
 (SQL Overall)178691486.85626063.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.