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 “summering” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

159 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
summering145875(None) 
simmering1467821simmering
bumpering1636592bumpering
cumbering16108202cumbering
hammering1737632hammering
lumbering14117932lumbering
mammering1337332mammering
numbering14107002numbering
pummeling1643602pummeling
shimmering1884622shimmering
simpering1449292simpering
slumbering15105322slumbering
stammering1544522stammering
submerging1644582submerging
submersing1545842submersing
suckering1638102suckering
suffering1637292suffering
summating1437942summating
summerier1346422summerier
summerlong1551942summerlong
summing122912382summ__ing
summiting1445792summiting
summoning14115692summoning
sundering11312322sundering
supering11317682su_pering
umbering1399432_umbering
yammering1735192yammering
buffering1835223buffering
buggering1435193buggering
bumming143410783bumm__ing
bunkering16207103bunkering
buttering122312523buttering
cambering16109873cambering
commercing1955973commercing
compering163414163compering
dummying17263723dumm_ying
fullering1336653fullering
glimmering1643713glimmering
grummeting1642453grummeting
gumming133810193gumm__ing
guttering112410443guttering
hampering1738863hampering
homering141512073_homering
humming153310673humm__ing
humoring1456853hu_moring
humouring1544553humouring
hungering14187683hungering
hunkering17227123hunkering
immerging1544103_immerging
immersing1445123_immersing
immuring1335533_immuring
juddering1933763juddering
limbering1488793limbering
lumberings15103783lumberings
lustering102711203lustering
mummeries1247243mummeries
mumming114010023mumm__ing
mummying15263723mumm_ying
murdering1357133murdering
murmuring1443633murmuring
mustering122212333mustering
muttering122611323muttering
pampering1638383pampering
plummeting1742103plummeting
pommeling1643873pommeling
puckering1835883puckering
pummelling1743163pummelling
puttering122611643puttering
quavering2235953quavering
queering1838203qu_eering
quivering2235873quivering
rubbering1435703rubbering
rummaging1543363rummaging
rumoring1136983ru_moring
rumouring1244513rumouring
sabering112113743s_abering
saggering12197793saggering
sauntering1137223sauntering
scampering1745323scampering
schmearing1842863schmearing
schmeering1843433schmeering
scumming15256793scumm__ing
scunnering1344133scunnering
scuppering1754023scuppering
scuttering1386633scuttering
sering74731813s___ering
severing122013853s_evering
sewering122411093s_ewering
sheering123715103s_heering
shivering1637333shivering
showering1646403showering
shuddering1643513shuddering
shuttering1496563shuttering
silvering1337923silvering
sintering101014803sintering
sistering101213753sistering
skewering1744633skewering
slavering1338723slavering
slivering1338083slivering
slubbering15124923slubbering
slumming13278383slumm__ing
smearing113511753s_mearing
smeeking15317833s_meeking
smerking15258473s__merking
sneering93414503s_neering
sobering111912783s_obering
soldering1169033soldering
speering113116323s_peering
sphering142811943s_phering
spiering112713353s_piering
sputtering13106463sputtering
steamering1345443steamering
steering93916793s_teering
stumming13347673stumm__ing
stuttering1196353stuttering
suberin9314563su_berin_
suberins10315093su_berins
submarine1347843submarine
subring104116263su__bring
subserving1644963subserving
subvening1546033subvening
subverting1666293subverting
succoring1445873succoring
sueding92613753su__eding
sufferings1743233sufferings
sugaring1039053su_garing
sulfuring1345783sulfuring
summaries13118183summaries
summarily1643833summarily
summarise13115733summarise
summarising1653563summarising
summarist13116763summarist
summarize22105653summarize
summarizing2544583summarizing
summer104017713summer___
summered1338143summer_ed
summeriest1476083summeriest
summerlike1873283summerlike
summerly15275103summer_ly
summers113616503summer__s
summerset1347253summerset
summertime1353023summertime
summery14329413summer__y
summonsing1543093summonsing
surmising1247683surmising
surveying1644963surveying
suspiring1245703suspiring
suturing9310373su_turing
syphering18175733syphering
tampering1438453tampering
tempering1438733tempering
timbering14117723timbering
tuckering1635693tuckering
ulcering1139333_ulcering
umpiring1336093_umpiring
unmewing1485913_unmewing
ushering1258923_ushering
uttering91613083_uttering
wuthering1697803wuthering

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.1561145455.1
2DLD Change Limit1486411597.70319296.5
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.92222556.3
 
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.