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

82 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
commentating195704(None) 
commenting1749172commen__ting
commutating1846022comm_utating
compensating1955002compensating
commemorating1953073commemorating
commencing1946183commen__cing
commendation1946513commendation
commendations2055803commendations
commending1846633commen__ding
commentaries1856803commentaries
commentate16108173commentat__e
commentated1886213commentat_ed
commentates17107613commentat_es
commentator1755273commentat_or
commentators1854793commentators
comminuting1844503commin_uting
committing1746683comm_it_ting
communicating2254873communicating
concentrating1856433concentrating
orientating1245773_orientating
ammoniating1644064_ammoniating
bombinating1844434bombin_ating
catenating1348684c_aten_ating
cementation1559704c_ementation
cementations1659014c_ementations
cementing1438764c_emen__ting
cocreating15310294cocre__ating
coenacting1545874co__enacting
coequating2245324co__equating
cogitating1447214co__gitating
comanaging1644324co_man_aging
combating16310164co_m__bating
combatting1755144co_mbat_ting
commanding1845924comman__ding
commendatory2253234commendatory
commensalism1764954commensalism
commentary1945754commenta__ry
commercing1955974comme__rcing
commination171111644commin_ation
comminations18810484commin_ations
commingling1952824commin_gling
commiserating2053194commiserating
communing16207864commun___ing
communising1844964commun_ising
communizing2745234commun_izing
commutation1748004comm_utation
commutations1847264comm_utations
commutative2055844comm_utative
commuting16288444comm___uting
compensation18126504compensation
compensations19136184compensations
compensative2154654compensative
competing163712464compe___ting
complicating2145634complicating
complotting18124264complot_ting
concentering1755434concentering
consecrating1747944consecrating
consenting13313214consen__ting
contacting15610074co___ntacting
contenting13313324conten__ting
conventing16311544conven__ting
cooperating1648424coope_rating
coquetting2244514coque_t_ting
corelating13511584co_re_lating
coronating13410174co_ron_ating
corotating1349324co__rotating
correlating1487084corre_lating
covenanting1743014co_venanting
criminating1646854crimin_ating
culminating1645734culmin_ating
decompensating2262524decompensating
dominating1449404do_min_ating
emendating1444614__emendating
fomentation1647714fo_mentation
fomentations1746794fo_mentations
fomenting1537234fo_men__ting
fragmentating2062424fragmentating
nominating1349504no_min_ating
pollenating1444554pollen_ating
potentiating1554284po_tentiating
reorientating1473764reorientating
tormenting1345694tormen__ting

Search took 8 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.1561145455.1
2DLD Change Limit124790827.50316632.0
3Display Results82820.0431907.0
 (SQL Overall)178691827.70223200.6
 
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.