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

73 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
commandable205329(None) 
commendable2054341commendable
commendably2353662commendably
combinable1844723combin_able
commandant1754813commanda_nt
commandants1853373commandants
committable1953493committable
communicable2254023communicable
commutable1845343comm_utable
comparable1845603compa_rable
compassable1954213compassable
compensable1955193compensable
compoundable2161583compoundable
demandable1644343_demandable
recommendable2271933recommendable
amendable1446054__amendable
boardable1444894bo__ardable
bondable13169274bo___ndable
boundable1444844bo__undable
chantable1636894c__hantable
cleanable1345204c_lean_able
coachable1846304co__achable
codable12311664co____dable
coinable12311584co__in_able
comanage1346344co_man_a_ge
comfortable2093644comfortable
command14399214command____
commanded17136504command__ed
commandeer17124114command_eer
commandeered2051414commandeered
commandeers18123184commandeers
commander16127404command__er
commanderies1953384commanderies
commanders17146684command_ers
commandery20134254command_ery
commanding1845924command_ing
commandingly2352094commandingly
commandment1753824commandment
commando15275754command___o
commandoes17255264command_oes
commandos16245964command__os
commands15318824command___s
commendam1544954commenda__m
commendams1644304commenda_ms
commensal1546014commensa_l_
commensally2054784commensally
commensals1645664commensa_ls
commensurable2162294commensurable
commentate16108174commenta_te
commingle1645064commin__gle
commonage1645734common_a_ge
communal1446354commun_a_l_
communally1944994commun_ally
communicably2553764communicably
compactible2153654compactible
companionable2162534companionable
comparably2154394compa_rably
compatible18125574compa_tible
compellable1953374compellable
computable1855724co_mputable
condensable16115394condensable
condonable1545444condon_able
containable1546204containable
countable1348854co__untable
emendable1446234__emendable
expandable2243124_expandable
formidable1843484form_idable
loanable1037614lo__an_able
mandible1337544___mandible
mendable131510584___mendable
sandable111612824___sandable
soundable1245984so__undable
summonable1662954summon_able

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.423422437.4
2DLD Change Limit148819739.26616060.8
3Display Results73730.0461587.0
 (SQL Overall)178691739.73518355.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.