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

77 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
unshaken1517540(None) 
unshapen13155441unshapen
unshaven14154881unshaven
shaken134113612__shaken
unshaded13149262unshaded
unshamed14148052unshamed
unshaped14148442unshaped
unshared121510702unshared
unshaved15157732unshaved
unslaked1338462unslaked
unsoaked1338852unsoaked
unspoken1454242unspoken
untaken1137642un_taken
mistaken14147833mistaken
reshaven1435193reshaven
shake124726403__shake_
shaker134319463__shaker
shakes135024593__shakes
shapen114414653__shapen
shaven124213303__shaven
sunshade1244353sunshade_
sunshades1344153sunshades
unakin10310963un__akin
unashamed1543543unashamed
unawake1445343unawake_
unawaked1635903unawaked
unbaked143312893un_baked
unbeaten1038013unbeaten
unbrake13239123unbrake_
unbraked15289413unbraked
unbrakes14258413unbrakes
unbroken14235073unbroken
uncake122813523un_cake_
uncaked143514353un_caked
uncakes133012743un_cakes
unchain1238943uncha_in
unchoke16248193unchoke_
unchoked18257623unchoked
unchokes17227273unchokes
unchosen1356283unchosen
uneaten7412543un_eaten
unfaked153211173un_faked
unladen8248653un_laden
unmake122811213un_make_
unmaker13279513un_maker
unmakes132810793un_makes
unraked122914013un_raked
unsafe9310693uns_afe_
unsated83419933uns_ated
unsaved113312193uns_aved
unsawed112911503uns_awed
unsawn9317463uns_a_wn
unscaled111410113unscaled
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unseen62012623uns__een
unshackle1842763unshackle
unshackled2042243unshackled
unshackles1941993unshackles
unshapely1742823unshapely
unsharp1235543unsha_rp
unshed10313773unsh__ed
unshorn1036943unsh_orn
unsicker1435303unsicker
unsmoked1536013unsmoked
unspoke1336573unspoke_
unstacked1636433unstacked
unstalked1435523unstalked
unstate71916213unstate_
unstated91615813unstated
unstates81314993unstates
unstayed12168393unstayed
unswayed15155713unswayed
unthanked1764663unthanked
unthawed1535583unthawed

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.406440125.6
2DLD Change Limit146162776.98320931.1
3Display Results77770.0332333.3
 (SQL Overall)178691777.42224075.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.