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

59 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
overglazes237553(None) 
overglaze2286271overglaze_
overglazed2475411overglazed
overgrazes2356281overgrazes
everglades1542272everglades
overgrades1556932overgrades
overgraze2276672overgraze_
overgrazed2466002overgrazed
overlades13510352over_lades
verglases1364512_verglases
deglazes1935463_de_glazes
everglade1442563everglade_
overages12513833over__ages
overawes14511183over__awes
overbakes18129133over_bakes
overbrakes1946503overbrakes
overclaims1744683overclaims
overclass1436963overcla_ss
overclasses1644893overclasses
overdares13310673over_dares
overflies1539103overfl_ies
overglad13116533overgla__d
overglazing2545973overglazing
overgoaded1655573overgoaded
overgoads14115893overgoa_ds
overgrade1457623overgrade_
overgraded1656593overgraded
overhates15311943over_hates
overlade12611553over_lade_
overladed1459223over_laded
overladen1367643over_laden
overlands13218883over_lands
overlaps13219523over_la_ps
overlate11716283over_late_
overlays14239693over_la_ys
overlies112417043over_l_ies
overlives152210143over_lives
overloves15218673over_loves
overplaids1645433overplaids
overplans14249573overpla_ns
overplants15227333overplants
overplayed19206763overplayed
overplays17287013overpla_ys
overplies14310463overpl_ies
overpluses1545783overpluses
overprizes24107913overprizes
overrates12414623over_rates
oversales12313143over_sales
oversaves15310183over_saves
overshades1746283overshades
oversizes211111613over_sizes
overstates131110113overstates
overtakes16119823over_takes
overtaxes19118803over_taxes
overtrades1457493overtrades
overvalues1644963overvalues
reglazes1846793_re_glazes
underglazes2243903underglazes
verglas1137813_vergla__s

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 Filter1786911406030.440406115.9
2DLD Change Limit140603596.15322851.1
3Display Results59590.0331787.9
 (SQL Overall)178691596.62626968.2
 
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.