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

113 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
blathering1610758(None) 
blattering13108711blattering
blethering16115931blethering
blithering16116121blithering
lathering13912251_lathering
slathering14108281slathering
battering122715142b_attering
blabbering14104362blabbering
bothering152210202b_othering
brothering1646032brothering
clattering13109232clattering
fathering161010092_fathering
feathering17108792feathering
flattering1498742flattering
gathering1499462_gathering
leathering1488682leathering
slithering1496892slithering
weathering1798352weathering
adhering1338883__adhering
altering91917113al_t_ering
atheling1249203__atheling
badgering1436963b_adgering
bannering12208803b_annering
bantering122414233b_antering
barbering14229683b_arbering
bartering122313643b_artering
bathing134816243b_ath__ing
battening12268853b_attening
beavering1538703bea_vering
betattering1444143betattering
bettering122212753b_ettering
bittering122511993b_ittering
blackening1944793blackening
blanketing1743323blanketing
blaring104317113bla___ring
blarneying1641943blarneying
blaspheming2151833blaspheming
blather125314203blather___
blathered15168353blather_ed
blatherer14176713blather_er
blatherers15175343blatherers
blathers134713793blather__s
blatting114111653blat__ting
blinkering1744323blinkering
blistering13107063blistering
blubbering14103443blubbering
blundering1444823blundering
blustering13106183blustering
bolstering1346883bolst_ering
burthening1643463burthening
butchering1844503butchering
buttering122312523b_uttering
catering112019903_cat_ering
chattering16108643chattering
clabbering17104583clabbering
clambering1776163clambering
clavering1538373cla_vering
cluttering13106833cluttering
cratering12312653crat_ering
dithering1499853_dithering
elaterin849903elat_erin_
elaterins9410033elat_erins
faltering132211113falt_ering
featherings18105373featherings
flattening14115103flattening
flittering1486503flittering
fluttering14106293fluttering
furthering1744353furthering
gatherings15105293_gatherings
glittering1296003glittering
haltering132212003halt_ering
ingathering16103013ingathering
kashering1736253_kashering
laagering1136833_laagering
lackering1639373_lackering
laddering1237593_laddering
lagering102212313_la_gering
lappering14258843_lappering
latening9711493_lat_ening
lathing114315693_lath__ing
laveering1336813_laveering
lawyering1655213_lawyering
layering122310353_la_yering
lechering1538443_lechering
lettering102112073_lettering
littering102411983_littering
mattering122314053_mattering
mothering152110183_mothering
murthering1644473murthering
nattering102212213_nattering
paltering122612893palt_ering
pattering122314423_pattering
plastering1339243plastering
pothering151911283_pothering
regathering1645203regathering
scattering1398013scattering
shattering1498283shattering
slabbering15104973slabbering
slandering1237243slandering
slavering1338723sla_vering
smattering1397583smattering
smothering1646013smothering
spattering13107793spattering
splattering1454543splattering
swithering17105213swithering
tattering102212323_tattering
tethering1339133_tethering
upgathering1842203upgathering
watering122316313_wat_ering
weatherings1895263weatherings
withering16108813_withering
wuthering1697803_wuthering
yattering132410443_yattering

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.203880251.2
2DLD Change Limit1406031136.48321688.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.73226543.5
 
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.