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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
survived153407(None) 
survive1335931survive_
surviver1434681surviver
survives1436331survives
scrived134511112scr_ived
serviced1435612serviced
shrived144712182shr_ived
strived114713662str_ived
surmised1136862surmised
surveyed1544232surveyed
survival1443922survival
survivers1543882survivers
survivor1442402survivor
arrived11127353_arrived
buried94822373bur_i_ed
curried103313653curri_ed
cursive1237833cursive_
cursives1337103cursives
curved124815223cur__ved
curveted1435293curveted
curvier123110663curvi_er
derived123912763der_ived
furtive1337173furtive_
hurried113511043hurri_ed
juried144212443jur_i_ed
outlived12269583outlived
outvied11239693outvi_ed
purveyed1743363purveyed
purview1534233purvi_ew
reived104518133__reived
revived144211653_revived
rived94825613__r_ived
sardined10268663sardined
savvied1433803savvi_ed
scribed124510643scr_ibed
scried95817303scr_i_ed
scrieved14366203scrieved
scrive115414943scr_ive_
scrives124414273scr_ives
scurried11267053scurri_ed
scurvier13255883scurvi_er
scurvies13248123scurvi_es
serifed11811463ser_ifed
serried82513963serri_ed
served104616813ser__ved
service1239083service_
servicer1335263servicer
services1338573services
servile10310643servile_
shrieved15276073shrieved
shrined114112413shr_ined
shrive125216953shr_ive_
shrivel13479403shr_ivel
shriven13379653shr_iven
shriver134712193shr_iver
shrives134416173shr_ives
skived14429893s__kived
skivvied1971813skivvied
skydived2051563skydived
slurried9285943slurri_ed
sortied83314103sorti_ed
spavined1434333spavined
sprained1138433sprained
strained9412253strained
striped105214363str_iped
strive95020963str_ive_
striven103910753str_iven
striver104315203str_iver
strives104119373str_ives
sturdied10215963sturdi_ed
suasive1037853suasive_
sublimed1337213sublimed
subsided1257663subsided
subvened1436423subvened
sufficed17205663sufficed
suffixed22214343suffixed
suicided1246033suicided
suited74019423su__ited
sullied83714483sulli_ed
summited13246413summited
supervised1646663supervised
surbased1136613surbased
surfaced1436063surfaced
surfed103814463sur__fed
surfeited1344593surfeited
surfier102613543surfi_er
surged84118883sur__ged
surlier72915443surli_er
surmise9311083surmise_
surmiser1036763surmiser
surmises10310643surmises
surnamed1135113surnamed
surpliced1444153surpliced
surprised1245313surprised
surprized2144663surprized
surtaxed1644133surtaxed
surveilled1442203surveilled
survey124111673sur__vey
survivals1543013survivals
surviving1644163surviving
survivors1542443survivors
suspired1135613suspired
swived133610633s__wived
thrived14458183thr_ived
unlived112511373_unlived
updived1434093_updived

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621067.58019282.6
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.04622208.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.