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

98 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
commendations205580(None) 
commendation1946511commendation_
comminations18810482commin_ations
compensations19136182compensations
recommendations22113092recommendations
cementations1659013c_ementations
combinations1897923combin_ations
commemorations1953443commemorations
commendatory2253233commendat_ory
commensurations21182583commensurations
commentating1957043commentati_ng
commentators1854793commentat_ors
commination171111643commin_ation_
comminutions1894313commin_utions
communications22105753communications
communizations29126103communizations
commutations1847263comm_utations
compellations1954813compellations
compensation18126503compensation_
condensations1646273condensations
emendations1446053__emendations
fomentations1746793fo_mentations
recommendation2183223recommendation_
accommodations23202504accomm_odations
alimentations1594994alimentations
ammoniations1645414_ammoniations
augmentations1654124augmentations
bombinations1884594bombin_ations
catenations1348364c_aten_ations
cementation1559704c_ementation_
coacervations2053874coacervations
cogenerations1655914co_generations
cognations1339594co__gn_ations
columniations1764794columniations
combination17108804combin_ation_
commemoration1853884commemoration_
commendams1644304commenda___ms
commending1846634commend__i_ng
commensalisms1873754commensalisms
commensuration20162984commensuration_
commentaries1856804commentari_es
commentates17107614commentat__es
commentator1755274commentat_o_r
commenting1749174commen__ti_ng
comminution17105014commin_ution_
commiserations2053454commiserations
commotions1686844comm___otions
communication21106214communication_
communions1656184commun___ions
communization28116684communization_
commutation1748004comm_utation_
compellation1855104compellation_
compendious1853374compend__ious
compensating1955004compensati_ng
compensational2073524compensational
compensators1854374compensat_ors
competitions1845534compe_titions
compilations1848684co_mpilations
complexations26134014complexations
complications2147434complications
compunctions20145694compun_ctions
compurgations20123894compurgations
computations1848124co_mputations
conations111318904co___n_ations
concentrations1877074concentrations
condemnations1845404condemnations
condensation1546784condensation_
conditions13410104co___nditions
condonations1548004condon_ations
congelations1549734conge_lations
connations12312944co___nnations
consecrations1749214consecrations
conservations1849094conservations
contentions13412094conten__tions
contestations1547734contestations
continuations1547144continuations
conventions16410534conven__tions
conversations1847454conversations
cooperations1659194coope_rations
coronations13410704co_ron_ations
correlations1447864corre_lations
crenations12511694c__ren_ations
criminations1648064crimin_ations
culminations1646534culmin_ations
decompensations22103044decompensations
documentations19144484documentations
dominations14611044do_min_ations
emendation1346554__emendation_
fermentations1856274fermentations
fomentation1647714fo_mentation_
foundations1543434fo__undations
lamentations1495984_lamentations
mentations12312584___mentations
nominations13410534no_min_ations
orientations1246914_orientations
ostentations1246124_ostentations
pigmentations1854094pigmentations
segmentations1655594segmentations

Search took 6 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 Filter178691950240.360496363.9
2DLD Change Limit95024984.64020479.3
3Display Results98980.0631555.6
 (SQL Overall)178691985.06335293.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.