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

101 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
unthanked176466(None) 
bethanked1943282bethanked
outthanked1842912outthanked
thanked15469152__thanked
unchanged1636282unchanged
unhanded132910182un_handed
unhanged13258832un_hanged
unranked1338562un_ranked
untacked15239922unt_acked
untanned9279962unt_anned
unthawed1535582untha_wed
untracked16228372untracked
enchanted1546553enchanted
enhanced1436623en_hanced
entranced1247393entranced
hanked144220603___hanked
outranked14247863outranked
shanked153212123__shanked
suntanned1044013sunt_anned
tanked113919293__t_anked
thacked173810203__thacked
thanker14309593__thanker
thunked15386853__thunked
unasked122010023un__asked
unawaked1635903unawa_ked
unbacked17268733un_backed
unbaked143312893un_ba_ked
unbanded123010563un_banded
unbanned11279113un_banned
unbraked15289413unbra_ked
unbranded1336363unbranded
uncaked143514353un_ca_ked
uncanned11289963un_canned
uncasked15278453un_casked
unchained1537273unchained
unchaired1536203unchaired
uncharged1636613uncharged
uncharred1536103uncharred
uncharted1538083uncharted
unchecked2144063unchecked
unchoked18257623unch_oked
uncracked18226803uncracked
unfaked153211173un_fa_ked
unhailed12219963un_hailed
unhaired12238763un_haired
unhalved1556513un_halved
unhand10410383un_han__d
unhandled1445703un_handled
unharmed1438093un_harmed
unhatted1238183un_hatted
unhinged13257473un_hinged
unhooked16286743un_hooked
unhusked1634603un_husked
unkinked12215903un_kinked
unlinked13237793un_linked
unmanned11268603un_manned
unmarked15248813un_marked
unmasked15267143un_masked
unnuanced1243413unnuanced
unpacked17268663un_packed
unplanned1244413unplanned
unplanted1236853unplanted
unraked122914013un_ra_ked
unscanned1245133unscanned
unshackled2042243unshackled
unshaded13149263unsha_ded
unshaken15175403unsha_ken
unshamed14148053unsha_med
unshaped14148443unsha_ped
unshared121510703unsha_red
unshaved15157733unsha_ved
unslaked1338463unsla_ked
unsoaked1338853unsoa_ked
unstacked1636433unstacked
unstalked1435523unstalked
untagged1135973unt_agged
untainted1038423untainted
untaken1137643unt_a_ken
untamed102913223unt_a_med
untangled1165123unt_angled
untapped1376613unt_apped
untasted92011573unt_asted
untaxed152710583unt_a_xed
untenanted1144453untenanted
untended102611153unt_ended
untented92613413unt_ented
unthink1457003unthink__
unthinks1574503unthink_s
unthroned13106223unthroned
untinged10308943unt_inged
untraced112413243untra_ced
untrained10510993untrained
untrapped14106123untrapped
untucked15206053unt_ucked
untuned82010823unt_un_ed
unturned9228563unturn_ed
untwined1237063untwin_ed
unwanted12249603un_wanted
unweaned1238593unwean_ed
unyeaned1237743unyean_ed
uptalked1533053upt_alked

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 Filter1786911486410.466383457.1
2DLD Change Limit1486411016.81321817.3
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.32524394.7
 
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.