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

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
receded11271304(None) 
preceded1438291preceded
recede95515531recede_
recedes102816061recedes
recoded113115031recoded
reeded84022561re_eded
seceded11319201seceded
acceded1336102acceded
ceded96118562__ceded
decided124312422decided
decoded123212382decoded
deeded94615542de_eded
heeded114215762he_eded
needed84114442ne_eded
precede1239652precede_
precedes13310712precedes
precoded1438862precoded
racemed1237012racemed
reacceded1573992reacceded
readded103310732readded
recaned102817202recaned
received1437982received
recessed1139712recessed
rechewed1735632rechewed
recited104319102recited
recked134821802rec_ked
recode93618712recode_
recodes102918632recodes
recorded122511062recorded
recused104714422recused
redded94019552re_dded
reded74829122r__eded
reefed103816582re_efed
reeked113717642re_eked
reeled74725532re_eled
reeved104118712re_eved
refeed104717622refe_ed
rekeyed1536162rekeyed
remedied1237952remedied
remended123010392remended
rended84524102re_nded
reneged92010762reneged
renewed11309992renewed
reseed74823292rese_ed
reseeded1038092reseeded
resewed113011822resewed
resided95217702resided
reveled113917752reveled
revered112819332revered
rewedded1434512rewedded
rewelded1335892rewelded
secede93311992secede_
seceder10329572seceder
secedes103711982secedes
seeded84520462se_eded
unceded11410562unceded
weeded113914872we_eded

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671572.95336461.6
3Display Results57570.0163562.5
 (SQL Overall)178691573.34553420.3
 
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.