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

84 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
discernable165445(None) 
discernible1653361discernible
discardable1753462discardable
discernibly1952732discernibly
disenable1249672dis_e_nable
discarnate1346043discarna_te
discountable1753853discountable
discoverable20113303discover_able
discussable1653553discussable
disenabled1444913dis_e_nabled
disenables1346233dis_e_nables
dispensable1654983dispensable
dispersible1654403dispersible
indiscernible1881933indiscernible
listenable1243653liste_nable
miserable1349653mis_er_able
answerable1544154answer_able
ascendable1543984_ascendable
cisternae11265094cisterna__e
cisternal11325744cisterna_l_
danceable1445304dance__able
deceivable1845024d_eceivable
declinable1545864d_eclinable
deferrable1644854d_eferrable
descendible1752724descendible
describable1853014describable
desirable1249394des_ir_able
deterrable1345724d_eterrable
disable10516434dis____able
disagreeable1662164disagreeable
disavowable2052514disavowable
discern1038494discern____
discerned1347864discern__ed
discerner1246944discern__er
discerners1345704discern_ers
discerning1447864discern_ing
discerningly1952954discerningly
discernment16116124discernment
discerns1138164discern___s
dischargeable2261674dischargeable
disciplinable2072814disciplinable
discordance1753964discordance
discreditable1962324discreditable
discriminable2063014discriminable
discussible1653384discussible
dislikable1744324dis_likable
dislikeable1852314dislikeable
dispersal1246004dispersa_l_
dispersals1345114dispersa_ls
displayable1953134displayable
disposable1545874dis_posable
disprovable1953464disprovable
disputable1545064dis_putable
disreputable1752764disreputable
dissemble1445804disse__mble
dissertate1145984disserta_te
dissociable1653974dissociable
dissolvable1753144dissolvable
dissyllable1753164dissyllable
distensible1454294distensible
distrainable1553634distrainable
disyllable1644294dis_yllable
filterable1543724filter_able
fissionable1653334fissionable
governable1643634_governable
inclinable1447714_inclinable
incunable13108744_inc_unable
incurable131010774_incur_able
inerrable11410164_i_nerrable
inferable14411274_infer_able
lacerable1346944_lacer_able
licensable1443074li_censable
lienable10188694li__e_nable
miserables1445614mis_er_ables
miserably1646664mis_er_ably
observable1743344obs_ervable
pilferable1742874pilfer_able
reservable1546374res_ervable
scannable1345644__scannable
screenable1443704__screenable
screwable1644844__screwable
servable13310094__s_ervable
visceral1344674viscer_a_l_
viscerally1853394viscer_ally

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.453394461.4
2DLD Change Limit148819848.86016796.7
3Display Results84840.0302800.0
 (SQL Overall)178691849.34319125.7
 
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.