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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
contenting1331332(None) 
consenting13313211consenting
contending1449121contending
contesting13312211contesting
conventing16311541conventing
coinventing1744542coinventing
commenting1749172commenting
conceiting15311772conceiting
concerting15313892concerting
condensing1447742condensing
confecting18310552confecting
congesting14410112congesting
connecting15310382connecting
contacting15610072contacting
contemning1577062contemning
contention12412222contention
contentions13412092contentions
continuing1348192continuing
contorting13410102contorting
convecting18310432convecting
convening15311192conven_ing
converting16313132converting
bonneting1236173bonne_ting
cantering122417373cante_ring
cantoning12310883canton_ing
catenating1348683c_atenating
cementing1438763c_ementing
centering122915143cente_ring
coattending1543543coattending
coattesting1443453coattesting
cocreating15310293cocreating
coerecting15218783coerecting
coexerting2045493coexerting
coextending2252913coextending
coinfecting1944573coinfecting
cointerring1447143cointerring
collecting1548283collecting
colleting12311053colle_ting
commencing1946183commencing
commending1846633commending
competing163712463compe_ting
concatenating1853263concatenating
concealing1549303concealing
conceding1559343conce_ding
conceiving1846773conceiving
concentering1755433concentering
concerning1548903concerning
concertina14410613concertina
concertino14910843concertino
concocting1448413concocting
concreting1539873concreting
condemning1665743condemning
condoning1339783condon_ing
conducting1648833conducting
conferring1648743conferring
confessing1647183confessing
confining1539993confin_ing
conflating16410003conflating
confronting1744863confronting
confuting1539093con_futing
congealing1447633congealing
congeeing1337903conge_eing
conning103718753con__n_ing
connoting12310023con_noting
consentingly1854653consentingly
conserving1639753conserving
consisting1349523consisting
consorting13410743consorting
consternating1654973consternating
consulting1349083consulting
containing13410933containing
content94326153content___
contented12313043content_ed
contentious1347013contentious
contentment1556663contentment
contents104018213content__s
contestant1269933contestant
contouring1347013contouring
contracting16610473contracting
contrasting1459353contrasting
contriving1648193contriving
contusing1239143cont_using
convention15410563convention
conventions16410533conventions
converging1758093converging
conversing16310543conversing
conveying1838323conve_ying
convicting1847583convicting
convincing1845343convincing
coparenting1644613coparenting
coquetting2244513coquetting
correcting15199303correcting
corseting12312173corse_ting
cosseting1239543cosse_ting
cottoning1237343cotton_ing
countering13314473counte_ring
counting113115273co__unting
coveting141912303co_ve_ting
cozening20188303co_zen_ing
discontenting1755073discontenting
fomenting1537233fo_menting
incenting12912063_incenting
indenting11911263_indenting
intending1139983_intending
inventing13109973_inventing
nonbetting1345843nonbetting
nonending1138003non_ending
nonhunting1444683nonhunting
nonmeeting1346073nonmeeting
obtesting1245883_obtesting
orienting1038723_orienting
outeating10814493_outeating
patenting1248943_patenting
portending1446193portending
sentencing1345403sentencing
softening1365493soften_ing
sonneting1037003sonne_ting
sonnetting1144823sonnetting
tenting84621153___tenting
tormenting1345693tormenting

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 Filter1786911406030.1401276364.3
2DLD Change Limit1406031205.75024452.7
3Display Results1201200.0761578.9
 (SQL Overall)1786911205.96629951.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.