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

63 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
consanguinities1814159(None) 
consanguinity1971263consanguinit__y
sanguinities1353763___sanguinities
consanguine1452314consanguin___e_
consanguineous177864consanguin_eous
caninities12410495c___an__inities
concentricities1872915concentricities
concinnities1654415concin___nities
conspicuities1962585conspicu__ities
contiguities1554445con_tigu__ities
continuities1456245contin_u__ities
ensanguines12122675_ensanguin___es
exsanguinates2161775_exsanguinat_es
longanimities1662375longan__imities
asininities1145196__asin__inities
canonicities1654706c___anonicities
cleanabilities1856056c_leanabilities
coilabilities1748096coila__bilities
communities1747276co___mmu_nities
comparabilities2374376comparabilities
compatibilities2363626compatibilities
concavities1846126conca____vities
conceptualities2174296conceptualities
conductivities2283566con_ductivities
confraternities2091546confraternities
congenialities1774196congen_ialities
congruities1455196co___ng_ruities
conicities14412636co___n__icities
conjugalities2353006con_jug_alities
conjunctivitis2881736conjunctiviti_s
connaturalities17162606connaturalities
connectivities2164476con_nectivities
connubialities1862596con__nubialities
consonancies1653926conson__an_cies
constituencies1871806constituen_cies
contaminates1656316conta__minat_es
contingencies1853526conting_en_cies
contractilities1983196contractilities
coplanarities1752666coplan__arities
countabilities1856696counta__bilities
crossabilities1855726crossa__bilities
crystallinities2071596crystallinities
ensanguine11122826_ensanguin___e_
ensanguined13112016_ensanguin___ed
ensanguining1461376_ensanguin__ing
exsanguinate2061906_exsanguinat_e_
exsanguinated2261556_exsanguinat_ed
exsanguinating2361326_exsanguinating
exsanguination2261596_exsanguination
exsanguinations2361366_exsanguinations
infantilities1665266_infan_tilities
insalubrities1561956_insa_lubrities
insanities1049426_insa____nities
intangibilities1864476_intangibilities
nonvalidities1752556nonva__lidities
organicities1554886_organ__icities
salinities10410956___sa__linities
sanguinarias1362256___sanguinarias
sanguines1047186___sanguin___es
sanguinity1453056___sanguinit__y
tranquilities2253906__tranquilities
unanimities1344816_un_an__imities
volcanicities2062986volcan__icities

Search took 8 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.360496363.9
2DLD Change Limit95024637.00013574.9
3Display Results63630.0461369.6
 (SQL Overall)178691637.40624127.9
 
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.