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

64 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
compassionate196309(None) 
compassionated2162391compassionated
compassionates2062601compassionates
companionate1863072compa_nionate
compassionately2471862compassionately
uncompassionate2181632uncompassionate
compassion1645983compassion___
compassionating2271933compassionating
compassions1745773compassion__s
dispassionate1662173dispassionate
passionate1245973___passionate
commissionaire2072094commissionaire
companionable2162534compa_nionable
compassing1746554compassi_n__g
compassionless2092104compassionless
compressional1954264compressiona_l
assassinate1161955_assassi_nate
caseinate1148245c___asei_nate
commission1645625commission___
commissionaires2181775commissionaires
commissioned1953145commission_ed
commissioner1853075commission_er
commissioners1972515commissioners
commissioning2092625commissioning
commissions1745265commission__s
compaction1846755compaction___
compactions1946545compaction__s
companion1577685compa_nion___
companionably2462545compa_nionably
companioned1853605compa_nion_ed
companioning1952935compa_nioning
companions1697265compa_nion__s
companionway2461425compa_nionway
companionways2571045compa_nionways
comparison1644355comparison___
comparisons1753975comparison__s
compassable1954215compass__able
compatriot1655965compatrio__t_
compatriots1753545compatrio__ts
compensate1646145compens___ate
complexional2551965complexiona_l
complicate1847625comp__li_cate
composite15410155comp_osi___te
compositional1974055compositiona_l
compression1756565compression___
compressions1856405compression__s
compulsion1644675compulsion___
compulsions1744595compulsion__s
concessionaire18142435concessionaire
concessional16195395concessiona_l
concessionary2072935concessionary
confessional17175465confessiona_l
confessionals18154175confessionals
contaminate1556575conta_mi_nate
dispassionately2171215dispassionately
impassion1344865_impassion___
impassioned1652935_impassion_ed
impassioning1752785_impassioning
impassions1444845_impassion__s
impersonate1554365_impers_onate
passional1146045___passiona_l
passionals1244805___passionals
passionately1752055___passionately
passivate1445685___passi_vate

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit124790649.46613183.0
3Display Results64640.0501280.0
 (SQL Overall)178691649.92218009.6
 
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.