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 “confidentially” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

57 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
confidentially237297(None) 
confidential1854292confidentia_l_
confidentiality2471782confidentiality
coincidentally2261773coincident_ally
confidently2055003confident___ly
continentally1863623continent_ally
conferential1755394conferentia_l_
congenially1755904con__gen_ially
congenitally1854394con__genitally
consequentially2971804consequentially
conventually2064894con__ventually
evidentially1954054__evidentially
incidentally1854124_incident_ally
inferentially1955494_inferentially
influentially1962894_influentially
occidentally2062784_occident_ally
penitentially1854294pen_itentially
presidentially2063224presidentially
providentially2362324providentially
residentially1773844_residentially
accidentally2062735_accident_ally
centennially1753575cen__tennially
coincidental1762445coincident_a_l_
coincidently2062825coincident___ly
concentrically2063775con__centrically
conceptually2174505con__ceptually
condimental1655495condiment_a_l_
confident1549385confident_____
confidingly2153185confid___ingly
consensually1753165con__sensually
consentingly1854665con__sentingly
considerably2052695conside__rably
contextually2453705con__textually
continental1375655continent_a_l_
continentals1474315continent_a_ls
continently1655465continent___ly
continually1655085conti__n_ually
conventionally2254985con__ventionally
convivially2252665convi___vially
coresidential1662995coresidentia_l_
deferentially2063715_deferentially
differentially2463135differentially
dorsiventrally2171585dorsiventrally
identically1748465____identically
monumentally1953985mon_ument_ally
nonconfidential2172065nonconfidentia_l_
nonidentical1554335non_identical_
nonidentity1553765non_identi__ty
orientally1346215_o_ri_ent_ally
pestilentially1982245pestilentially
potentially1656805po___tentially
preferentially2262835preferentially
prudentially1854155__prudentially
referentially1963525_referentially
sentimentally1874145sentiment_ally
tangentially1653255tan__gentially
torrentially1553755to__rrentially

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 Filter178691950240.360496363.9
2DLD Change Limit95024576.48314657.4
3Display Results57570.0461239.1
 (SQL Overall)178691576.88925938.6
 
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.