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

248 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
westering13211264(None) 
festering132413171festering
pestering122315661pestering
weltering13219491weltering
bettering122212752bettering
centering122915142centering
entering91920052_entering
fettering132310512fettering
fostering132411262fostering
gesturing1136652gesturing
gettering112310032gettering
leistering1147982leistering
lettering102112072lettering
lustering102711202lustering
mastering122315302mastering
metering112915632me_tering
mustering122212332mustering
neutering1038962neutering
oystering1337562oystering
peltering122011672peltering
petering112516812pe_tering
restoring10314612restoring
restring91518782rest_ring
sistering101213752sistering
sweltering1445232sweltering
teetering10239892teetering
tentering102313202tentering
vesturing1337202vesturing
waitering13310712waitering
watering122316312w_atering
weathering1798352weathering
western102911102wester_n_
westerns11328962wester_ns
westing115020272west__ing
wintering13412362wintering
absterging1453353absterging
altering91917113_altering
answering1345803answering
bantering122414233bantering
bartering122313643bartering
battering122715143battering
beavering1538703beavering
beseeming1435143beseeming
besetting12268423besetting
besieging1344763besieging
besmearing1544323besmearing
besteading1446033besteading
besting104923923best__ing
bestirring1343993bestirring
bestowing1535803bestowing
bestrewing1643773bestrewing
bittering122511993bittering
blistering13107063blistering
blustering13106183blustering
bolstering1346883bolstering
buttering122312523buttering
cantering122417373cantering
catering112019903_catering
centerings13247663centerings
centring112112953cent_ring
clustering13116813clustering
coshering15510023coshering
cratering12312653cratering
delustering1344073delustering
deserting11713143des_erting
deserving1497903des_erving
desexing1736293des_exing
desiring10312143des_iring
destining11311433destining
deterging1237853de_terging
deterring1138623de_terring
dewatering1545773dewatering
eserine7415903_es_erine
estating92614993_estating
esteeming1244703_esteeming
esterify1445623_esterify
estrin6315923_est_rin_
estrins7315853_est_rins
faltering132211113faltering
fastening13268603fastening
feathering17108793feathering
featuring1337323featuring
fevering152510083fe_vering
filtering13199723filtering
flustering14105933flustering
fosterling1445173fosterling
gartering112111573gartering
gendering12249753gendering
gestating11229983gestating
glistering12106423glistering
guttering112410443guttering
haltering132212003haltering
hastening13259483hastening
hectoring1538303hectoring
holstering1447083holstering
hosteling1337893hosteling
jeering153513043je__ering
jesting154317713jest__ing
jittering17218423jittering
kashering1736253kashering
koshering1735363koshering
leathering1488683leathering
lechering1538443lechering
lecturing1237303lecturing
leering83417643le__ering
lessening1045333lessening
letterings11226003letterings
levering122212503le_vering
listening10128953listening
littering102411983littering
lobstering1345123lobstering
loitering1039683loitering
lustring9269723lust_ring
mattering122314053mattering
mentoring1239543mentoring
metring103215293me_t_ring
misterming1538603misterming
mitering113015403_mitering
muttering122611323muttering
nattering102212213nattering
neatening1038353neatening
nesting84320443nest__ing
nestling958893nest_ling
oestrin7312243oest_rin_
oestrins8312673oest_rins
oysterings1443903oysterings
paltering122612893paltering
pastoring12310853pastoring
pasturing1238433pasturing
pattering122314423pattering
peering103520353pe__ering
peppering1337083peppering
pestling111010253pest_ling
plastering1339243plastering
portering122012303portering
posturing1238993posturing
pottering122612003pottering
prestoring13310303prestoring
puttering122611643puttering
realtering1139473realtering
reentering1149983reentering
registering1346393registering
remastering1446843remastering
rendering112213183rendering
rescoring12310603rescoring
reseeding112410493reseeding
reseeing92412623res_eeing
reseeking14208493reseeking
reserving131110643res_erving
resetting102816293resetting
resewing122712263res_ewing
respiring12159903respiring
respring111614063res_pring
restaging112410853restaging
restarting11310663restarting
restating102319413restating
resting85031183rest__ing
restoking1438193restoking
restrings10159293rest_rings
restrung9176443rest_rung
restyling1337923restyling
retearing102214253re_tearing
retiring92717413re_tiring
reuttering1137573reuttering
revering122918073re_vering
roistering1148593roistering
roystering1445413roystering
sceptering1545793sceptering
sectoring1239583sectoring
sering74731813__s_ering
severing122013853se_vering
sewering122411093se_wering
sheltering1446493sheltering
sintering101014803sintering
skeltering1545003skeltering
staring84527053__staring
steering93916793__steering
sterling93615553__sterling
stewing113412493__stewing
storing83921123__storing
string75327563__st_ring
sweetening14134133sweetening
tattering102212323tattering
teddering12256303teddering
telfering1336253telfering
tempering1438733tempering
tendering112210813tendering
testing86021053test__ing
tethering1339133tethering
texturing1735223texturing
tittering102310313tittering
tottering10229613tottering
twittering1444583twittering
unstring9312093unst_ring
upstaring1235963upstaring
ushering1258923_ushering
uttering91613083_uttering
vectoring1537413vectoring
veering113213683ve__ering
veneering1337663veneering
venturing1337553venturing
vesting114618683vest__ing
wafering15208893w_afering
wagering13219523w_agering
wandering143310983wandering
wasterie111211583wasteri_e
wasteries121115343wasteries
wasting114422843wast__ing
waterings13229253w_aterings
wavering152410543w_avering
weakening1734843weakening
wearing113318863we__aring
weaseling1335613weaseling
weatherings1895263weatherings
wedeling1338773we_deling
weeding123815213we__eding
weening114113973we__ening
weeping133613673we__eping
weeting113816053we__eting
weeweeing1641783weeweeing
welting113615313welt__ing
wester94222893wester___
westered122511873wester_ed
westerlies1345613westerlies
westerly1445553wester_ly
westerner1244963westerner
westernise1344273westernise
westernising1653063westernising
westernize2244143westernize
westernizing2553723westernizing
westers105221963wester__s
westings12429803west__ings
wetting114117383we_t_ting
whispering1944343whispering
whitening1635103whitening
whitewing1943853whitewing
wildering1456743wildering
wisteria1147763wisteri_a
wisterias1248113wisterias
wisting113519743wist__ing
withering16108813withering
wondering142110463wondering
wresting123811833wrest__ing
wrestling1336063wrest_ling
wuthering1697803wuthering
yattering132410443yattering
yestern10338643yester_n_
zesting174515333zest__ing

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 Limit1486412487.37620152.0
3Display Results2482480.1261968.3
 (SQL Overall)1786912487.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.