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

214 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
moonlet9241327(None) 
moonlets10247471moonlets
moonlit9229331moonlit
moonset92413041moonset
booklet132312642booklet
boomlet112412272boomlet
hooklet142510812hooklet
mooley11311632moo_ley
mooned94216642moon_ed
mooner85317832moon_er
moonier93714102moonier
mooniest103014172mooniest
moonless10278042moonless
moonsets10216412moonsets
rootlet73015732rootlet
tonlet62924702_tonlet
townlet1049732townlet
bomblet13412263bomblet
bonnet85524633_bonnet
boodle93215033boodle_
boodled113410933boodled
boodler103312003boodler
boodles103416043boodles
booklets14247123booklets
boomlets12246673boomlets
boonies93422483boonies
boonless10328353boonless
bootleg10276633bootleg
brooklet1456403brooklet
collet84030363_collet
cooled95224593coo_led
cooler84824713coo_ler
coolest9318643coo_lest
cornet84436733corn_et
coronet94227173coron_et
corslet9318063corslet
couplet114717943couplet
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doolee73018953doo_lee
doublet103914033doublet
droplet10312113droplet
fooled104317823foo_led
footle93914383footle_
footled113610763footled
footler104011873footler
footles103715713footles
foozle18369203foozle_
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
froglet11310063froglet
frontlet1147653frontlet
goblet93219483_goblet
goglet84618583_goglet
gooney106612313goon_ey
goonie73615563goonie_
goonier83612843goonier
goonies83618333goonies
gooniest93213003gooniest
hooklets15217203hooklets
hornet94926433horn_et
howlet123518343_howlet
inlet53732403__inlet
looney94712413loon_ey
loonie64216453loonie_
loonier73312683loonier
loonies73919543loonies
looniest83313253looniest
magnet9320663magn_et
mallet84433053m_allet
mantlet93620993mantlet
martlet93419153martlet
millet84030743m_illet
minuet82621033m_inuet
moaned94514173moan_ed
moaner84415113moan_er
mobile103613543mobile_
mobiles112813123mobiles
mobled113213183m_obled
modeled1139463modeled
modeler1039293modeler
module93011033module_
modules102511003modules
moguled1135933moguled
moiled94318863m_oiled
moiler84017263m_oiler
mole66251833m_o_le_
moles74747923m_o_les
molest85022743m_o_lest
molt66356163m_o_l_t
monde85723143m_onde_
mondes94322353m_ondes
money104826843m_on_ey
monger94418333m_onger
mongst93512603m_ongst
monie75631653m_onie_
monied94319463m_onied
monies83233163m_onies
monist84324983m_onist
monkey153710593m_onkey
monocle1139663monocle_
monocled1337113monocled
monocles12310673monocles
monocot11412013monocot
monoglot1146843monoglot
monolith1349673monolith
monolog10259353monolog
monomer11311893monomer
monte75829773m_onte_
montes84226933m_ontes
mooched153910533mooched
moocher143610673moocher
mooches143714453mooches
moodier103212203moodier
moodiest112712183moodiest
mooed85123983moo__ed
mool67533863moo_l__
moola75117033moo_l_a
moolah11409193moo_lah
moolas83615593moo_las
mooleys1236863moo_leys
mools76027173moo_l_s
moon67140813moon___
moonbeam1443233moonbeam
moonbow1443873moonbow
moondust1144013moondust
mooners94015343mooners
mooneye12116933mooneye
mooneyes1396113mooneyes
moonily1248943moonily
mooning103415553mooning
moonish123311043moonish
moonlight1544133moonlight
moonlike1476643moonlike
moonport1257193moonport
moons75331003moon__s
moonseed1154673moonseed
moonshot1346273moonshot
moonwort1367813moonwort
moony104818273moon__y
moored93814173moo_red
moorhen1236023moorhen
moorier93113073moorier
mooriest102812723mooriest
moose76327193moo_se_
moot67653623moo___t
mooted94120373moo_ted
mooter83921093moo_ter
moppet126915093m_oppet
morale85220553morale_
morales93619403morales
motet75641193m_o_tet
motile83818343motile_
motiles93317433motiles
motley1139383m_otley
mottle84116053mottle_
mottled10409973mottled
mottler94410343mottler
mottles93415803mottles
moult74728723m_oul_t
mounded113711983mounded
mount74128063moun__t
mounted103611533mounted
mounter93713173mounter
mullet84126823m_ullet
nonet54540843_non_et
noodle73212543noodle_
noodled9339923noodled
noodles83513193noodles
omelet8317073_omelet
oncet74626543__oncet
onset54730173__onset
oodles73517183_oodles
outlet63728683_outlet
owlet83324463__owlet
piolet83225643pio_let
poodle93112043poodle_
poodles103013513poodles
pooled94619813poo_led
pooler83819843poo_ler
rootle63214453rootle_
rootled83410533rootled
rootles73215633rootles
rootlets8308653rootlets
roundlet9209223roundlet
runlet63821413_runlet
sonnet65923503_sonnet
sooner64220463soon_er
soonest7415593soonest
toilet66228093_toilet
tonlets73212503_tonlets
tooled74918903too_led
tooler63818613too_ler
toonie63617993toonie_
toonies73719883toonies
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
townlets1134773townlets
unlet54133333__unlet
veinlet101310573veinlet
violet92620923vio_let
woodlot1147023woodlot
wooled103715503woo_led
woolen93111373woo_len
wooler93615873woo_ler
woolled1136643woolled
woollen1034723woollen
zooglea1733373zooglea
zooned164011083zoon_ed

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.436409841.7
2DLD Change Limit1340272147.23618522.2
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.74823062.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.