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 “unmentionable” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
unmentionable175367(None) 
unmentionables1872001unmentionables
mentionable1554222__mentionable
unquestionable2562743unquestionable
exceptionable2682374exceptionable
intentional11128844intentiona_l_
intentionally1655984intentionally
objectionable26131974objectionable
pensionable1554054__pensionable
questionable2352744_questionable
unconscionable2082694unconscionable
uncontainable1764174uncontainable
undefinable1746384unde_fi_nable
undeniable1348564unden_i__able
unemotional1353494unemotiona_l_
unemotionally1853764unemotionally
unenviable1545854un_envi__able
unexceptionable2881884unexceptionable
unfashionable21102434unfashionable
unidentifiable2061684unidentifiable
unmemorable1754834unme__morable
unobjectionable2871734unobjectionable
unquestionably2862834unquestionably
unreasonable1454734unre_asonable
unreturnable1453644unre_turnable
unseasonable1454264unse_asonable
actionable14116215___actionable
apportionable1962205apportionable
attentional1154205attentiona_l_
companionable2162535companionable
conditionable1863445conditionable
conventional1757165conventiona_l_
conventionally2254975conventionally
detonable1247625__de_t_onable
dimensional1453045dimensiona_l_
dimensionally1962355dimensionally
exceptionably2972575exceptionably
identifiable1882145_identifiable
indeclinable1794845indecli_nable
indefinable1756355inde_fi_nable
inestimable1555795in_esti_mable
insertional1147465insertiona_l_
intensional11146565intensiona_l_
intensionally1654395intensionally
interminable1656895intermi_nable
jettisonable2161195__jettisonable
lamentable1444205lament___able
objectionably29132225objectionably
questionably2652915_questionably
sanctionable1652565_sanctionable
unalienable1345345un__alienable
unamenable1446945uname____nable
unattainable1453395un_attainable
unbeatable1447835unbeat___able
unbelievable1952845unbe_lievable
unbendable1545815unben___dable
unconscionably2382365unconscionably
uncontrollable18172165uncontrollable
uncultivable1953145unculti_vable
undecidable1745725unde_ci_dable
undeniably1646495unden_i__ably
undesirable1447485unde_si_rable
undetectable1754575unde_tectable
uneatable11311695un_eat___able
unemployable2152595un_employable
unendurable1454285un_en_durable
unexceptionably3171885unexceptionably
unexcitable2245065un_exci_table
unfashionably2482195unfashionably
unfathomable2261935un_fathomable
unignorable1453405unign__orable
unimaginable1753075unimagi_nable
unintentional1363425unintentiona_l_
unintentionally1872745unintentionally
unjustifiable2562185unjustifiable
unknowable1943515un_kn__owable
unlearnable1344975unle__arnable
unlistenable1453025unlist_enable
unmanageable1752905unman_ageable
unmatchable2063515unm_at_chable
unmeasurable1653855unme_asurable
unmemorably2053805unme__morably
unmistakable2052045unmist_akable
unmixable2045865unm___i_xable
unmovable1645965unm____ovable
unnegotiable1552605unnegoti__able
unnoticeable1652875un_noticeable
unobtainable1653345un_obtainable
unpardonable1752995un_pardonable
unquantifiable2871345unquantifiable
unrealizable2354305unreali_zable
unreasonably1753895unre_asonably
unreliable1248485unre_li__able
unremovable1854565unre__movable
unreviewable2052605unre_viewable
unseasonably1753445unse_asonably
unsensational1353665unsensationa_l_
unserviceable2062075unserviceable
unsustainable1562295unsustainable
untenable11410505u___nt_enable
untestable1248825untest___able
untillable1245985u___ntillable
untunable1147835u___nt_unable
unverifiable2053285unve_rifiable
unwinnable1544095u___nwinnable

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit1247901059.20313559.7
3Display Results1051050.0631666.7
 (SQL Overall)1786911059.67218475.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.