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

74 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
stemsons104500(None) 
stemson945161stemson_
stepsons1045661stepsons
stetsons845621stetsons
seasons72614232s_easons
stepson945672stepson_
sternsons944662sternsons
stetson745782stetson_
telsons739222_telsons
crimsons1245633crimsons
daemons10269233daem_ons
damsons1038013_damsons
demons94917723_dem_ons
etymons1244153etym_ons
keelsons1244093keelsons
kelsons1137323_kelsons
lemons84415053_lem_ons
lessons73811023_lessons
mesons83215843_me_sons
nelsons738003_nelsons
persons93717013_persons
ramsons939563_ramsons
reasons72514943_reasons
salmons93713263salm_ons
season62714903s_eason_
seisins73614393s_eisins
seisors73212843s_eisors
selsyns1092943s_elsyns
semens84616973s_em_ens
sensors73514643s_ensors
sermons9311783s_ermons
sessions839723s_essions
setons64620173s_e_tons
sextons143710413s_extons
siemens938413siem_ens
simoons937943s_imoons
sponsons1045813sponsons
stamens93411483stam_ens
stations82415223stations
steapsins1144633steapsins
stearins8312143stearins
steepens10277113steepens
stegodons1142513stegodons
steins64818343ste__ins
stemless1036653stemless
stemmas11256973stem_mas
stemmers12378443stemmers
stemming13408203stemming
stems75219953stem___s
stenos63915773ste_no_s
stenoses8310443stenoses
stenosis847993stenosis
stentors839743stentors
stereos74314973stereo_s
sterns64616763ste__rns
sternson844843sternson_
sterols7313443ste_rols
stertors8310933stertors
stewpans1343713stewpans
stolons73410243st_olons
stonemasons1351423stonemasons
stressors955793stressors
summons1158003s_ummons
tampons112711563_tampons
teflons1036543_teflons
telson6310293_telson_
tempos103812293_tempo_s
tendons8311473_tendons
tenons62916603_te_nons
tensions8310223_tensions
tensors72712373_tensors
testons7313563_testons
treasons848683treasons
weasons102310583_weasons

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.576310227.4
2DLD Change Limit146162748.37617450.1
3Display Results74740.0332242.4
 (SQL Overall)178691748.98519887.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.