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

138 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
chattering1610864(None) 
chaptering18107961chaptering
chartering16109251chartering
chittering16107181chittering
clattering13109231clattering
shattering1498281shattering
battering122715152_battering
blattering13108722blattering
cantering122417382c_antering
catering112019912c_a_tering
chaffering22104642chaffering
chambering20116042chambering
chamfering21125332chamfering
chastening1656522chastening
chatting142810142chatt__ing
chuntering1647802chuntering
cluttering13106832cluttering
cratering12312652cra_tering
flattering1498742flattering
haltering132212012_haltering
mattering122314062_mattering
nattering102212222_nattering
pattering122314432_pattering
scattering1398012scattering
shuttering1496562shuttering
smattering1397582smattering
spattering13107792spattering
tattering102212332_tattering
yattering132410452_yattering
altering91917123__altering
attiring939483__attiring
bantering122414243_bantering
bartering122313653_bartering
battening12268863_battening
betattering1444143betattering
bettering122212763_bettering
bittering122512003_bittering
blathering16107583blathering
buttering122312533_buttering
cambering16109873c_ambering
cankering162110793c_ankering
capering132414963c_a_pering
capturing1436623c_apturing
careering12311203c_areering
catteries11815553c_atteries
catting103922643c_att__ing
centering122915143c_entering
chairing143110773cha__iring
changeling1745673changeling
channeling1645203channeling
chanting143413533chant__ing
charactering2053713charactering
charing133721323cha___ring
charring142913163cha__rring
charting142614193chart__ing
chasseing1554963chasse_ing
chastising1654883chastising
chatter124416643chatter___
chatterbox2451533chatterbox
chattered15198003chatter_ed
chatterer14196843chatter_er
chatterers15205463chatterers
chatters134213953chatter__s
chattery16357273chatter__y
checkering2244403checkering
cheering143612703ch__eering
chequering2543123chequering
chippering2045163chippering
chitterlings1851413chitterlings
choppering2064813choppering
chowdering2044163chowdering
clabbering17104583clabbering
clambering1776163clambering
clatteringly1852463clatteringly
clavering1538373cla_vering
clustering13116813clustering
coattending1543543coattending
coattesting1443453coattesting
countering13314473countering
craterings1346003cra_terings
faltering132211123_faltering
fathering161010093_fathering
fattening13287833_fattening
feathering17108793feathering
fettering132310513_fettering
flattening14115103flattening
flittering1486503flittering
fluttering14106293fluttering
frittering14105623frittering
gartering112111593_gartering
gathering1499463_gathering
gettering112310033_gettering
glittering1296003glittering
guttering112410443_guttering
hammering1737633_hammering
hampering1738863_hampering
hankering17239383_hankering
hastening13259483_hastening
hatteria1137883_hatteri_a
hatterias1258763_hatterias
hatting113920233_hatt__ing
havering152211053_ha_vering
jittering17218423_jittering
lathering13912253_lathering
leathering1488683leathering
lettering102112073_lettering
littering102411983_littering
mastering122315313_mastering
muttering122611323_muttering
paltering122612903_paltering
patterning1346073_patterning
philtering1646253philtering
plastering1339243plastering
pottering122612003_pottering
puttering122611643_puttering
quartering2045853quartering
rattening10288763_rattening
realtering1139473realtering
rechartering1853543rechartering
reuttering1137573reuttering
scatterings14103973scatterings
scuttering1386633scuttering
shatteringly1962383shatteringly
sheltering1446493sheltering
skittering1535393skittering
slathering14108283slathering
smatterings14103843smatterings
splattering1454543splattering
sputtering13106463sputtering
squattering2143803squattering
stuttering1196353stuttering
tittering102310313_tittering
tottering10229613_tottering
twittering1444583twittering
uttering91613083__uttering
waitering13310723_waitering
watering122316323_wa_tering
weathering1798353weathering

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 Filter1786911406030.436409841.7
2DLD Change Limit1406031388.62616299.9
3Display Results1381380.0761815.8
 (SQL Overall)1786911389.13819554.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.