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

75 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
discountenances2012223(None) 
discountenance19122221discountenance_
discountenanced21111741discountenanced
countenances1655733___countenances
discontinuances20142243disco_ntinuances
countenance1555874___countenance_
countenanced1754204___countenanced
countenancer1654224___countenancer
countenancers1752984___countenancers
discontinuance19162524disco_ntinuance_
discontented1655315disco_nte__nted
discontents1447545disco_nte__n_ts
discontinues1564395disco_nt__inues
discordances1853685disco___rdances
discountable1753855discount__able_
discounters1445755discounte____rs
discourtesies1672265discourte__sies
dissonances1454275disso____nances
inconsonances17153405_inco_nsonances
incontinences17175465_inco_ntinences
sustenances1353625__s__ustenances
viscountesses1851805viscounte__sses
accountancies1671906_account__ancies
appurtenances1961276__appurtenances
bicentenaries1762026bi_c_entenaries
consonances1545776___co_nsonances
continences1588586___co_ntinences
continuances1654686___co_ntinuances
conveyances2185206___co_nveyances
cotenancies1545076___co__tenancies
countenancing1853136___countenancing
counteracts1547516___countera_cts
counterpanes1649306___counterpan_es
despondences1853396despo_nde__nces
disconnects1654116disco_n__n_ects
discontent13410256disco_nte__n__t
discontentedly2182686disco_ntentedly
discontenting1755076disco_nten_ting
discontentment1963606disco_ntentment
discontentments2072996disco_ntentments
discontinue1455236disco_nt__inue_
discontinued1654026disco_nt__inued
discontinuities1872186disco_ntinuities
discontinuous1672546disco_ntin_uous
discordance1753966disco___rdance_
discordancies1962616disco___rdancies
discounted1447846discount_____ed
discounter1347026discount_____er
discounting1547446discount__in__g
discounts1287826discount______s
discourages1554386discou___ra_ges
discourteous1552316discourte___ous
discrepancies2061776disc___repancies
discretenesses1753386disc_retenesses
disjointedness2362156disjointe_dness
disseverances1962116dis__severances
dissolutenesses1561996dissolutenesses
dissonance1354416disso____nance_
distances12311656dis____t__ances
disturbances1752456dis_tu__rbances
incognizances2762296_incogn_izances
inconsonance16163756_inco_nsonance_
incontinence16135646_inco_ntinence_
incontinencies18163756_inco_ntinencies
inconveniences21154106_inco_nveniences
intendances1445556_i____ntendances
lieutenancies1581346li__eu_tenancies
maintenances1651956___maintenances
purtenances1553866____purtenances
reconveyances2362426_reco_nveyances
subtenancies1653016__s__ubtenancies
sustenance1253836__s__ustenance_
viscountcies1962086viscount___cies
viscountess1662386viscounte____ss
viscounties1653636viscount____ies

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.1261418182.5
2DLD Change Limit95024759.09310450.2
3Display Results75750.0631190.5
 (SQL Overall)178691759.28219251.3
 
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.