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 “quadrant” 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
quadrant185808(None) 
quadrans1866361quadrans
quadrants1965361quadrants
quadrat1769271quadra_t
guardant1046442guardant
quadrantal2052692quadrantal
quadrantes2054572quadrantes
quadrate1888042quadrate
quadrats1866482quadrats
arrant6623253__arrant
currant9314173cu_rrant
flagrant1247633flagrant
fragrant1247113fragrant
gardant9314463_gardant
guarana886303gua_rana
guarani8106273gua_rani
guaranty1244153gua_ranty
guardants1143793guardants
hydrant1489053_hydrant
jurant134216553ju__rant
outdrank1345433outdrank
quadding2035363quadding
quadrangle2152313quadrangle
quadrated2055913quadrated
quadrates19117803quadrates
quadratic2144523quadratic
quadrating2145653quadrating
quadric1946313quadr_ic
quadrics2045653quadrics
quadriga1944073quadriga
quadroon1844473quadroon
quadroons1944183quadroons
quaint15415173qua__int
quandang1943293quandang
quant143624813qu___ant
quart144027853qua_r__t
quartan1636423quartan_
quartans1736283quartans
quartet162814893qua_rtet
quatrain1745823quatrain
quatrains1845583quatrains
quitrent1746963quitrent
radiant82817133_radiant
squadron1843503squadron_
squadrons1943253squadrons
updraft1346033_updraft
vagrant11410663_vagrant
warrant10614243_warrant

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 Filter1786911461620.420425454.8
2DLD Change Limit146162487.01620832.7
3Display Results48480.0163000.0
 (SQL Overall)178691487.45223978.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.