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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

52 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
surpassed124413(None) 
surpasser1143861surpasser
surpasses1145531surpasses
outpassed1245802outpassed
surbased1136612surba_sed
surpass938282surpass__
surpassers1243082surpassers
surplused1243532surplused
surplussed1362122surplussed
surprised1245312surprised
unsurpassed1471622unsurpassed
brassed103612373_br_assed
bypassed1642713_bypassed
compassed1645543compassed
cuirassed1242923cuirassed
forepassed1643063forepassed
grassed93812793_gr_assed
harassed1237113har_assed
kurbashed1982563kurbashed
outgassed1145623outgassed
outpasses1146613outpasses
overpassed1645953overpassed
passed94320943___passed
purposed1335263purp_osed
repassed11229273_repassed
sassed76116173s___assed
sourpusses1242453sourpusses
spasmed12296993s__pasmed
strasses81311443str_asses
stressed9128543str_essed
subbasses1345223subbasses
subclassed1543713subclassed
succussed1443393succussed
supposed1345783su_pposed
suppressed1544533suppressed
surbase939793surba_se_
surbases10310003surba_ses
surceased1264843surceased
surfaced1436063surfa_ced
surmised1136863sur_mised
surnamed1135113surna_med
surpassing1343833surpassing
surpliced1444153surpliced
surpluses1155433surpluses
surplusses1242843surplusses
surprise1037673surprise_
surpriser1144613surpriser
surprises1137433surprises
surprized2144663surprized
surtaxed1644133surta_xed
sussed75015533su___ssed
upraised11167413_upraised

Search took 8 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 Filter1786911486410.436409841.7
2DLD Change Limit148641527.36020195.8
3Display Results52520.0134000.0
 (SQL Overall)178691527.80922882.7
 
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.