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

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
moaning10371444(None) 
loaning83614831loaning
meaning103918701meaning
moating104218151moating
mooning103415551mooning
morning103215041morning
baning95127832_baning
beaning103820682beaning
bemoaning1435952bemoaning
boating103721302boating
boning94223292bo_ning
caning94128622_caning
coaling103722822coaling
coaming123818322coaming
coating103525312coating
coaxing173511702coaxing
coining103920542coining
coning94331822co_ning
conning103718752conning
corning103720122corning
craning103620302craning
deaning94020472deaning
doating93816862doating
donning93512762donning
downing123811672downing
foaling113515842foaling
foaming133612992foaming
foining113013452foining
goading103112852goading
goaling93515332goaling
gowning12258832gowning
groaning102410282groaning
hoaxing18307762hoaxing
honing103421502ho_ning
horning113015002horning
joining153011482joining
leaning83721202leaning
loading94114612loading
loafing11319792loafing
loaming103613732loaming
loanings9348012loanings
macing114221552m_acing
making134823852m_aking
manning103616382manning
mating94832912m_ating
mawing124020802m_awing
maxing164817072m_axing
maying124421152m_aying
mazing184418972m_azing
meanings11329162meanings
mining94225452m_ining
moaningly1535782moaningly
mobbing14299702mobbing
mocking163614452mocking
mogging123311492mogging
moiling103417662moiling
molding114213752molding
molting103517172molting
mooing93718372mo_oing
mooring102514442mooring
mooting103019362mooting
moping114017102mo_ping
mopping143411472mopping
mornings11297922mornings
moshing134214882moshing
mossing103915422mossing
mounding123311262mounding
mounting112711812mounting
mourning1156792mourning
mousing103816272mousing
moving123913282mo_ving
mowing124119092mo_wing
nooning83014852nooning
oaring74225302_oaring
omening10310092omening
owning104110332_owning
planing103418252planing
roaming103215792roaming
roaring82916002roaring
saning75127642_saning
soaking123116612soaking
soaping103616222soaping
soaring83521892soaring
sorning83116812sorning
staning83922242staning
toning74025792to_ning
waning103623802_waning
weaning114117192weaning
womaning1437642womaning
wonning113210792wonning
yeaning113814632yeaning
zoning162914332zo_ning
zooning172910702zooning

Search took 4 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 Filter1786911076710.390458182.1
2DLD Change Limit107671933.42331455.2
3Display Results93930.0303100.0
 (SQL Overall)178691933.84346497.8
 
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.