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

260 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
wintering1341236(None) 
sintering101014801sintering
bantering122414232bantering
bittering122511992bittering
cantering122417372cantering
centering122915142centering
cindering13311222cindering
entering91920052_entering
filtering13199722filtering
fingering1439192fingering
gingering1238872gingering
hindering14310272hindering
inhering12913712_inhering
interning10315252_interning
interring10315422_interring
jittering17218422jittering
lingering11310512lingering
littering102411982littering
mitering113015402mi_tering
sistering101213752sistering
tentering102313202tentering
tinkering1437702tinkering
tittering102310312tittering
twittering1444582twittering
waitering13310712waitering
wandering143310982wandering
watering122316312w_atering
weltering13219492weltering
westering132112642westering
wildering1456742wildering
winterier1238332winterier
winterish1546642winterish
winterize2146922winterize
winterizing2446052winterizing
wintling12249922wint_ling
withering16108812withering
wondering142110462wondering
altering91917113_altering
angering102113803_angering
anteing8312813_ante_ing
bannering12208803bannering
bartering122313643bartering
battering122715143battering
bettering122212753bettering
bickering1837663bickering
bingeing12237643binge_ing
binturong12112073binturong
bitewing1435293bi_tewing
blinkering1744323blinkering
blistering13107063blistering
bunkering16207103bunkering
buttering122312523buttering
cankering162110793cankering
catering112019903_catering
centerings13247663centerings
centring112112953cent_ring
chittering16107183chittering
chuntering1647803chuntering
cincturing1554263cincturing
cinerin9313823cin_erin_
cinerins10414103cin_erins
ciphering17217703ciphering
clinkering1745233clinkering
coinhering1647313coinhering
cointerring1447153cointerring
countering13314473countering
cratering12312653cratering
dandering122511063dandering
dangering12239303dangering
diapering1339033diapering
dickering1737463dickering
differing1746483differing
dinting93520553dint__ing
dithering1499853dithering
faltering132211113faltering
festering132413173festering
fettering132310513fettering
fingerings1545073fingerings
fingerling1544833fingerling
flittering1486503flittering
fostering132411263fostering
frittering14105623frittering
gandering122111293gandering
gartering112111573gartering
gendering12249753gendering
gettering112310033gettering
gibbering1534713gibbering
glistering12106423glistering
glittering1296003glittering
guttering112410443guttering
haltering132212003haltering
hankering17239383hankering
hinting113919223hint__ing
hungering14187683hungering
hunkering17227123hunkering
inbeing1038333_inbe_ing
indexing1737123_indexing
inferring1338613_inferring
injuring1637473_injuring
innerving1346503_innerving
inserting10914243_inserting
insuring9311153_insuring
intending1139983_intending
intergang11117893_intergang
interim9912873_interi_m
interims101013073_interims
interior8513093_interior
interline91218013_interline
interlink131310663_interlink
intern64016543_inter_n_
interne73218153_inter_ne
interns73116773_inter_ns
intoning9311123_intoning
intorting10311413_intorting
inuring81213013_in_uring
inversing1389623_inversing
inverting131013223_inverting
iteming1037753_i_teming
jiggering1934303jiggering
jointuring1843233jointuring
kippering18205443kippering
kittening1434593kittening
leistering1147983leistering
lettering102112073lettering
lightering15246113lightering
limbering1488793limbering
linting83820983lint__ing
lippering14217883lippering
listening10128953listening
livering122012383li_vering
loitering1039683loitering
lustering102711203lustering
mastering122315303mastering
mattering122314053mattering
mentoring1239543mentoring
metering112915633_metering
ministering1445543ministering
minoring11311473min_oring
minting103020813mint__ing
misentering1446373misentering
misterming1538603misterming
mitring103514143mi_t_ring
mongering13310353mongering
mustering122212333mustering
muttering122611323muttering
nattering102212213nattering
neutering1038963neutering
nickering1636573nickering
niddering1255323niddering
nidering10510483ni_dering
niffering1645133niffering
oystering1337563oystering
paltering122612893paltering
pandering133211963pandering
pattering122314423pattering
peltering122011673peltering
pestering122315663pestering
petering112516813_petering
philtering1646253philtering
picturing1436033picturing
pilfering1536393pilfering
pinkening1634993pinkening
pioneering1354393pioneering
pondering132411333pondering
portering122012303portering
pottering122612003pottering
puttering122611643puttering
reentering1149983reentering
reinterring1245363reinterring
rendering112213183rendering
roistering1148593roistering
sauntering1137223sauntering
silvering1337923silvering
simmering1467823simmering
simpering1449293simpering
sinewing1267593sin_ewing
singeing10209933singe_ing
skittering1535393skittering
sneering93414503_sneering
splintering1444293splintering
sundering11312323sundering
sweltering1445233sweltering
swingeing14144693swinge_ing
swithering17105213swithering
tattering102212323tattering
teetering10239893teetering
tendering112210813tendering
tiering8315253ti__ering
tillering1037883tillering
timbering14117723timbering
tincturing1343323tincturing
tingeing10198553tinge_ing
tinseling1036643tinseling
tinting84620603tint__ing
tottering10229613tottering
twingeing14143393twinge_ing
untiring9312003_untiring
uttering91613083_uttering
veneering1337663veneering
venturing1337553venturing
wafering15208893w_afering
wagering13219523w_agering
wanderings15215833wanderings
wanting114220173want__ing
wantoning1337083wantoning
waterings13229253w_aterings
wavering152410543w_avering
weathering1798353weathering
whickering2343413whickering
whimpering2143853whimpering
whingeing1733533whinge_ing
whispering1944343whispering
whitening1635103whitening
whitewing1943853whitewing
widening13237833wi_dening
wilting113515913wilt__ing
winching17359903win_ching
wincing133413903win__cing
winding123517913win__ding
windling132212263win_dling
windowing1744813windowing
wineries112316533win_eries
wingding1436453win_gding
winging123718713win__ging
wining103625053win___ing
winking153317963win__king
winkling16298293win_kling
winning113516553win__ning
winnowing1643363winnowing
winter94222803winter___
wintered122111573winter_ed
winterer112110443winter_er
winterers12209723winterers
winterfed1644993winterfed
winteriest1348813winteriest
winterized2345713winterized
winterizes2247143winterizes
winterkill1752313winterkill
winterly14306743winter_ly
winters103720483winter__s
wintertide1444463wintertide
wintertime1543813wintertime
wintery13399753winter__y
wintrier1136873wint_rier
wintrily1445373wint_rily
wiring104521023wi___ring
wisteria1147763wisteri_a
wisterias1248113wisterias
wisting113519743wist__ing
witching173410633wi_tching
withing143814493wi_t_hing
witing103522823wi_t__ing
witling113215813wi_t_ling
witnessing1442443witnessing
witting113417063wi_t_ting
wizening21255463wi_zening
wonting113214103wont__ing
wuthering1697803wuthering
yattering132410443yattering
zippering23215203zippering

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 Limit1486412606.50022867.8
3Display Results2602600.1262063.5
 (SQL Overall)1786912607.04625360.6
 
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.