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

157 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
clattering1310923(None) 
blattering13108711blattering
chattering16108641chattering
cluttering13106831cluttering
flattering1498741flattering
battering122715142_battering
blathering16107582blathering
cantering122417372c_antering
catering112019902c_a_tering
chaptering18107962chaptering
chartering16109252chartering
chittering16107182chittering
clabbering17104582clabbering
clambering1776162clambering
clatteringly1852462clatteringly
clavering1538372cla_vering
clustering13116812clustering
cratering12312652cra_tering
flattening14115102flattening
flittering1486502flittering
fluttering14106292fluttering
glittering1296002glittering
lathering13912252_lathering
lettering102112072_lettering
littering102411982_littering
mattering122314052_mattering
nattering102212212_nattering
pattering122314422_pattering
plastering1339242plastering
scattering1398012scattering
shattering1498282shattering
slathering14108282slathering
smattering1397582smattering
spattering13107792spattering
splattering1454542splattering
tattering102212322_tattering
yattering132410442_yattering
altering91917113__altering
attiring939483__attiring
bantering122414233_bantering
bartering122313643_bartering
battening12268853_battening
betattering1444143betattering
bettering122212753_bettering
bittering122511993_bittering
blabbering14104363blabbering
blatting114111653blatt__ing
blethering16115933blethering
blistering13107063blistering
blithering16116123blithering
blustering13106183blustering
buttering122312523_buttering
calipering1545003calipering
cambering16109873c_ambering
cankering162110793c_ankering
capering132414963c_a_pering
capturing1436623c_apturing
careering12311203c_areering
catteries11815523c_atteries
catting103922643c_att__ing
centering122915143c_entering
chaffering22104643chaffering
chambering20116043chambering
chamfering21125333chamfering
chastening1656523chastening
chatting142810143chatt__ing
chuntering1647803chuntering
clamoring1477423cla_moring
clamouring15104773clamouring
clangoring1443913clangoring
clatter94014973clatter___
clattered12178403clatter_ed
clatterer11186983clatter_er
clatterers12155423clatterers
clatters103313913clatter__s
clattery13378193clatter__y
clinkering1745233clinkering
clobbering17103933clobbering
cloistering1444823cloistering
clotting113110643clott__ing
cloturing1245473cl_oturing
coattending1543543coattending
coattesting1443453coattesting
countering13314473countering
craterings1346003cra_terings
elaterin849903ela_terin_
elaterins9410033ela_terins
faltering132211113_faltering
fathering161010093_fathering
fattening13287833_fattening
feathering17108793feathering
fettering132310513_fettering
flatteries1347413flatteries
flatteringly1952563flatteringly
flatting123511253flatt__ing
flustering14105933flustering
frittering14105623frittering
gartering112111573_gartering
gathering1499463_gathering
gettering112310033_gettering
glistering12106423glistering
guttering112410443_guttering
haltering132212003_haltering
jittering17218423_jittering
laagering1136833_laagering
lackering1639373_lackering
laddering1237593_laddering
lagering102212313_la_gering
lappering14258843_lappering
latening9711493_la_tening
latticing1246063_latticing
laveering1336813_laveering
lawyering1655213_lawyering
layering122310353_la_yering
leathering1488683leathering
letterings11226003_letterings
loitering1039683_loitering
lustering102711203_lustering
mastering122315303_mastering
muttering122611323_muttering
paltering122612893_paltering
patterning1346073_patterning
plaistering1444603plaistering
plasterings1444743plasterings
platting114813033platt__ing
pottering122612003_pottering
puttering122611643_puttering
quartering2045843quartering
rattening10288763_rattening
realtering1139473realtering
relettering1255513relettering
reuttering1137573reuttering
scatterings14103973scatterings
scuttering1386633scuttering
shuttering1496563shuttering
skittering1535393skittering
slabbering15104973slabbering
slandering1237243slandering
slattern837093slatter_n_
slatterns935363slatter_ns
slatting94014233slatt__ing
slavering1338723sla_vering
slithering1496893slithering
smatterings14103843smatterings
spluttering1463363spluttering
sputtering13106463sputtering
squattering2143803squattering
stuttering1196353stuttering
tittering102310313_tittering
tottering10229613_tottering
twittering1444583twittering
uncluttering1551803uncluttering
unflattering1672043unflattering
uttering91613083__uttering
waitering13310713_waitering
watering122316313_wa_tering
weathering1798353weathering

Search took 7 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.406440125.6
2DLD Change Limit1406031576.19022714.5
3Display Results1571570.0762065.8
 (SQL Overall)1786911576.67226782.2
 
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.