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

120 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
slathering1410828(None) 
blathering16107581blathering
lathering13912251_lathering
slithering1496891slithering
blattering13108712blattering
blethering16115932blethering
blithering16116122blithering
clattering13109232clattering
fathering161010092_fathering
feathering17108792feathering
flattering1498742flattering
gathering1499462_gathering
leathering1488682leathering
scattering1398012scattering
shattering1498282shattering
slabbering15104972slabbering
slandering1237242slandering
slavering1338722sla_vering
smattering1397582smattering
smothering1646012smothering
spattering13107792spattering
splattering1454542splattering
swithering17105212swithering
weathering1798352weathering
adhering1338883__adhering
altering91917113al_t_ering
atheling1249203__atheling
battering122715143_battering
blabbering14104363blabbering
bothering152210203_bothering
brothering1646033brothering
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
sabering112113743s_a_bering
saggering12197793s_aggering
scampering1745323scampering
scarpering1545413scarpering
scathing14269703scath__ing
scatterings14103973scatterings
scouthering1743483scouthering
scuttering1386633scuttering
shuttering1496563shuttering
sintering101014803sint_ering
sistering101213753sist_ering
skittering1535393skittering
slackening1744343slackening
slashing123713413slash__ing
slather103816073slather___
slathered13148543slather_ed
slathers113914783slather__s
slating83724653slat___ing
slattern837093slatter_n_
slatterns935363slatter_ns
slatting94014233slat__ting
slaughtering1752253slaughtering
slivering1338083sl_ivering
slobbering15103883slobbering
slubbering15124923slubbering
slumbering15105323slumbering
smatterings14103843smatterings
sphering142811943s__phering
spluttering1463363spluttering
sputtering13106463sputtering
squattering2143803squattering
staggering13194583staggering
stammering1544523stammering
steering93916793s__teering
stuttering1196353stuttering
swaggering16233623swaggering
swathing15248713swath__ing
syphering18175733s_yphering
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.423422437.4
2DLD Change Limit1406031206.28022389.0
3Display Results1201200.0631904.8
 (SQL Overall)1786911206.76626410.1
 
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.