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

44 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
clandestinities188125(None) 
clandestinity1971273clandestinit__y
clandestine1453014clandestin___e_
clandestineness1871144clandestineness
caninities12410495c_an____inities
causticities1654005c_a__usticities
changeabilities2362865changeabilities
clandestinely1961105clandestin__ely
conductivities2283565c_onductivities
connectivities2164475c_onnectivities
elasticities1455105ela___sticities
latinities10410165_la____tinities
plasticities1655555pla___sticities
adaptivities1853126__a_daptivities
additivities1753116__a_dditivities
affectivities2453516__affectivities
analyticities1862506__analyticities
andesites1048556__andes___it_es
anelasticities16163026__anelasticities
candescences1654496c_andescen__ces
canonicities1654706c_an__onicities
captivities1845946c_a___ptivities
chastities1545866cha___st__ities
cleanabilities1856056clean__abilities
clonicities1546186clon____icities
collectivities2174166c_ollectivities
concentricities1872916c_oncentricities
continuities1456246c_on___tinuities
creativities1755786c___reativities
destinies10410846____destin__ies
domesticities1863806__domesticities
endemicities1754026__ende_micities
festivities1746586____festivities
indefinites1553936__inde_finit_es
indemnities14104876__inde__mnities
infectivities2155126__infectivities
infertilities1656216__infertilities
langbeinites1561196_lan_gbeinit_es
lanosities1047916_lan_os___ities
nonadditivities2071396nonadditivities
predestinates1694636_predestinat_es
sanguinities1353766_san__guinities
spasticities1654626spa___sticities
transitivities1763516tran_sitivities

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 Filter178691950240.376475242.0
2DLD Change Limit95024447.70312336.0
3Display Results44440.0301466.7
 (SQL Overall)178691448.10922036.1
 
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.