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

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
compassionately2471861compassionately_
compassionate1963093compassionate___
compassionated2162393compassionate__d
compassionates2062603compassionate__s
compassionating2271934compassionat_ing
dispassionately2171214dispassionately_
passionately1752054___passionately_
companionably2462545compa_niona_bly_
companionate1863075compa_nionate___
compassionless2092105compassion_le_ss
uncompassionate2181635uncompassionate___
companionable2162536compa_niona_bl_e
compassion1645986compassion______
compassions1745766compassion_____s
compositely2053666comp_osi___tely_
compositionally2462286compositiona_lly_
compressional1954256compressiona__l__
confessionally22103506confessiona_lly_
dispassionate1662176dispassionate___
passionate1245976___passionate___
collisionally1862117co_llisiona_lly_
commensurately2361747commens_urately_
commissionaire2072097commissiona__ire
commissionaires2181777commissiona_ires
commissioned1953147commission__e__d
commissioner1853077commission__e__r
commissioners1972517commission__e_rs
companioned1853607compa_nion__e__d
companionway2461427compa_nion__way_
companionways2571047compa_nion__ways
compassable1954217compass___a_bl_e
compassing1746547compassi_n_____g
complaisantly2261517complais_an_t_ly_
complexional2551967complexiona__l__
compliantly2053837comp__lian_t_ly_
complicatedly2561707comp__li_catedly_
compositional1974047compositiona__l__
compressively25103387compressi___vely_
compulsively2452797compulsi___vely_
computationally2462497computationa_lly_
concessional16195397concessiona__l__
concessionary2072937concessiona__ry_
confessional17175467confessiona__l__
confessionals18154177confessiona__l_s
congressionally2172137congressiona_lly_
coordinately1852327co__ordi_nately_
corporately1854127corp____orately_
impassioned1652937_impassion__e__d
impassively2153577_impassi___vely_
obsessionally1862387_obsessiona_lly_
obstinately1652197_o__bsti_nately_
occasionally1952757_occa_siona_lly_
opinionatedly1961067_o_p_inionatedly_
passional1146047___passiona__l__
passionals1244807___passiona__l_s
passionateness1661787___passionateness
proportionately2272097proportionately_

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.1231452772.4
2DLD Change Limit95024578.28311472.2
3Display Results57570.0461239.1
 (SQL Overall)178691578.45221141.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.