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

99 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
unstamped145460(None) 
restamped1444432restamped
stamped124812812__stamped
unclamped1664502unclamped
undamped1445332un_damped
unsampled1444442uns_ampled
unseamed111210662unseam_ed
unshamed14148052unsham_ed
unshaped14148442unsha_ped
unsnapped1443982unsnapped
unstacked1636432unstacked
unstained1038682unstained
unstalked1435522unstalked
unstarred1036362unstarred
unstated91615812unsta_ted
unstayed12168392unsta_yed
unstemmed1443302unstemmed
unstepped1444212unstepped
unstopped1444402unstopped
unstrapped1573562unstrapped
unstriped1246302unstriped
untamed102913222un_tam_ed
untapped1376612un_tapped
encamped1535023en_camped
handstamped2051583handstamped
installed1045853installed
instanced1245703instanced
instarred1043963instarred
instated91613343insta_ted
misstamped1742903misstamped
prestamped1742963prestamped
scamped144711963__scamped
stampede13326163__stampede
stamper113714403__stamper
stomped124110533__stomped
stumped124210153__stumped
swamped15498443__swamped
tamped114317043___tamped
unashamed1543543unasham_ed
unblamed1337193unblam_ed
uncapped1556693un_capped
unclasped1465503unclasped
undraped1239393undra_ped
unexampled2241693unexampled
unflapped1743093unflapped
unframed1478243unfram_ed
unjammed2033623un_jammed
unmapped1535173un_mapped
unnamed102410273un_nam_ed
unsalted9510923uns_alted
unsated83419933uns_a_ted
unsaved113312193uns_a_ved
unsawed112911503uns_a_wed
unscaled111410113unsca_led
unscanned1245133unscanned
unscarred1235673unscarred
unscathed1535313unscathed
unsealed91513623unsea_led
unseared91113943unsea_red
unseated91317683unsea_ted
unshaded13149263unsha_ded
unshapen13155443unsha_pen
unshared121510703unsha_red
unshaved15157733unsha_ved
unshipped1743863unshipped
unslaked1338463unsla_ked
unsnagged1243123unsnagged
unsnarled1035743unsnarled
unsoaked1338853unsoa_ked
unstable10313763unstable_
unstabler1145623unstabler
unstate71916213unsta_te_
unstates81314993unsta_tes
unsteadied1253853unsteadied
unsteeled1045763unsteeled
unstinted1038563unstinted
unstocked1645063unstocked
unstoned9311043unst_oned
unstopper1343523unstopper
unstrained1146373unstrained
unstudied1194283unstudied
unstuffed1642683unstuffed
unswathed1634543unswathed
unswayed15155713unswa_yed
untacked15239923un_tacked
untagged1135973un_tagged
untame82513603un_tam_e_
untanned9279963un_tanned
untasted92011573un_tasted
untaxed152710583un_ta_xed
untimed102713373un_tim_ed
untipped1335763un_tipped
untrapped14106123untrapped
unwarped1436873un_warped
unwrapped1784133unwrapped
upstaged12135243upsta_ged
upstared11156573upsta_red
upstarted1244213upstarted
upstepped1341943upstepped

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.453394461.4
2DLD Change Limit148641998.31317880.5
3Display Results99990.0462152.2
 (SQL Overall)178691998.81220278.1
 
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.