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 “moonlit” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
moonlit922933(None) 
moonlet92413271moonlet
monolith1349672monolith
moonily1248942moonily
moonlets10247472moonlets
moonlight1544132moonlight
moonlike1476642moonlike
moonset92413042moonset
booklet132312643booklet
boomlet112412273boomlet
confit113316403_confit
coolie83821603coo_lie
coontie9311423coontie
doolie73916833doo_lie
floodlit1244073floodlit
goonie73615563goon_ie
hooklet142510813hooklet
hoolie93217783hoo_lie
loonie64216453loon_ie
loonily1037073loonily
mislit83019693m_islit
mobility1548543mobility
modality14117653modality
modelist11310503modelist
moduli9267963moduli_
mohalim1446033mohalim
mohelim1444763mohelim
molality13118363molality
mollie83517103m_ollie
molt66356163m_o_l_t
mongst93512603m_ongst
monie75631653m_on_ie
monist84324983m_onist
monocot11412013monocot
monodic1269783monodic
monodist11310923monodist
monofil1247273monofil
monoglot1146843monoglot
monoliths1445913monoliths
monolog10259353monolog
monotint10413713monotint
moodily1358203moodily
mool67533863moo_l__
moola75117033moo_l_a
moolah11409193moo_lah
moolas83615593moo_las
mooley11311633moo_ley
mools76027173moo_l_s
moon67140813moon___
moonblind1442853moonblind
moonbow1443873moonbow
moondust1144013moondust
mooned94216643moon_ed
mooner85317833moon_er
mooners94015343mooners
mooneye12116933mooneye
moonfish1675333moonfish
moonier93714103moonier
mooniest103014173mooniest
mooning103415553mooning
moonish123311043moonish
moonless10278043moonless
moonlights1642993moonlights
moonport1257193moonport
moonrise1046783moonrise
moons75331003moon__s
moonsail1045253moonsail
moonsets10216413moonsets
moonshot1346283moonshot
moonwort1367813moonwort
moony104818273moon__y
moot67653623moo___t
moralist10316663moralist
morality131110333morality
moronic11311863moron_ic
moronity1347333moron_ity
motility1338733motility
moulin8313283m_oulin
moult74728723m_oul_t
mount74128063moun__t
muonic10410183muon_ic
oolite63319603_oo_lite
oolith93813243_oo_lith
rootlet73015733rootlet
soonest7415593soonest
spotlit947303spotlit
sunlit61516103_sunlit
tonlet62924703_tonlet
toonie63617993toon_ie
townlet1049733townlet
unlit55025463__unlit
woodlot1147023woodlot
woolie93514483woo_lie

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 Filter1786911340270.423422437.4
2DLD Change Limit134027936.06322105.7
3Display Results93930.0303100.0
 (SQL Overall)178691936.51627423.4
 
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.