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

118 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
unstalked143552(None) 
unstacked1636431unstacked
installed1045842installed
stalked123811172__stalked
unsalted9510922uns_alted
unscaled111410112unscal_ed
unsealed91513622unseal_ed
unslaked1338462unsla_ked
unsoaked1338852unsoa_ked
unstained1038682unstained
unstamped1454602unstamped
unstarred1036362unstarred
unstated91615812unsta_ted
unstayed12168392unsta_yed
unstocked1645062unstocked
untacked15239922un_tacked
uptalked1533052u_ptalked
installer945003installer
instanced1245693instanced
instarred1043963instarred
instated91613343insta_ted
instilled1045293instilled
outtalked1445513outtalked
peptalked1842473peptalked
restacked1636483restacked
stacked143416123__stacked
staked114621943__sta_ked
staled74728103__stal_ed
stalker113912253__stalker
stalled83515683__stalled
talked114015403___talked
unasked122010023un__asked
unawaked1635903unawa_ked
unbacked17268733un_backed
unbaked143312893un_ba_ked
unbaled103315963un_bal_ed
unbraked15289413unbra_ked
uncaked143514353un_ca_ked
uncalled11810923un_called
uncasked15278453un_casked
uncracked18226803uncracked
unexalted1744333unexalted
unfaked153211173un_fa_ked
ungalled1078463un_galled
unhalved1556513un_halved
unhealed121511073unheal_ed
uninstalled1282333uninstalled
univalved1643483univalved
unmarked15248813un_marked
unmasked15267143un_masked
unpacked17268663un_packed
unraked122914013un_ra_ked
unranked1338563un_ranked
unsated83419933uns_a_ted
unsaved113312193uns_a_ved
unsawed112911503uns_a_wed
unscanned1245133unscanned
unscarred1235673unscarred
unscathed1535313unscathed
unseamed111210663unsea_med
unseared91113943unsea_red
unseated91317683unsea_ted
unsettled1055213unsettl_ed
unshackled2042243unshackled
unshaded13149263unsha_ded
unshaken15175403unsha_ken
unshamed14148053unsha_med
unshaped14148443unsha_ped
unshared121510703unsha_red
unshaved15157733unsha_ved
unshelled1336563unshelled
unskilled1444603unskilled
unsmoked1536013uns_moked
unsnagged1243123unsnagged
unsnapped1443983unsnapped
unsnarled1035743unsnarled
unsoiled92412083unsoil_ed
unsolved1237833uns_olved
unspilled1245093unspilled
unstable10313763unstable_
unstabler1145623unstabler
unstack1337373unstack__
unstacks1446043unstack_s
unstate71916213unsta_te_
unstates81314993unsta_tes
unsteadied1253853unsteadied
unsteeled1045753unsteeled
unstemmed1443303unstemmed
unstepped1444213unstepped
unstinted1038563unstinted
unstoned9311043unst_oned
unstopped1444403unstopped
unstrained1146373unstrained
unstrapped1573563unstrapped
unstriped1246303unstriped
unstudied1194283unstudied
unstuffed1642683unstuffed
unsullied1044543unsullied
unswathed1634543unswathed
unswayed15155713unswa_yed
untagged1135973un_tagged
untaken1137643un_ta_ken
untamed102913223un_ta_med
untanned9279963un_tanned
untapped1376613un_tapped
untasted92011573un_tasted
untaxed152710583un_ta_xed
unthanked1764663unthanked
untilled9710563un_tilled
untilted9610893un_tilted
untracked16228373untracked
untucked15206053un_tucked
unvalued1266313un_valued
unwalled1288653un_walled
upscaled13144873upscal_ed
upstaged12135243upsta_ged
upstared11156573upsta_red
upstarted1244213upstarted

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411187.78019105.5
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.98222386.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.