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

(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
containable154620(None) 
obtainable1443362_obtainable
uncontainable1764172uncontainable
attainable1243743_attainable
coinable12311583co___inable
combinable1844723co_mbinable
conceivable2054993conceivable
condemnable1854053condemnable
condonable1545443con_donable
conscionable1853623conscionable
consignable1654283consignable
contaminate1556573contamina_te
contestable1546893contestable
contrastable1654433contrastable
maintainable1651723maintainable
nontaxable1943833nonta_xable
stainable1138093__stainable
sustainable1352503sustainable
unobtainable1653343unobtainable
ascertainable1761264ascertainable
claimable1545704c__laimable
cleanable1345204c_lea_nable
coachable1846304co__achable
cogitable1446944co__gitable
cognizable2443394co_gnizable
commandable2053294commandable
companionable2162534companionable
comparable1845604compa_rable
compassable1954214compassable
concealable1755054concealable
conceivably2353724conceivably
condensable16115394condensable
conditionable1863444conditionable
conferrable1845824conferrable
confessable1854854confessable
confirmable2064184confirmable
confiscable2053674confiscable
conformable2084984conformable
connectable1745714connectable
constable13311004con__stable
construable1554784construable
consumable1645564con_sumable
contain9315834contain____
contained12310894contain__ed
container11311074contain__er
containerise1453974containerise
containerize2363064containerize
containerless1562064containerless
containers1249904contain_ers
containing13410934contain_ing
containment1557444containment
contains10316534contain___s
contaminant1575844contamina_nt
contaminants1693954contaminants
contaminated1755274contaminated
contaminates1656314contaminates
contaminative2054374contaminative
contaminator1654994contaminator
continence1489134cont_inence
continual1147144cont_inual_
continually1655084cont_inually
continuance1555124cont_inuance
continuate1248334cont_inuate
continue10311124cont_in__ue
contractible1854664contractible
contradictable2162144contradictable
contrivance1854264contrivance
controllable1653074controllable
conversable1846354conversable
countable1348854count___able
cultivable1743834cult_ivable
distrainable1553634distrainable
drainable1237584__drainable
explainable2252524explainable
fontanelle1352264fonta_nelle
gainable1138934___gainable
inclinable1447714_inclinable
intuitable1247104_intuitable
ionizable2045514ion__izable
joinable1737284jo___inable
loanable1037614lo__a_nable
mentionable1554224mentionable
montadale1242854monta_da_le
nonarable1149054non_a_rable
nonburnable1553384nonburnable
noncallable1554374noncallable
nonliable1147674non_li_able
nonsalable1245664nonsa_lable
nonsinkable1753504non_sinkable
nonviable1446264non_vi_able
postponable1752964postponable
restrainable1452804restrainable
retrainable1344354retrainable
rotatable1146654ro_ta_table
tannable1039384___tannable
trainable1138944__trainable
unattainable1453394unattainable
untamable1347844_unta_mable
untenable11410504_unt_enable
unthinkable2053094_unthinkable
untunable1147834_unt_unable

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 Filter1786911488190.436409841.7
2DLD Change Limit1488191018.53317440.4
3Display Results1011010.0462195.7
 (SQL Overall)1786911019.01519821.5
 
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.