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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

161 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
upgazed203342(None) 
upgaze1833541upgaze_
upgazes1933571upgazes
begazed2036202begazed
gazed165520332__gazed
outgazed19197732outgazed
unfazed20299052unfazed
ungated92717212ungated
unglazed1936262unglazed
unrazed172511452unrazed
updated11369422updated
upgraded13215682upgraded
uprated103213322uprated
upsized19246242upsized
agaze156113663_agaze_
amazed18519303_amazed
begaze1838333begaze_
begazes1937963begazes
blazed184314713_blazed
brazed184717083_brazed
crazed184714453_crazed
dazed165919363__dazed
deglazed2034953deglazed
engaged10379833engaged
fazed186222963__fazed
feazed195112633_feazed
gaed66031513__ga_ed
gaged85522313__gaged
gamed95126393__gamed
gaped96123533__gaped
gated75329773__gated
gaze145032413__gaze_
gazer155720073__gazer
gazes155425913__gazes
glazed174711773_glazed
grazed174115913_grazed
hazed185222203__hazed
lazed154925843__lazed
legated92513983legated
ligated92414133ligated
mazed175523873__mazed
negated93413233negated
opiated1039483opiated
outgaze17239223outgaze_
outgazes18248713outgazes
paced106931683_p_aced
paged95926783_p_aged
paled85538723_p_aled
paned85437183_p_aned
pared86946763_p_ared
pated85237843_p_ated
paved115525263_p_aved
pawed115725613_p_awed
payed115925933_p_ayed
peaced115818913_peaced
peaked136117403_peaked
pealed95322803_pealed
phased124011973_phased
placed114318003_placed
planed94420913_planed
plated95225773_plated
played124815033_played
prated94924923_prated
prayed124815433_prayed
prized184415393_prized
pugaree10208033pugaree
pugged114314523pug_ged
pupated12319353pupated
putzed18409113_putzed
razed155027983__razed
regaled93615953regaled
reglazed1935743reglazed
spaced114517253sp_aced
spaded103816753sp_aded
spaed85522273sp_a_ed
spared95427483sp_ared
spayed124213613sp_ayed
speaned103411523speaned
speared104314423speared
splayed13357813splayed
sprayed13398903sprayed
sugared938583sugared
togaed84711343toga_ed
togated94410663togated
ullaged937033ullaged
unaged83916423u_naged
unamazed2035873unamazed
unawed103914903u_nawed
unaxed144113093u_naxed
unbaked143312893unbaked
unbaled103315963unbaled
unbased103513483unbased
unbated103317733unbated
uncaged113314123uncaged
uncaked143514353uncaked
uncased104216953uncased
undated93118463undated
unfaded123111733unfaded
unfaked153211173unfaked
ungalled1078453ungalled
ungarbed12197063ungarbed
unglued937303unglued
ungraced12239143ungraced
ungraded11209923ungraded
unjaded16279143unjaded
unlaced102913733unlaced
unladed92614373unladed
unmated103317023unmated
unnamed102410273unnamed
unpaged113311043unpaged
unpaved133410053unpaved
unplaced1338613unplaced
unplayed1437263unplayed
unprized2038503unprized
unraked122914013unraked
unrated82621553unrated
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unsized172510543unsized
untamed102913223untamed
untaxed152710583untaxed
unwaxed18308393unwaxed
upases84112903up_ases
updarted1244313updarted
update93810293update_
updater10347253updater
updates10329793updates
updived1434093updived
updried11226473updried
upended11267323upended
upgather14152753upgather
upgazing2133313upgazing
upgird10103933upg_ird
upgirded1342333upgirded
upgrade11215823upgrade_
upgrades12216063upgrades
upgrew1233653upg_rew
upheaped1633643upheaped
upheaved1733763upheaved
upland938863upla_nd
upleaped1334333upleaped
uploaded1234533uploaded
upped103715163up__ped
uppiled12216593uppiled
upraised11167413upraised
uprate83916543uprate_
uprates93814863uprates
upreared1137073upreared
upscaled13144873upscaled
upsize17267303upsize_
upsizes18297163upsizes
upsoared11154353upsoared
upstaged12135243upstaged
upstared11156573upstared
uptake1236963uptake_
uptakes1336593uptakes
uptalked1533053uptalked
upwafted1742193upwafted
upward12147163upwa_rd
urged75316033urg__ed

Search took 6 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271615.65623696.4
3Display Results1611610.0463500.0
 (SQL Overall)1786911615.85830503.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.