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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
contending144912(None) 
contenting13313321contenting
coattending1543542coattending
coextending2252912coextending
commending1846632commending
conceding1559342conce_ding
condensing1447742condensing
consenting13313222consenting
contemning1577062contemning
contesting13312212contesting
continuing1348192continuing
convening15311202conven_ing
conventing16311542conventing
intending1139982_intending
nonending1138002non_ending
portending1446192portending
attending11136373_attending
bartending1444913bartending
cantering122417383cante_ring
cantoning12310883canton_ing
centering122915143cente_ring
cofounding1743673cofounding
coheading1636623co_heading
cointerring1447153cointerring
coinventing1744543coinventing
coleading1338523co_leading
commanding1845923commanding
commencing1946183commencing
commenting1749173commenting
concealing1549303concealing
conceiting15311773conceiting
conceiving1846773conceiving
concerning1548903concerning
concerting15313893concerting
concluding1644913concluding
condemning1665743condemning
condoning1339783condon_ing
confecting18310553confecting
conferring1648743conferring
confessing1647183confessing
confiding1638333con_fiding
confining1539993confin_ing
confounding1843263confounding
congealing1447633congealing
congeeing1337903conge_eing
congesting14410113congesting
connecting15310383connecting
conning103718763con__n_ing
conserving1639763conserving
contacting15610073contacting
containing13410933containing
contend103511893contend___
contended1339273contend_ed
contender1239563contend_er
contenders1348623contenders
contends112810573contend__s
contention12412223contention
contentions13412093contentions
contorting13410103contorting
contouring1347013contouring
contriving1648193contriving
contusing1239143cont_using
convecting18310433convecting
converging1758093converging
conversing16310543conversing
converting16313133converting
conveying1838323conve_ying
convincing1845343convincing
cottoning1237343cotton_ing
countering13314473counte_ring
cozening20188323co_zen_ing
distending1348333distending
downtrending1851383downtrending
extending1835853_extending
forfending1844183forfending
goaltending1451993goaltending
mistending1447953mistending
nonbinding1444903nonbinding
nonbonding1445033nonbonding
nonreading1246883nonreading
obtunding1354243_obtunding
offending1744093_offending
pretending1438613pretending
protending1446813protending
sentencing1345403sentencing
softening1365493soften_ing
subtending1445103subtending
tending94419163___tending
unbending1337463_unbending
unending10239943_un_ending

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 Filter1786911406030.470380193.6
2DLD Change Limit140603907.28019313.6
3Display Results90900.0461956.5
 (SQL Overall)178691907.79622920.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.