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

79 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
countenance155587(None) 
countenanced1754201countenanced
countenancer1654221countenancer
countenances1655731countenances
countenancers1752982countenancers
consonance1446183co_nsonance
continence1489133co_ntinence
continuance1555123co_ntinuance
conveyance2085303co_nveyance
cotenancy1644673co__tenancy
countenancing1853133countenancing
counteract1449603countera_ct
counterpane1549313counterpan_e
discountenance19122223discountenance
maintenance1551973maintenance
purtenance1454053_purtenance
sustenance1253833_sustenance
appurtenance1861384appurtenance
cofinance1645554co__finance
cognizance2452784cogn_izance
coinsurance1553204coinsurance
conference1799014co_nference
connivance1754254co_nnivance
consonances1545774co_nsonances
consonancy1753994co_nsonancy
continences1588584co_ntinences
contingence16105454co_ntingence
continuances1654684co_ntinuances
contredanse1452754co_ntredanse
contrivance1854264co_ntrivance
convenience1886444co_nvenience
conversance1876324co_nversance
conveyancer21123614co_nveyancer
conveyances2185204co_nveyances
cotenancies1545074co__tenancies
cotenant10511804co__tenan_t
cotenants1147294co__tenants
countable1348854count__able
counteracted1747364counteracted
counteracts1547514counteracts
counterargue1555304counterargue
counterbalance20123244counterbalance
counterchange2194864counterchange
counterfire1647004counterfire
counterforce1985794counterforce
countering13314474counterin_g
counterinstance19101794counterinstance
counterman1448554counterman__
countermand1647124counterman_d
countermanded1974684countermanded
countermands1746234countermands
countermarch2154464countermarch
countermine1549744countermine
countermove1855854countermove
counterpanes1649304counterpanes
counterpose1547504counterpose
counterpunch2154194counterpunch
countersue1247744counte_rsue
countian1048124count_ian__
countians1147334count_ian_s
courtesan1144174courtesan__
courtesans1244254courtesan_s
courtezan2042984courtezan__
courtezans2152874courtezan_s
discountenanced21111744discountenanced
discountenances20122234discountenances
intendance1345724__intendance
maintenances1651954maintenances
mountebank1851584mounteban_k
mountebanked2181594mountebanked
mountebanks1951574mountebanks
outdance11238734_ou_t_dance
outrance102212784_ou_t_rance
purtenances1553864_purtenances
subtenancy1753064_subtenancy
sustenances1353624_sustenances
untenable11410504__untenable
untenanted1144454__untenanted
utterance1145464__utterance

Search took 9 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 Filter1786911488190.403443402.0
2DLD Change Limit148819798.33017865.4
3Display Results79790.0461717.4
 (SQL Overall)178691798.77920354.4
 
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.