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

46 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
compassionates206260(None) 
compassionate1963091compassionate_
compassionated2162391compassionated
compassionately2471862compassionately
companionate1863073compa_nionate_
compassionating2271933compassionating
compassionless2092103compassionless
compassions1745773compassion___s
uncompassionate2181633uncompassionate_
commissionaires2181774commissionaires
compassion1645984compassion____
dispassionate1662174dispassionate_
passionate1245974___passionate_
assassinates1161685_assassi_nates
caseinates1247445c___asei_nates
commissionaire2072095commissionaire
commissioned1953145commission__ed
commissioner1853075commission__er
commissioners1972515commission_ers
commissions1745265commission___s
compactions1946545compaction___s
companionable2162535compa_nionable
companionably2462545compa_nionably
companioned1853605compa_nion__ed
companions1697265compa_nion___s
companionways2571045compa_nionways
comparisons1753975comparison___s
compasses1547395compass_____es
compassing1746555compassi_n___g
compatriots1753545compatrio__t_s
compensates1745725compens___ates
complicates1947055comp__li_cates
composites1648905comp_osi___tes
compressional1954265compressiona__l
compressions1856405compression___s
compulsions1744595compulsion___s
concessionaires19171945concessionaires
confessionals18154175confessiona_ls
contaminates1656315conta_mi_nates
dispassionately2171215dispassionately
impassioned1652935_impassion__ed
impassions1444845_impassion___s
impersonates1653895_impers_onates
passionals1244805___passiona_ls
passionately1752055___passionately
passivates1544965___passi_vates

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.1101624463.6
2DLD Change Limit95024466.33015011.7
3Display Results46460.0301533.3
 (SQL Overall)178691466.47027618.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.