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

77 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
decencies144894(None) 
recencies13312251recencies
decadencies1753872decadencies
decenaries1348122decenaries
decentres12238522decentres
defences1439632defenc_es
indecencies1655822indecencies
lucencies1345842lucencies
regencies1249282regencies
adjacencies2391793adjacencies
agencies1138743_agencies
ardencies1247853ardencies
cadencies1447323cadencies
clemencies1644733clemencies
cogencies1448103cogencies
deaconries1345163deaconries
deaneries10310833deaneries
decadences1665143decadenc_es
decanes103118913decan__es
deceases11410153dece_ases
deceits102810883dece__its
deceives1437903dece_ives
decemvirs1741993decemvirs
decency1537453decenc__y
decennaries1454263decennaries
decennia1144223decenni_a
decennial1244823decennial
decennials1353343decennials
decennium1443783decennium
decenniums1552583decenniums
decenter112412163decen_ter
decenters122410373decenters
decentest1249083decen_test
decentre11248553decentre_
decentred13236233decentred
decries103319803dec__ries
decuries11312223dec_uries
defence1339893defenc_e_
defenced1537203defenc_ed
defencing16226693defencing
defenses1237913defen_ses
defensives1743863defensives
deficiencies2052943deficiencies
delegacies1444033delegacies
dementias1257413dementias
denies74729643d__en_ies
detentes92712873deten_tes
deviancies1644593deviancies
dioecies1138933dioe_cies
drenches14309803d_renches
fervencies1845183fervencies
fluencies1445933fluencies
latencies1147773latencies
leniencies1246193leniencies
licencees13134643licencees
licences12129323licenc_es
lucences12137313lucenc_es
nascencies1444553nascencies
patencies1349173patencies
peccancies1544933peccancies
pendencies1547023pendencies
potencies1369303potencies
pudencies1445783pudencies
reconciles1447063reconciles
recreancies1544653recreancies
redenies9615713reden_ies
refences13311843refenc_es
reticencies1545683reticencies
secrecies1346913secrecies
sequencies2155993sequencies
seventies1249673seventies
tenancies1149173tenancies
tendencies1346343tendencies
urgencies1256643urgencies
vacancies1645493vacancies
valencies1446413valencies
weenies102915093we_en_ies

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit148641776.47022973.9
3Display Results77770.0302566.7
 (SQL Overall)178691776.92325811.2
 
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.