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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
unendurable145428(None) 
unendurably1753271unendurably
endurable1247732__endurable
nondurable1346062_nondurable
uneducable1545762une_ducable
uninsurable1384972uninsurable
censurable1445653_censurable
endurably1545673__endurably
ineducable1546203ine_ducable
inenarrable1384603inenarrable
mensurable1445453_mensurable
perdurable1544753_perdurable
renderable1397153_renderable
tenurable1147423_ten_urable
unbendable1545813unbend__able
uncurable13710073u__ncurable
unenviable1545853unen_viable
unmeasurable1653853unmeasurable
amendable1446044amend__able
bendable131510854_bend__able
durable102312724____durable
educable1337084__e_ducable
emendable1446234emend__able
endorsable1344584__endorsable
endurance1245234__endurance
enterable11312644__enterable
generable1238664_gen_erable
honourable1544454_honourable
immensurable1852604immensurable
incurable131010774__incurable
inerrable11410154ine__rrable
inexcusable2253574inexcusable
inexorable1946114ine_xorable
injurable18117414__injurable
insurable111011084__insurable
kneadable1645674knead__able
lendable11169464_lend__able
measurable1444724_measurable
mendable131510584_mend__able
nonarable1149054_non_arable
nonburnable1553364_nonburnable
nonusable1146744_non_usable
penetrable1446044_penetrable
perdurably1843784_perdurably
pleasurable1552414pleasurable
ponderable1546074_ponderable
securable1347774_se_curable
sendable111612044_send__able
spendable1446464spend__able
treasurable1343614treasurable
unalterable1345774unalterable
unanswerable1753124unanswerable
unarguable1344834unargu_able
unbearable1447384un_bearable
unbudgeable1752474unbudgeable
unburnable1444574u__nburnable
uncapturable1853284uncapturable
unconquerable2672704unconquerable
uncurably1697794u__ncurably
undatable1238984u__ndatable
undeniable1348564unden__iable
undesirable1447484undesirable
undoable1139054u__nd_oable
uneatable11311694une__atable
unedible1146404une_d__ible
unelectable1546744unelectable
unendurableness1872464unendurableness
unenforceable2061604unenforceable
unescapable1754034unescapable
unexcitable2245064unexcitable
unfavorable1953714unfavorable
unfindable1644864unfind__able
unhirable1447644u__nhirable
unignorable1453404unignorable
unknowable1943504unkn_owable
unmemorable1754834unmemorable
unnamable1356604un_n_amable
unnameable1445504un_nameable
unreadable1347714unread__able
unreturnable1453644unreturnable
unridable1248294unrid__able
untenable11410504unten___able
untunable1147834u__ntunable
unusable1038954u__n_usable
unutterable1354054unutterable
unwearable1547214un_wearable
vendable14159694_vend__able
venerable1438484_ven_erable

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 Filter1786911488190.1731032896.0
2DLD Change Limit148819887.93618752.4
3Display Results88880.0631396.8
 (SQL Overall)178691888.17221866.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.