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

153 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
wuthering169780(None) 
withering16108811withering
authoring1348582authoring
bothering152210202bothering
butchering1844502butchering
buttering122312522buttering
dithering1499852dithering
fathering161010092fathering
furthering1744352furthering
gathering1499462gathering
guttering112410442guttering
lathering13912252lathering
mothering152110182mothering
murthering1644472murthering
muttering122611322muttering
outhearing1438442outhearing
pothering151911282pothering
puttering122611642puttering
swithering17105212swithering
tethering1339132tethering
ushering1258922_ushering
uttering91613082_uttering
watering122316312wat_ering
weathering1798352weathering
adhering1338883_adhering
altering91917113alt_ering
antheming1587293antheming
atheling1249203_atheling
battering122715143battering
bettering122212753bettering
bittering122511993bittering
blathering16107583blathering
blethering16115933blethering
blithering16116123blithering
brothering1646033brothering
buffering1835223buffering
buggering1435193buggering
bumpering1636593bumpering
bunkering16207103bunkering
burthening1643463burthening
busheling1535503busheling
catering112019903cat_ering
ciphering17217703ciphering
cluttering13106833cluttering
cohering142413833_cohering
coshering15510023coshering
cumbering16108203cumbering
cyphering20175243cyphering
entering91920053ent_ering
euchring1436613euch_ring
eutherian1246893eutherian
eutherians1345313eutherians
feathering17108793feathering
fettering132310513fettering
fluttering14106293fluttering
fullering1336653fullering
gatherings15105293gatherings
gettering112310033gettering
gutterings12224913gutterings
hungering14187683hungering
hunkering17227123hunkering
inhering12913713_inhering
jittering17218423jittering
juddering1933763juddering
kashering1736253kashering
koshering1735363koshering
leathering1488683leathering
lechering1538443lechering
lettering102112073lettering
littering102411983littering
lumbering14117933lumbering
lustering102711203lustering
luthern1037653luther_n_
lutherns1136293luther_ns
mattering122314053mattering
metering112915633met_ering
mitering113015403mit_ering
motherings16255643motherings
murdering1357133murdering
mustering122212333mustering
nattering102212213nattering
neutering1038963neut_ering
numbering14107003numbering
ochering14219393_ochering
outdaring1179723outdaring
outfiring1338163outfiring
outhomering1743903outhomering
outring84021023out__ring
outseeing1038333outseeing
outserving1446743outserving
outspring1238903outspring
outwearing1437183outwearing
pattering122314423pattering
petering112516813pet_ering
pottering122612003pottering
puckering1835883puckering
quavering2235953quavering
queering1838203qu_eering
quivering2235873quivering
reuttering1137573reuttering
rubbering1435703rubbering
scouthering1743483scouthering
scuttering1386633scuttering
shuttering1496563shuttering
slathering14108283slathering
slithering1496893slithering
smothering1646013smothering
sphering142811943_sphering
sputtering13106463sputtering
steering93916793_steering
stuttering1196353stuttering
suckering1638103suckering
suffering1637293suffering
summering1458753summering
sundering11312323sundering
supering11317683su_pering
suturing9310373sut_uring
syphering18175733syphering
tattering102212323tattering
theming133610473__theming
tiering8315253__tiering
tittering102310313tittering
tochering1537153tochering
tottering10229613tottering
tuckering1635693tuckering
tutoring938433tut_oring
tutoyering1442253tutoyering
twittering1444583twittering
ulcering1139333_ulcering
umbering1399433_umbering
uterine7315193_ut_erine
vouchering1943653vouchering
wafering15208893w_afering
wagering13219523w_agering
waitering13310713waitering
wandering143310983wandering
waterings13229253wat_erings
wavering152410543w_avering
weatherings1895263weatherings
weltering13219493weltering
westering132112643westering
whoring142910293w__horing
wildering1456743wildering
wintering13412363wintering
witheringly2152523witheringly
witherite1546693witherite
withing143814493with__ing
wondering142110463wondering
wuther124511613wuther___
wuthered15157433wuther_ed
wuthers133711523wuther__s
yattering132410443yattering
youthening1743723youthening

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 Filter1786911486410.440406115.9
2DLD Change Limit1486411535.86025365.4
3Display Results1531530.0602550.0
 (SQL Overall)1786911536.36028096.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.