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

55 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
compassionately247186(None) 
compassionate1963092compassionate__
compassionated2162392compassionate_d
compassionates2062602compassionate_s
compassionating2271933compassionating
dispassionately2171213dispassionately
passionately1752053___passionately
companionably2462544compa_niona_bly
companionate1863074compa_nionate__
compassionless2092104compassion_less
uncompassionate2181634uncompassionate__
companionable2162535compa_niona_ble
compassion1645985compassion_____
compassions1745775compassion____s
compositely2053665comp_osi___tely
compositionally2462285compositiona_lly
compressional1954265compressiona__l_
confessionally22103515confessiona_lly
dispassionate1662175dispassionate__
passionate1245975___passionate__
collisionally1862116co_llisiona_lly
commensurately2361746commens_urately
commissionaire2072096commissiona_ire
commissionaires2181776commissionaires
commissioned1953146commission__e_d
commissioner1853076commission__e_r
commissioners1972516commission__ers
companioned1853606compa_nion__e_d
companionway2461426compa_nion__way
compassable1954216compass___a_ble
compassing1746556compassi_n____g
complaisantly2261516complais_an_t_ly
complexional2551966complexiona__l_
compliantly2053836comp__lian_t_ly
complicatedly2561706comp__li_catedly
compositional1974056compositiona__l_
compressively25103386compressi___vely
compulsively2452796compulsi___vely
computationally2462496computationa_lly
concessional16195396concessiona__l_
concessionary2072936concessiona__ry
confessional17175466confessiona__l_
confessionals18154176confessiona__ls
congressionally2172136congressiona_lly
coordinately1852326co__ordi_nately
corporately1854126corp____orately
impassioned1652936_impassion__e_d
impassively2153576_impassi___vely
obsessionally1862386_obsessiona_lly
obstinately1652196_o__bsti_nately
occasionally1952756_occa_siona_lly
opinionatedly1961066_o_p_inionatedly
passional1146046___passiona__l_
passionals1244806___passiona__ls
proportionately2272096proportionately

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.703254183.5
2DLD Change Limit95024557.28313047.4
3Display Results55550.0461195.7
 (SQL Overall)178691558.03222247.4
 
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.