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

147 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
spattering1310779(None) 
pattering122314421_pattering
scattering1398011scattering
shattering1498281shattering
smattering1397581smattering
splattering1454541splattering
sputtering13106461sputtering
battering122715142_battering
bespattering1752342bespattering
blattering13108712blattering
chattering16108642chattering
clattering13109232clattering
flattering1498742flattering
mattering122314052_mattering
nattering102212212_nattering
paltering122612892_paltering
patterning1346072_patterning
pottering122612002_pottering
puttering122611642_puttering
scatterings14103972scatterings
scuttering1386632scuttering
shuttering1496562shuttering
skittering1535392skittering
slathering14108282slathering
smatterings14103842smatterings
spatting113111762spatt__ing
spluttering1463362spluttering
squattering2143802squattering
stuttering1196352stuttering
tattering102212322_tattering
yattering132410442_yattering
altering91917113__altering
attiring939483__attiring
bantering122414233_bantering
bartering122313643_bartering
battening12268853_battening
betattering1444143betattering
bettering122212753_bettering
bittering122511993_bittering
blathering16107583blathering
buttering122312523_buttering
cantering122417373_cantering
catering112019903_ca_tering
chaptering18107963chaptering
chartering16109253chartering
chittering16107183chittering
cluttering13106833cluttering
cratering12312653cra_tering
espaliering1442693espaliering
faltering132211113_faltering
fathering161010093_fathering
fattening13287833_fattening
feathering17108793feathering
fettering132310513_fettering
flattening14115103flattening
flittering1486503flittering
fluttering14106293fluttering
frittering14105623frittering
gartering112111573_gartering
gathering1499463_gathering
gettering112310033_gettering
glittering1296003glittering
guttering112410443_guttering
haltering132212003_haltering
jittering17218423_jittering
lathering13912253_lathering
leathering1488683leathering
lettering102112073_lettering
littering102411983_littering
mastering122315303_mastering
muttering122611323_muttering
pampering1638383_pampering
pandering133211963_pandering
papering132213313_pa_pering
partnering1345553_partnering
pastoring12310853_pastoring
pasturing1238433_pasturing
pattern93712053_patter_n_
patternings1443183_patternings
patterns10439943_patter_ns
patting103722343_patt__ing
paupering1437273_paupering
peltering122011673_peltering
pestering122315663_pestering
petering112516813_p_etering
plastering1339243plastering
portering122012303_portering
pothering151911283_pothering
quartering2045843quartering
rattening10288763_rattening
realtering1139473realtering
repatterning1552173repatterning
reuttering1137573reuttering
sabering112113743s_a_bering
saggering12197793s_aggering
sauntering1137223sauntering
sauteing937913s_aute_ing
scampering1745323scampering
scarpering1545413scarpering
scatteringly1872493scatteringly
scatting113311813scatt__ing
sceptering1545793sceptering
shatteringly1962383shatteringly
sheltering1446493sheltering
sintering101014803s_intering
sistering101213753s_istering
skeltering1545003skeltering
slabbering15104973slabbering
slandering1237243slandering
slattern837093slatter_n_
slatterns935363slatter_ns
slatting94014233slatt__ing
slavering1338723sla_vering
slithering1496893slithering
smartening1344993smartening
smothering1646013smothering
spaeing103413543spa__e_ing
spanceling1543943spanceling
sparing104823873spa___ring
sparring113112223spa__rring
sparteine1185483sparte_ine
spatter94016523spatter___
spattered12187643spatter_ed
spatters103914703spatter__s
speering113116323sp__eering
sphering142811943sp__hering
spiering112713353sp__iering
spitting113012323spitt__ing
splatting1235983splatt__ing
splintering1444293splintering
spotting112812093spott__ing
sprattling1363053spratt_ling
staggering13194583staggering
stammering1544523stammering
steering93916793s__teering
swaggering16233623swaggering
swatting12309593swatt__ing
sweltering1445233sweltering
swithering17105213swithering
tittering102310313_tittering
tottering10229613_tottering
twittering1444583twittering
upgathering1842203upgathering
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 Limit1406031475.97023551.6
3Display Results1471470.0602450.0
 (SQL Overall)1786911476.43627764.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.