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

162 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
moistly123661(None) 
mostly113110941mo_stly
bristly12178062bristly
costly114012332co_stly
gristly11187332gristly
hostly124210862ho_stly
jointly1735482jointly
mistily122612342m_istily
misty106120452m_ist_y
modestly14375582modestly
modishly1744582modishly
moiety1148222moiet_y
moist76033582moist__
moisten93110142moisten
moister94015372moister
mopishly1864052mopishly
mousily1239392mousily
noisily1038402noisily
thistly1395962thistly
apishly1535663apishly
beastly1277563beastly
bobstay1443983bobstay
bossily1237563bossily
boyishly1943663boyishly
briskly16165403briskly
bristle91910103bristle
brittly12165973brittly
cosily113613853co_sily
courtly1256923courtly
crisply14426523crisply
doily95321033doi__ly
epistle957893epistle
faintly1337083faintly
feistily1445263feistily
feisty12449293feist_y
firstly1335643firstly
fitly115114973_fi_tly
foist85730973foist__
foisted113210603foisted
foists95413983foist_s
ghastly14354563ghastly
ghostly14355103ghostly
grisly104310583gris_ly
gristle8169223gristle
hoist86433213hoist__
hoisted113411293hoisted
hoister103714203hoister
hoists95516023hoist_s
honestly14355933honestly
horsily1338843horsily
hotly115815483ho__tly
impishly1844093impishly
istle52214713__istle
joist125125653joist__
joisted15379173joisted
joists134711033joist_s
jostle13319863jo_stle
justly16307253_justly
lastly93310873_lastly
loosely1036723loosely
lousily1038333lousily
mainly11411493mai_nly
mainstay1344033mainstay
maist75535683maist__
maists85817573maist_s
measly113610443meas_ly
meetly1138673m_eetly
meister93114163meister
messily12298813messily
mildly12318243m_ildly
milty104720073m_ilt_y
ministry1385793ministry
minty106323903m_int_y
misally121111063m_isally
miserly12329823m_iserly
misery114113543m_isery
mislay113510683m_islay
misplay1436383m_isplay
misrely12319613m_isrely
missay114112143m_issay
missy105617563m_is_sy
mist66154533m_ist__
misted93625823m_isted
mister84728563m_ister
mists76633903m_ist_s
mity95528213m_i_t_y
mizzly19256103m_izzly
mobbishly2142693mobbishly
mobster11299213mobster
modally1338403modally
modesty13476983modest_y
modiste1039283modist_e
modistes1138643modistes
moil65534093moi__l_
moils76125753moi__ls
moistens10268773moistens
moistest1038763moistest
moistful1343853moistful
moisture1046653moisture
molly105222493mo__lly
moly96031913mo___ly
momently1546473momently
monist84324983monist__
monistic12311303monistic
monists93614783monist_s
monkishly2143353monkishly
monostely1444813monostely
monster93214603monster
monthly1535673monthly
moodily1358203moodily
moonily1248943moonily
moonishly1743733moonishly
mopingly1636013mopingly
morally12411493morally
morosely1345723morosely
morsel85815893morsel_
morsels94112663morsels
mosey105922873mo_s_ey
mossy105217063mo_s_sy
most66554203mo_st__
moste75925083mo_st_e
mosts76028543mo_st_s
motey105922953mo__tey
mothy136214553mo__thy
motley1139383mo__tley
mottle84116053mo_ttle
mousey115216193mous_ey
mousy106716943mous__y
mouthy14409063mo_uthy
movably17167043movably
movingly1735913movingly
mulishly1644893mulishly
muscly1337453m_uscly
mussily12279773mussily
mustily123613633m_ustily
musty105620953m_ust_y
noily86120993noi__ly
noisy86813363nois__y
nosily93712683no_sily
oilily93111723_oilily
oily77932253_oi__ly
pointy114913283point_y
popishly1844193popishly
portly114713403po_rtly
poshly1437723po_shly
priestly1345843priestly
quietly1945893quietly
robustly1342763robustly
roily86121113roi__ly
roister73516203roister
rosily93914713ro_sily
saintly1039343saintly
softly12457763so_ftly
swiftly1633733swiftly
thistle10107803thistle
toasty9509563toast_y
tonishly1445523tonishly
twisty12426863twist_y
vastly12508723_vastly
whistle13107533whistle
wisely122711713_wisely
wristy12509703wrist_y

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 Limit1340271626.84319586.0
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.31224438.0
 
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.