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

76 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
stetsons84562(None) 
stemsons1045001stemsons
stepsons1045661stepsons
stetson745781stetson_
seasons72614232s_easons
setons64620172s_et_ons
stations82415222stations
stemson945162stemson_
stepson945672stepson_
sternsons944662sternsons
telsons739222_telsons
testons7313562_testons
betons84919553_bet_ons
jetons134512613_jet_ons
jetsoms16124723_jetsoms
jettisons1642233jettisons
jettons1437273_jettons
keelsons1244093keelsons
kelsons1137323_kelsons
lessons73811023_lessons
mesons83215843_me_sons
nelsons738003_nelsons
persons93717013_persons
reasons72514943_reasons
season62714903s_eason_
sections102714703sections
seisins73614393s_eisins
seisors73212843s_eisors
selsyns1092943s_elsyns
sensors73514643s_ensors
sermons9311783s_ermons
sessions839723s_essions
seton55223543s_et_on_
setous64917373s_et_ous
settlors8255013settlors
sextons143710413s_extons
sponsons1045813sponsons
statins73719773stat_ins
station72717243station_
stators73915583stat_ors
steapsins1144633steapsins
stearins8312143stearins
steepens10277113steepens
stegodons1142513stegodons
steins64818343ste__ins
stenos63915773ste_no_s
stenoses8310443stenoses
stenosis847993stenosis
stentors839743stentors
stereos74314973stereo_s
sterns64616763ste__rns
sternson844843sternson_
sterols7313443ste_rols
stertors8310933stertors
stets55423913stet___s
stetting93410713stetting
stewpans1343713stewpans
stictions1148353stictions
stolons73410243st_olons
stotins73213873stot_ins
stressors955793stressors
strettos847113stretto_s
suctions103012903suctions
sweetsops1441993sweetsops
tatsois748373_tatsois
teflons1036543_teflons
telson6310293_telson_
tendons8311473_tendons
tenons62916603_te_nons
tensions8310223_tensions
tensors72712373_tensors
teston6313303_teston_
testoons837323_testoons
treasons848683treasons
tsetses785453tsets_es
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.423422437.4
2DLD Change Limit146162767.40319743.6
3Display Results76760.0332303.0
 (SQL Overall)178691767.85922737.1
 
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.