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

187 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
jittering1721842(None) 
bittering122511991bittering
littering102411981littering
tittering102310311tittering
battering122715142battering
bettering122212752bettering
buttering122312522buttering
chittering16107182chittering
dithering1499852dithering
fettering132310512fettering
filtering13199722filtering
flittering1486502flittering
frittering14105622frittering
gettering112310032gettering
glittering1296002glittering
guttering112410442guttering
jiggering1934302jiggering
jitterbug1941702jitterbug
jitterier1644432jitterier
kittening1434592kittening
lettering102112072lettering
mattering122314052mattering
mitering113015402mi_tering
muttering122611322muttering
nattering102212212nattering
pattering122314422pattering
pottering122612002pottering
puttering122611642puttering
sintering101014802sintering
sistering101213752sistering
skittering1535392skittering
tattering102212322tattering
tottering10229612tottering
twittering1444582twittering
uttering91613082_uttering
wintering13412362wintering
withering16108812withering
yattering132410442yattering
altering91917113_altering
attiring939483_attiring
bantering122414233bantering
bartering122313643bartering
battening12268853battening
bickering1837663bickering
bitewing1435293bi_tewing
bitterish1446133bitterish
bittern94810683bitter_n_
bitterns10428953bitter_ns
bitting103717293bitt__ing
blattering13108713blattering
blistering13107063blistering
blithering16116123blithering
bothering152210203bothering
cantering122417373cantering
catering112019903_catering
centering122915143centering
chattering16108643chattering
cindering13311223cindering
ciphering17217703ciphering
cittern9339143citter_n_
citterns10318123citter_ns
clattering13109233clattering
cluttering13106833cluttering
cratering12312653cratering
diapering1339033diapering
dickering1737463dickering
differing1746473differing
dittoing1036263ditt_oing
embittering1642943embittering
entering91920053_entering
faltering132211113faltering
fathering161010093fathering
fattening13287833fattening
festering132413173festering
fingering1439193fingering
fitting113516563fitt__ing
flattering1498743flattering
fluttering14106293fluttering
fostering132411263fostering
gartering112111573gartering
gathering1499463gathering
gibbering1534713gibbering
gingering1238873gingering
gittern8337503gitter_n_
gitterns9326573gitter_ns
gitting93215703gitt__ing
glistering12106423glistering
gutterings12224913gutterings
haltering132212003haltering
hindering14310273hindering
hitting113017273hitt__ing
imbittering1642353imbittering
inhering12913713_inhering
interning10315253_interning
interring10315423_interring
iteming1037753_i_teming
jabbering2134443jabbering
jeering153513043j__eering
jetting153815343jett__ing
jettying1933953jett_ying
jilting153211743jilt__ing
jitter133314993jitter___
jitterbugs2051603jitterbugs
jittered16267223jitter_ed
jitteriest1744553jitteriest
jitteriness1843273jitteriness
jitters144314473jitter__s
jittery17346443jitter__y
jointuring1843233jointuring
jotting152912773jott__ing
juddering1933763juddering
jutting153313713jutt__ing
juttying1933573jutt_ying
kippering18205443kippering
kitting123214443kitt__ing
kittling1336063kitt_ling
lathering13912253lathering
leistering1147983leistering
letterings11226003letterings
lightering15246113lightering
limbering1488793limbering
lingering11310513lingering
lippering14217883lippering
listening10128953listening
litterbag1242793litterbag
litterbug1242393litterbug
livering122012383li_vering
loitering1039683loitering
lustering102711203lustering
mastering122315303mastering
metering112915633_metering
misterming1538603misterming
mitring103514143mi_t_ring
mothering152110183mothering
mustering122212333mustering
neutering1038963neutering
nickering1636573nickering
niddering1255323niddering
nidering10510483ni_dering
niffering1645133niffering
oystering1337563oystering
paltering122612893paltering
patterning1346073patterning
peltering122011673peltering
pestering122315663pestering
petering112516813_petering
philtering1646253philtering
picturing1436033picturing
pilfering1536393pilfering
pitting103618873pitt__ing
portering122012303portering
pothering151911283pothering
rattening10288763rattening
reuttering1137573reuttering
roistering1148583roistering
scattering1398013scattering
scuttering1386633scuttering
shattering1498283shattering
shuttering1496563shuttering
silvering1337923silvering
simmering1467823simmering
simpering1449293simpering
sitting83519633sitt__ing
slithering1496893slithering
smattering1397583smattering
spattering13107793spattering
sputtering13106463sputtering
steering93916793_steering
stuttering1196353stuttering
swithering17105213swithering
teetering10239893teetering
tentering102313203tentering
tethering1339133tethering
tiering8315253__tiering
tillering1037883tillering
timbering14117723timbering
tinkering1437703tinkering
tittuping1242453tittuping
vittling1236143vitt_ling
waitering13310713waitering
watering122316313_watering
weltering13219493weltering
westering132112643westering
wildering1456743wildering
witting113417063witt__ing
wuthering1697803wuthering
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.406440125.6
2DLD Change Limit1486411876.93621430.4
3Display Results1871870.0802337.5
 (SQL Overall)1786911877.42224075.9
 
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.