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

70 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
explainable225252(None) 
explicable2344342expl_icable
exploitable2262692exploitable
inexplainable2462212inexplainable
unexplainable2462522unexplainable
examinable2144093ex_aminable
expandable2243123exp_andable
expiable1946113exp__i_able
explicably2653823expl_icably
applaudable1851794applaudable
appliable1545054appl_i_able
applicable1844374appl_icable
attainable1243744_attainable
claimable1545704__claimable
containable1546204containable
declinable1545864decl_inable
drainable1237584__drainable
employable1943154empl_oyable
emptiable1544844emp_ti_able
esplanade12111924espla_na_de
exactable2046434ex__actable
excisable2045054ex__cisable
excitable2056244ex__citable
excludable2252544excl_udable
exercisable2252774exercisable
exilable1737204ex___ilable
expansible2153554exp_ansible
expansile1843944exp_a_nsile
expectable2345064exp_ectable
expellable2143214exp_ellable
expendable2243874exp_endable
explain1667044explain____
explained1944544explain__ed
explainer1844244explain__er
explainers1943114explain_ers
explaining2044304explain_ing
explains1766444explain___s
explanative2353104expla_native
explicate20117494expl_ica_te
exportable2144604exp_ortable
exposable2044794exp__osable
extractable2254154extractable
extraditable2253054extraditable
extricable2144744ex_tricable
gainable1138934___gainable
implacable1844614impla_cable
implantable1753334implantable
inclinable1447714incl_inable
inexplicable2553454inexpl_icable
laminable1337124___laminable
linable92214344___l_inable
obtainable1443364_obtainable
paintable1337244__p_aintable
pawnable1535984__p_awnable
placable14169244__pla_cable
placeable1536914__placeable
plantable1337274__plantable
playable15137924__pla_yable
pliable111610324__pl_i_able
reclaimable1753014reclaimable
repairable1445954rep_airable
replaceable1743224replaceable
replicable1646624repl_icable
restrainable1452804restrainable
retrainable1344354retrainable
stainable1138094__stainable
sustainable1352504sustainable
trainable1138944__trainable
unplayable1745314unpla_yable
unpliable1347814unpl_i_able

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.440406115.9
2DLD Change Limit148819707.84318974.8
3Display Results70700.0302333.3
 (SQL Overall)178691708.31321495.4
 
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.