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

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

49 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
discountenanced2111174(None) 
discountenance19122221discountenance_
discountenances20122231discountenances
countenanced1754203___countenanced
countenance1555874___countenance_
countenancer1654224___countenancer
countenances1655734___countenances
discontented1655314disco_nte__nted
discontinuance19162524disco_ntinuance_
discontinuances20142244disco_ntinuances
countenancers1752985___countenancers
discontinued1654025disco_nt__inued
discountable1753845discount__able_
discounted1447845discount_____ed
countenancing1853136___countenancing
counteracted1747366___counteracted
countermanded1974686___countermanded
discommended2152346disco_mme__nded
disconcerted1854346disco_nce__rted
disconnected1853716disco_n__nected
discontent13410256disco_nte__n__t
discontentedly2182686disco_ntentedly
discontenting1755076disco_nten_ting
discontentment1963606disco_ntentment
discontents1447546disco_nte__n_ts
discontinue1455236disco_nt__inue_
discontinues1564396disco_nt__inues
discordance1753966disco___rdance_
discordances1853686disco___rdances
discounter1347026discount_____er
discounters1445756discounte____rs
discounting1547446discount__in__g
discouraged1653696discou___ra_ged
discourtesies1672266discourte__sies
dismounted1445416dismount_____ed
dissonance1354416disso____nance_
dissonances1454276disso____nances
distanced1348576dis____t__anced
inconsonance16163756_inco_nsonance_
inconsonances17153406_inco_nsonances
incontinence16135646_inco_ntinence_
incontinences17175466_inco_ntinences
inconvenienced22143066_inco_nvenienced
miscounted1546066miscount_____ed
mountebanked2181596___mountebanked
sustenance1253836__s__ustenance_
sustenances1353626__s__ustenances
untenanted1144456_____untenanted
viscountesses1851806viscounte__sses

Search took 10 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.1531167915.0
2DLD Change Limit95024499.42310084.3
3Display Results49490.0331484.8
 (SQL Overall)178691499.60918596.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.