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

91 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
commendable205434(None) 
commandable2053291commandable
commendably2353661commendably
compensable1955192compensable
recommendable2271932recommendable
amendable1446053__amendable
combinable1844723combin_able
commendam1544953commenda__m
commendams1644303commenda_ms
commensal1546013commensa_l_
commensally2054783commensally
commensals1645663commensa_ls
commensurable2162293commensurable
commentate16108173commenta_te
committable1953493committable
communicable2254023communicable
commutable1845343comm_utable
compellable1953373compellable
compoundable2161583compoundable
condensable16115393condensable
emendable1446233__emendable
mendable131510583___mendable
amenable1238864__amen_able
ascendable1543984_ascendable
bendable131510854___bendable
bondable13169274bo___ndable
boundable1444844bo__undable
codable12311664co____dable
coinable12311584co__in_able
collectable17104904collectable
comestible1645424co_mestible
comfortable2093644comfortable
commandant1754814commanda_nt
commandants1853374commandants
commence16149104commen___ce
commend144010184commend____
commendation1946514commendation
commendatory2253234commendatory
commended17137014commend__ed
commender16167924commend__er
commenders17137144commend_ers
commending1846634commend_ing
commends15308464commend___s
commensurably2462094commensurably
commentaries1856804commentaries
commentary1945754commenta_ry
commentated1886214commentated
commentates17107614commentates
commentator1755274commentator
commingle1645064commin__gle
commonage1645734common_a_ge
communal1446354commun_a_l_
communally1944994commun_ally
communicably2553764communicably
comparable1845604co_mparable
compassable1954214compassable
compensate1646144compensa_te
computable1855724co_mputable
concealable1755054concealable
conceivable2054994conceivable
condemnable1854054condemnable
condensible16134404condensible
condonable1545444condon_able
conferrable1845824conferrable
confessable1854854confessable
connectable1745714connectable
contestable1546894contestable
conversable1846354conversable
correctable1745234correctable
countable1348854co__untable
coverable1649104co_ve_rable
covetable1648164co_ve_table
defendable1754984_defendable
demandable1644344_demandable
dependable1645794_dependable
documentable1982514documentable
expendable2243874_expendable
extendable2043834_extendable
fermentable1844074fermentable
formidable1843484form_idable
lamentable1444204_lamentable
lendable11169464___lendable
openable1247014_o_pen_able
romeldale1272184ro_melda_le
sendable111612044___sendable
soundable1245984so__undable
spendable1446464__spendable
summonable1662954summon_able
unamenable1446944unamen_able
unbendable1545814_unbendable
vendable14159694___vendable

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.406440125.6
2DLD Change Limit148819918.54617413.9
3Display Results91910.0461978.3
 (SQL Overall)178691918.99819859.0
 
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.