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

149 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
unamazed203588(None) 
amazed18519312__amazed
unabated11310132unabated
unamassed1244242unamassed
unamused1135792unamused
unawaked1635902unawaked
undamaged1443422undamaged
unfazed20299052un_fazed
unglazed1936262unglazed
unmated103317022un_mated
unrazed172511452un_razed
amaze166016603__amaze_
amazes175613473__amazes
analyzed21155703analyzed
animated111612373animated
damaged1257453_damaged
enameled1136373enameled
enamored1147033enamored
endamaged1442773endamaged
mazed175523873___mazed
named85223063_nam__ed
unabashed1544103unabashed
unabraded1344893unabraded
unabused1135623unabused
unacted10312733una_cted
unadapted1344653unadapted
unadded10238523una_dded
unadmired1343863unadmired
unaged83916423un__aged
unagreed1036823unagreed
unaided92414603una_ided
unaimed102812493una_imed
unaired82916013una_ired
unalarmed1244633unalarmed
unallayed1344073unallayed
unallied938393unallied
unamended1344853unamended
unanalyzed2342493unanalyzed
unaneled939793unaneled
unarched14128553unarched
unargued1035583unargued
unarmed101811923una_rmed
unarmored1244873unarmored
unarrayed1344183unarrayed
unashamed1543543unashamed
unasked122010023una_sked
unassayed1343493unassayed
unatoned939423unatoned
unavowed1534783unavowed
unawake1445343unawake_
unawarded1444923unawarded
unaware1038033unaware_
unawares1137053unawares
unawed103914903un__awed
unaxed144113093un__axed
unbaked143312893un_baked
unbaled103315963un_baled
unbased103513483un_based
unbated103317733un_bated
unbeared111611653unbeared
unbiased1147153unbiased
unblamed1337193unblamed
unbraced132310433unbraced
unbraked15289413unbraked
uncaged113314123un_caged
uncaked143514353un_caked
uncased104216953un_cased
unclawed1457983unclawed
uncoated11314963uncoated
uncrated11416313uncrated
undamped1445333undam_ped
undated93118463un_dated
undraped1239393undraped
unerased9312773unerased
unevaded1336423unevaded
unfaded123111733un_faded
unfaked153211173un_faked
unfeared121511013unfeared
unflawed1536123unflawed
unframed1478243unframed
ungated92717213un_gated
ungraced12239143ungraced
ungraded11209923ungraded
unhealed121511073unhealed
unheated121514553unheated
unimbued1343073unimbued
unitized1839233unitized
unjaded16279143un_jaded
unjammed2033623unjam_med
unlaced102913733un_laced
unladed92614373un_laded
unleaded10411333unleaded
unleased9310713unleased
unloaded1049533unloaded
unmade92911063un_made_
unmailed11229763unmailed
unmake122811213un_make_
unmaker13279513un_maker
unmakes132810793un_makes
unmanaged1344493unmanaged
unmanned11268603unmanned
unmapped1535173unmapped
unmarked15248813unmarked
unmarred11258403unmarred
unmasked15267143unmasked
unmatted1138293unmatted
unmewed13258173un_mewed
unmined102612953un_mined
unmixed17228213un_mixed
unmoved13248903un_moved
unnamed102410273un_named
unpaged113311043un_paged
unpaved133410053un_paved
unplaced1338613unplaced
unplayed1437263unplayed
unprized2038513unprized
unraked122914013un_raked
unrated82621553un_rated
unravaged1443353unravaged
unsampled1444443unsampled
unsated83419933un_sated
unsaved113312193un_saved
unsawed112911503un_sawed
unscaled111410113unscaled
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unseized1838443unseized
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaved15157733unshaved
unsized172510543un_sized
unslaked1338463unslaked
unsmoked1536013unsmoked
unsoaked1338853unsoaked
unstated91615813unstated
unstayed12168393unstayed
unswayed15155713unswayed
untamed102913223un_tamed
untaxed152710583un_taxed
unthawed1535583unthawed
untraced112413243untraced
unwaxed18308393un_waxed
unweaned1238593unweaned
unyeaned1237743unyeaned
upgazed2033423u_pgazed

Search took 9 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.423422437.4
2DLD Change Limit1461621497.59319249.6
3Display Results1491490.0632365.1
 (SQL Overall)1786911498.07922118.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.