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

188 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
gathering149946(None) 
fathering161010091fathering
gatherings15105291gatherings
lathering13912251lathering
adhering1338882_adhering
atheling1249202_atheling
battering122715142battering
blathering16107582blathering
bothering152210202bothering
catering112019902cat_ering
dithering1499852dithering
feathering17108792feathering
gandering122111292gandering
garnering11298082garnering
gartering112111572gartering
gettering112310032gettering
guttering112410442guttering
ingathering16103012ingathering
kashering1736252kashering
leathering1488682leathering
mattering122314052mattering
mothering152110182mothering
nattering102212212nattering
pattering122314422pattering
pothering151911282pothering
regathering1645202regathering
slathering14108282slathering
tattering102212322tattering
tethering1339132tethering
upgathering1842202upgathering
watering122316312wat_ering
weathering1798352weathering
withering16108812withering
wuthering1697802wuthering
yattering132410442yattering
altering91917113_altering
angering102113803_angering
antheming1587293antheming
ashlering1344153_ashlering
athelings1345113_athelings
attiring939483_attiring
authoring1348583authoring
badgering1436963badgering
bannering12208803bannering
bantering122414233bantering
barbering14229683barbering
bartering122313643bartering
bathing134816243bath__ing
battening12268853battening
bettering122212753bettering
bittering122511993bittering
blattering13108713blattering
blethering16115933blethering
blithering16116123blithering
brothering1646033brothering
butchering1844503butchering
buttering122312523buttering
cacheting1737153cacheting
cambering16109873cambering
cankering162110793cankering
cantering122417373cantering
capering132414963ca_pering
careering12311203careering
cashiering1643783cashiering
cathecting1844833cathecting
chattering16108643chattering
ciphering17217703ciphering
clattering13109233clattering
cohering142413833_cohering
coshering15510023coshering
cratering12312653crat_ering
cyphering20175243cyphering
dackering1737383dackering
daggering13246113daggering
daikering1536103daikering
dandering122511063dandering
dangering12239303dangering
entering91920053ent_ering
faltering132211113faltering
fathoming1844693fathoming
fattening13287833fattening
featherings18105373featherings
fettering132310513fettering
flattering1498743flattering
forgathering2052193forgathering
furthering1744353furthering
gaeing84617223ga__e_ing
gallerying1543033gallerying
galleting1137623galleting
gantleting1243913gantleting
gardening1236513gardening
garring93116713ga__rring
gashing125119233gash__ing
gather104115853gather___
gathered13149373gather_ed
gatherer12147903gather_er
gatherers13156883gatherers
gathers114315073gather__s
gating84826953gat___ing
gauffering1842453gauffering
gaveling133410163ga_veling
gendering12249753gendering
gibbering1534713gibbering
gingering1238873gingering
glittering1296003glittering
glowering1435653glowering
godfathering2151463godfathering
goffering1744483goffering
gutterings12224913gutterings
hachuring1845123hachuring
haltering132212003haltering
hammering1737633hammering
hampering1738863hampering
hankering17239383hankering
hatcheling1943693hatcheling
havering152211053ha_vering
ingatherings17101603ingatherings
inhering12913713_inhering
jabbering2134443jabbering
jittering17218423jittering
koshering1735363koshering
laagering1136833laagering
lackering1639373lackering
laddering1237593laddering
lagering102212313la_gering
lappering14258843lappering
latening9711493lat_ening
lathing114315693lath__ing
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
lechering1538443lechering
lettering102112073lettering
littering102411983littering
mammering1337333mammering
mastering122315303mastering
maturing1139953mat_uring
metering112915633met_ering
mitering113015403mit_ering
motherings16255643motherings
murthering1644473murthering
muttering122611323muttering
ochering14219393_ochering
outhearing1438443outhearing
paltering122612893paltering
pampering1638383pampering
pandering133211963pandering
papering132213313pa_pering
partnering1345553partnering
patterning1346073patterning
paupering1437273paupering
petering112516813pet_ering
pottering122612003pottering
puttering122611643puttering
racheting1537793racheting
ratcheting1643783ratcheting
rattening10288763rattening
sabering112113743sa_bering
saggering12197793saggering
scattering1398013scattering
shattering1498283shattering
slithering1496893slithering
smattering1397583smattering
smothering1646013smothering
spattering13107793spattering
sphering142811943_sphering
steering93916793_steering
swithering17105213swithering
syphering18175733syphering
tabering112211423ta_bering
tampering1438453tampering
tapering112112503ta_pering
theming133610473__theming
tiering8315253__tiering
tittering102310313tittering
tochering1537153tochering
tottering10229613tottering
ushering1258923_ushering
uttering91613083_uttering
wafering15208893wa_fering
wagering13219523wa_gering
waitering13310713waitering
wandering143310983wandering
waterings13229253wat_erings
wavering152410543wa_vering
weatherings1895263weatherings
yabbering1734023yabbering
yammering1735193yammering

Search took 8 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 Filter1786911486410.440406115.9
2DLD Change Limit1486411887.12320867.8
3Display Results1881880.0802350.0
 (SQL Overall)1786911887.64323379.7
 
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.