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 “compassable” 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
compassable195421(None) 
comparable1845602compa_rable
compensable1955192compensable
impassable1645252_impassable
amassable1346063_am_assable
classable1347143c__lassable
commandable2053293commandable
compactible2153653compactible
comparably2154393compa_rably
compatible18125573compa_tible
compellable1953373compellable
compressible2054063compressible
computable1855723comp_utable
confessable1854853confessable
impassably1954353_impassably
impassible1655203_impassible
passable12310633___passable
surpassable1552123surpassable
unpassable1446133_unpassable
cascable141510624c___ascable
cashable15159794c___ashable
castable121613974c___astable
causable1239974c___ausable
chaseable1646344c__haseable
coachable1846304co__achable
collapsible1791784collapsible
combinable1844724com_binable
combustible1952864combustible
comestible1645424com_estible
comfortable2093644comfortable
commendable2054344commendable
committable1953494committable
commutable1845344com_mutable
companionable2162534companionable
compass13379564compass____
compassed1645544compass__ed
compasses1547394compass__es
compassing1746554compass_ing
compassion1645984compass_ion
compassions1745774compassions
compatibles19134144compa_tibles
compatibly21134884compa_tibly
compensate1646144compensa_te
complaisance2061834complaisance
compoundable2161584compoundable
comprisal1544514comprisa_l_
comprisals1643704comprisa_ls
condensable16115394condensable
confiscable2053674confiscable
constable13311004co__nstable
containable1546204containable
contestable1546894contestable
contrastable1654434contrastable
conversable1846354conversable
copyable1736624co_p__yable
crossable1347074c__rossable
decomposable2152344decomp_osable
embossable1652404_embossable
impalpable1843364_impalpable
impassibly1954334_impassibly
imposable1546444_imp_osable
impossible1654374_impossible
incomparable2054544incompa_rable
maskable1638004__m_askable
missable12311534__m_issable
omissible1344094_om_issible
opposable1544064_o_pposable
parsable12311694___parsable
passably1537254___passably
passible1237694___passible

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.420425454.8
2DLD Change Limit148819708.61017284.4
3Display Results70700.0332121.2
 (SQL Overall)178691709.06319716.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.