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

85 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
indecencies165582(None) 
decencies1448942__decencies
indigencies1555762indigencies
inherencies1656472inherencies
innocencies15104962innocencies
inclemencies1853663inclemencies
indecency1745383indecenc__y
indecenter1345023indecen_ter
indecentest1454733indecen_test
indigences14227323indigenc_es
indolences1346573indolenc_es
inferences15410353inferenc_es
inherences1568973inherenc_es
innocences14106073innocenc_es
nascencies1444553_nascencies
recencies13312253__recencies
adjacencies2391794adjacencies
appetencies1753734appetencies
ardencies1247854ard__encies
cadencies1447324cad__encies
candescences1654494candescenc_es
clemencies1644734_clemencies
coherencies1884774coherencies
decadencies1753874__decadencies
decenaries1348124__decenaries
decentres12238524__decentres
defences1439634__defenc_es
endogenies1247064endogen_ies
immanencies1753524immanencies
imminencies1753964imminencies
impotencies1754584impotencies
impudencies1853634impudencies
inadequacies2461224inadequacies
inadvertencies2061674inadvertencies
incenses102411004in__cen_ses
incentives1578044in__centives
incessancies1652854incessancies
incidences1547134incidenc_es
incipiencies1853714incipiencies
incumbencies2053174incumbencies
indecent11411274indecen___t
indecently1655894indecen_tly
indefinites1553934indefinites
indehiscences2162654indehiscenc_es
indelicacies1752574indelicacies
indemnifies17102954indemnifies
indemnities14104874indemnities
indenes82916254ind__en__es
independencies2062684independencies
indifferencies2362484indifferencies
indigence13247894indigenc_e_
indigenes11228994indigen__es
indigenizes2252974indigenizes
indolence1246784indolenc_e_
inductances1663514inductanc_es
indulgences15194034indulgenc_es
inerrancies1355054inerrancies
infancies1446974in__fancies
inference14411034inferenc_e_
influences1545654influenc_es
infrequencies2762484infrequencies
inherence1449274inherenc_e_
innocence1395994innocenc_e_
insectaries1354894insectaries
insecticides1752604insecticides
insistencies1454054insistencies
insolences1247114insolenc_es
insolvencies1752934insolvencies
instancies1246614in_stancies
insurgencies1553584insurgencies
intestacies1355304intestacies
intrenches1545814in_trenches
inveteracies1752764inveteracies
iridescences1793354iridescenc_es
lucencies1345844__lucencies
mendicancies1952224mendicancies
nascences1346234_nascenc_es
pendencies1547024pend__encies
pudencies1445784pud__encies
redolencies1454564redolencies
regencies1249284__regencies
reticencies1545684reticencies
tendencies1346344tend__encies
undeceives1643864undece_ives
vehemencies2152764vehemencies

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.420425454.8
2DLD Change Limit148819858.51617475.2
3Display Results85850.0461847.8
 (SQL Overall)178691858.98219894.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.