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

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
appellative185307(None) 
appellatives1952041appellatives
appellate1346192appellat__e
appellation1564122appellation
appellatively2361992appellatively
appellations1643533appellations
appetitive1753753appe_titive
applicative2074713applicative
appreciative2153943appreciative
superlative1648253superlative
ablative1348244a___blative
accelerative1953454accelerative
acetylative1952524acetylative
adversative1853244adversative
alternative1454684alternative
appealable1643854appeala_ble
appellant1346354appella__nt
appellants1443964appella_nts
appellee1246254appell___ee
apperceive1953274appe_rceive
apperceptive2052954apperceptive
appetite1258494appe___tite
appointive1793804app_ointive
appositive1744844app_ositive
carpellate1445334carpellat__e
copulative1747294cop_ulative
cupellation1544144cupellation
elative10312454___e_lative
expectative2553584expectative
illative1147184___illative
imperative1748564impe_rative
irrelative1344784irre_lative
operative141110554_ope_rative
palliative1544774_palliative
papillate13127574papillat__e
patellate1147484patellat__e
pelletise1146664__pelletise
pelletize2056394__pelletize
pollutive1444714__pollutive
precative16312574_pre_cative
pulsative1455174__pulsative
relative11313144__re_lative
speculative1844274speculative
sporulative1653744sporulative
superlatives1756574superlatives
titillative1452464titillative

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 Filter1786911488190.440406115.9
2DLD Change Limit148819467.95318712.3
3Display Results46460.0162875.0
 (SQL Overall)178691468.40921250.0
 
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.