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

86 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
upsetters114365(None) 
upsetter1034641upsetter_
besetters11136632besetters
insetters9187132insetters
petters93722362_p_etters
resetters9129462resetters
setters73822062__setters
unfetters1244362unfetters
upstaters11174802upstaters
abetters1057173_abetters
absenters1156173absenters
assenters966993assenters
asserters956393asserters
begetters12135043begetters
besetter10137973besetter_
betters94422093__betters
casettes1039653casette_s
deserters10129983deserters
enfetters1244463enfetters
fetters103517903__fetters
fretters113410303_fretters
getters84216103__getters
inserters92210283inserters
insetter8218593insetter_
letters73819853__letters
misenters1139533misenters
musettes1037433musette_s
netters73618583__netters
patters94825193_p_atters
pelters93720313_p_elters
pesters93827093_p_esters
peters86624593_p_e_ters
petter83924773_p_etter_
pewters124113353_p_ewters
pinsetters1244103pinsetters
platters103415283_platters
pleaters103613793_pleaters
plotters104011553_plotters
potters94024343_p_otters
presters103419003_presters
psalters10227713_psalters
puppeteers1361983puppeteers
putters94219193_p_utters
reletters9138783reletters
resetter81511833resetter_
rosettes8310343rosette_s
seaters74028943__seaters
settees73513633__settees
setter64023723__setter_
settlers8289023__settlers
sitters74221553__sitters
spatters103914703sp_atters
specters122811063sp_ecters
spelters103912243sp_elters
spitters104113383sp_itters
splatters11327543splatters
splitters11307323splitters
splutters11286273splutters
spotters104313383sp_otters
sputters104012873sp_utters
tetters74320473__tetters
typesetters1651693typesetters
ulsters72711983uls__ters
unfetter1136753unfetter_
unsettles964653unsettles
untethers1244153untethers
upbearers1343033upbearers
updaters11255183up_daters
upgathers1582533upgathers
upheavers1742593upheavers
uplifters1463283uplifters
uprooters1164253uprooters
upsets8409683upse_t__s
upsetting1275563upsetting
upstagers12173333upstagers
upstairs1043643ups_tairs
upstares10178583ups_tares
upstater10156663upstater_
upstates10189643upstate_s
upsteps1133743ups__teps
upstirs935293ups__tirs
ureters7311823u_re_ters
utters63817123u___tters
vetters104016323__vetters
wetters103817753__wetters
whetters14246653_whetters

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.420425454.8
2DLD Change Limit148641866.65622331.9
3Display Results86860.0461869.6
 (SQL Overall)178691867.12225090.0
 
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.