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

144 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
notedly113688(None) 
cowedly1635702cowedly
datedly1236022datedly
mutedly1345752mutedly
nakedly1534402nakedly
notably12199992notably
noted65123842noted__
novelly1346512novelly
sottedly1244302sottedly
unitedly1245792unitedly
wontedly1544252wontedly
addedly1344293addedly
agedly1136463_agedly
avowedly1842353avowedly
bigotedly1642663bigotedly
boldly12399423bo_ldly
botchedly2042593botchedly
botel75121863bote_l_
botels84815803bote_ls
botfly1436093bot_fly
coldly12459953co_ldly
comedy14378233comed_y
comely134213733come_ly
coted85033853coted__
cutely115312803cute_ly
dazedly2134063dazedly
devotedly1742563devotedly
doggedly1543103doggedly
dotardly1343843dotardly
doted75227073doted__
dottily1147283dottily
elatedly1244793elatedly
fadedly1535453fadedly
fetidly1435013fetidly
fixedly2133913fixedly
fondly13299043fo_ndly
forcedly1744803forcedly
forkedly1944323forkedly
giftedly1642933giftedly
godly104913293go__dly
goodly11419303go_odly
gorgedly1444003gorgedly
heatedly1546053heatedly
homely145313183home_ly
hotel85520753hote_l_
hotels94515523hote_ls
hotly115815483hot__ly
huntedly1543583huntedly
jadedly1934013jadedly
jointedly20132723jointedly
knottily1543153knottily
lately93413843late_ly
lonely92912473lone_ly
lordly1038753lo_rdly
loudly1037783lo_udly
lovely12339713love_ly
loverly1346973loverly
mattedly1443883mattedly
mazedly2234433mazedly
mixedly2033983mixedly
moltenly1344583moltenly
motel76623243mote_l_
motels83616903mote_ls
motey105922953mote__y
motherly16346093motherly
mutely113811653mute_ly
namely113711323name_ly
nattily103610323nattily
neddy10479873n__eddy
needily1166323n_eedily
needle73310613n_eedle
needy94614693n_eed_y
nelly84618813n__elly
neoteny1045023neote_ny
nettly9459453net_tly
newly114610203n__ewly
nicely1139493nice_ly
nitery94412173nite_ry
nobbily1436693nobbily
nobly105314403no__bly
nobody1235743nobod_y
nodally1137913nodally
noddle83211363no_ddle
noddy105411203no__ddy
noel45226553no_e_l_
noels56418703no_e_ls
noily86120993no__ily
noisily1038403noisily
nonoily1049543nonoily
noodle73212543no_odle
noonday1144603noonday
northerly1543523northerly
nosed65524553nosed__
nosegay1143843nosegay
nosey85619883nose__y
nosily93712683no_sily
notable92114903notable
notal55221353not_al_
notary92310713not_ary
note46239963note___
notepad1044123notepad
noter55025643note__r
noters64021003note_rs
notes55034583note__s
notify1236943not_ify
novel85615993nove_l_
novella1076213novella
novelle1058233novelle
novels95512503nove_ls
novelty1365173novelty
nudely10299033nude_ly
nuttily10308633nuttily
oddly1037163_o_ddly
openly1137123_openly
overly122411363_overly
pettedly1443893pettedly
pointedly15133673pointedly
potbelly1544213potbelly
potency1457433potency
potently1347403potently
redly94217203__redly
rottenly1144153rottenly
rotundly1243433rotundly
roundly1136723roundly
snottily1145553snottily
soberly1236943soberly
solely93714213sole_ly
solidly1137353solidly
someday1345883someday
sorely94618013sore_ly
soundly1136683soundly
statedly1245833statedly
steely93612573_steely
studly10397693_studly
teddy10489493__teddy
telly84920823__telly
tiredly1136803tiredly
totally1039893totally
toted64929483toted__
unwontedly1752513unwontedly
utterly1035443utterly
vexedly2143463vexedly
voted93919143voted__
worldly1433993worldly

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271446.94019312.2
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.40624127.9
 
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.