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

95 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
dependances175485(None) 
dependance1645121dependance_
dependences1745881dependences
dependants1444702dependan_ts
dependence1646592dependence_
dependencies1854082dependencies
repentances1556112repentances
ascendances16123833ascendances
attendances1483193attendances
codependences2163093codependences
defeasances1752283defeasances
defendants1543653defendan_ts
dependable1645793dependable_
dependant1347003dependan__t
dependency1954683dependenc_y
dependents1446163dependen_ts
despondences1853393despondences
impedances1744503impe_dances
independences1963923independences
intendances1445563intendances
penances12312443__pen_ances
repentance1456623repentance_
tendances1247573__tendances
abundances1543314_abundances
appearances1753694appearances
appendages1653244appenda_ges
appendants1544064appendan_ts
appendices1743464append_ices
ascendance15113964ascendance_
ascendancies17112624ascendancies
ascendences16124144ascendences
attendance1383364attendance_
codependence2063594codependence_
codependencies2262184codependencies
decadences1665144de_cadences
decenaries1348124decen_aries
decennaries1454264decennaries
defeasance1652544defeasance_
defences1439634defe___nces
defendable1754984defendable_
defendant1445444defendan__t
deferences1677874defe_rences
defiances1557034d__efiances
demandants1443254demandan_ts
denounces1245414d__enounces
dependably1954544dependa_bly
depended1337984depend___ed
dependent1349114dependen__t
dependently1894684dependently
depending14208784dependin__g
depends11348994depend____s
deplanes11311214dep__lan_es
depredates1445514depreda_tes
descendants1552754descendan_ts
desinences1347224desin_ences
desistances1444194desistances
despondence1753864despondence_
despondencies1962144despondencies
deterrences1455184deterrences
deviances1566494d__eviances
dominances1545684domin_ances
elegances1246184_ele_gances
emendates1246084_emenda_tes
enhances1339294___enhances
esperances1446254espe_rances
expectances2493344expectances
expendables2352154expendables
impedance1644964impe_dance_
independence1854304independence_
independencies2062684independencies
intendance1345724intendance_
legendaries1353094legendaries
nondances1247804__nondances
penance11313444__pen_ance_
penanced1338164__pen_anced
pendants1139094__pendan_ts
pendencies1547024__pendencies
penetrances1544804penetrances
pentanes10316084__pentan_es
redundancies1651954redundancies
reentrances1345174re_entrances
refinances15107144refin_ances
relevances1596114rele_vances
reprobances1754134reprobances
repugnances1692864repugnances
resentences1347424resentences
resonances1246874reson_ances
resplendences18122384resplendences
ropedancer15132524rope_dancer
ropedancers16101744rope_dancers
severances1546784seve_rances
temperances1754734tempe_rances
tendance1147524__tendance_
tendences1248084__tendences
vendaces1457184__venda_ces

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.423422437.4
2DLD Change Limit148819958.21618113.3
3Display Results95950.0462065.2
 (SQL Overall)178691958.68520574.7
 
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.