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 “commensurable” with Change Limit: [1] [2] [3] [4] [5] [6]

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
commensurable216229(None) 
commensurably2462091commensurably
commensurate1853022commensura_te
immensurable1852602_immensurable
incommensurable2371752incommensurable
censurable1445653c___ensurable
commendable2054343commen__dable
commensurately2361743commensurately
compensable1955193compens__able
immeasurable1852363_immeasurable
incommensurably2671633incommensurably
mensurable1445453___mensurable
nonmeasurable1762743nonmeasurable
commandable2053294comman__dable
commendably2353664commen__dably
commensal1546014commens__a_l_
commensally2054784commens__ally
commensals1645664commens__a_ls
commensuration20162984commensuration
commissural1761994commissura_l_
communicable2254024commun_icable
commutable1845344comm___utable
condensable16115394condens__able
consumable1645564co___nsumable
immeasurably2162314_immeasurably
incommensurate2081284incommensura_te
measurable1444724___measurable
unmeasurable1653854_unmeasurable
coinsurance1553205co__insurance
combinable1844725combin___able
comestible1645425co_me_s_tible
commemorate1653665comme_mora_te
commensurations21182585commensurations
commentate16108175commen__ta_te
commiserate1753895comm_isera_te
commissure1652725commissur___e
committable1953495comm__ittable
commonsensible227855commonsensible
communicably2553765commun_icably
companionable2162535companionable
comparable1845605co_m__parable
compassable1954215co_mpas_sable
compellable1953375compe__llable
compensate1646145compens__a_te
computable1855725co_m__putable
condensible16134405condens__ible
conferrable1845825confe__rrable
confessable1854855confe_s_sable
consensual1253965consensu_a_l_
consensually1753155consensu_ally
constable13311005co___ns_table
construable1554785co___nstruable
consumables1753205co___nsumables
contestable1546895conte_s_table
conversable1846355convers__able
coverable1649105co_ve___rable
demonstrable1753185_demonstrable
endurable1247735____endurable
honourable1544465ho___nourable
impenetrable1852375_impenetrable
insurable111011095____insurable
measurably1743615___measurably
mensural1046225___mensura_l_
nondurable1346095no___ndurable
pleasurable1552415__pleasurable
recommendable2271935recommen__dable
tenurable1147425___ten_urable
treasurable1343615__treasurable
unendurable1454285__unendurable
uninsurable1384975__uninsurable

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 Filter1786911247900.406440125.6
2DLD Change Limit124790708.25015126.1
3Display Results70700.0332121.2
 (SQL Overall)178691708.68920565.2
 
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.