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 “summersetting” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 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
summersetting186128(None) 
somersetting1552182s_omersetting
somerseting1453063s_omerse_ting
summersaulting197813summersaulting
summersetted1761213summersett_ed
oversetting1548814__oversetting
submersing1545844submers___ing
sulfuretting1651264sulfur_etting
summering1458754summer____ing
summerset1347254summerse_t___
summersets1443324summerse_t__s
superheating18126514su_perheating
superseding1546284su_perse_ding
superselling1554494su_perselling
superstring14116874su_pers_tring
underletting1454184_underletting
besetting12268425___be_setting
curetting1236575cu___r_etting
curvetting1643395cu___rvetting
filmsetting1751875film__setting
immersing1445125_immers___ing
intersecting1549715_intersecting
missetting13107905___missetting
numerating1357235nu_mer__ating
overbetting1747455__overbetting
overletting1548015__overletting
overwetting1847255__overwetting
pacesetting1652635_pace_setting
presetting131010835__pre_setting
resetting102816295___re_setting
russetting1184255ru___ssetting
simmering1467825simmer____ing
somersaulting1661145s_omersaulting
somersetted1451635s_omersett_ed
subletting1346275su___bletting
submerging1644585submer___ging
submitting1544975subm___itting
subverting1666295subver___ting
suggesting1343595sugge_s__ting
sulfureting15102465sulfur_e_ting
summarising1653565summar__ising
summarizing2544585summar__izing
summating1437945summ____ating
summeriest1476085summeriest___
summerlong1551945summer___long
summertime1353025summer___time
summiting1445795summ____iting
summonsing1543095summons___ing
superceding1755665su_perce_ding
supersizing2347025su_pers_izing
superstrings15125205su_pers_trings
superstrong14125045su_pers_trong
supervening1755785su_perve_ning
surfeiting1445025su___rfeiting
typesetting1752225_type_setting
undercutting1653765_undercutting
undereating1369555_under_eating
underheating1785135_underheating
underselling1453975_underselling
understating1446545_understating
unsetting1088995_u___nsetting
uppercutting1951535_uppercutting
upsetting1275565_u___psetting

Search took 10 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 Filter1786911247900.373479064.3
2DLD Change Limit124790638.80014180.7
3Display Results63630.0431465.1
 (SQL Overall)178691639.21619389.2
 
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.