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

78 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
stepsons104566(None) 
stemsons1045001stemsons
stepson945671stepson_
stetsons845621stetsons
seasons72614232s_easons
steapsins1144632steapsins
stemson945162stemson_
sternsons944662sternsons
stetson745782stetson_
telsons739222_telsons
crepons1139323crep_ons
erepsins1037453erepsins
ethephons1743373ethephons
keelsons1244093keelsons
kelsons1137323_kelsons
leptons91910433_leptons
lessons73811023_lessons
mesons83215843_me_sons
nelsons738003_nelsons
pepsins11310433_pepsins
persons93717013_persons
reasons72514943_reasons
season62714903s_eason_
seisins73614393s_eisins
seisors73212843s_eisors
selsyns1092943s_elsyns
sensors73514643s_ensors
sepoys1138473s_ep_oys
sepses84515883s_eps_es
sepsis83011293s_eps_is
sermons9311783s_ermons
sessions839723s_essions
setons64620173s_e_tons
sextons143710413s_extons
shippons15255663shippons
siphons1239353s_iphons
skepsis1344253skeps_is
soupcons1244373soupcons
sponsons1045813sponsons
spoons84116023s__poons
stations82415223stations
steapsin1044713steapsin_
stearins8312143stearins
steepens10277113steepens
stegodons1142513stegodons
steins64818343ste__ins
stenos63915773ste_no_s
stenoses8310443stenoses
stenosis847993stenosis
stentors839753stentors
steppers12289283steppers
steppes113110693step_pes
stepping13329073stepping
steps76619883step___s
stepstool1162223stepstool
stepstools1262053stepstools
stereos74314973stereo_s
sterns64616763ste__rns
sternson844843sternson_
sterols7313443ste_rols
stertors8310933stertors
stewpans1343713stewpans
stolons73410243st_olons
stressors955793stressors
stupors935883stup_ors
stypsis1245243styps_is
syphons1537503s_yphons
teflons1036543_teflons
telson6310293_telson_
tendons8311473_tendons
tenons62916603_te_nons
tensions8310223_tensions
tensors72712373_tensors
tepoys1137543_tep_oys
testons7313563_testons
treasons848683treasons
typhons1537083_typhons
weasons102310583_weasons

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 Filter1786911461620.453394461.4
2DLD Change Limit146162787.47019566.5
3Display Results78780.0302600.0
 (SQL Overall)178691787.95322468.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.