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

100 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
mound8391831(None) 
bound84819581bound
found94917841found
hound95016481hound
maund85515441maund
mould86015751mould
mounds93915131mounds
mount74128061mount
pound84417861pound
round64318431round
sound64420021sound
wound94414211wound
abound9239862abound
amount8414482amount
around72712412around
bond75334362bo_nd
bounds94415802bounds
bund75530662_bund
could86517712could
count74932052count
fond86330952fo_nd
founds104814192founds
fount84727032fount
fund85624982_fund
gourd71011902gourd
ground82310272ground
hounds104413132hounds
impound1235392impound
jocund1633622jocund
loud55228042lou_d
maud75325392mau_d
maun65727202maun_
maunds9519652maunds
maundy12506782maundy
mend75334022m_end
meoued9118532meoued
mind75434372m_ind
moan65832012moan_
moaned94514172moaned
moans74624362moans
mod69054402mo__d
mold76034332mo_ld
mon57561572mo_n_
monad85519472monad
monde85723142mo_nde
mondo85721232mo_ndo
monk105928512mo_nk
mono66036712mo_no
mons68152252mo_ns
mony96830002mo_ny
mood76332062mo_od
mooed85123982mooed
moon67140812moon_
mooned94216642mooned
moons75331002moons
moony104818272moony
moped105424732moped
morn66237562morn_
morns75527442morns
mouch124715802mouch
moue65835572mou_e
moues75732842moues
moulds94910992moulds
mouldy12437412mouldy
moult74728722moult
mounded113711982mounded
mounted103611532mounted
mounts84115072mounts
mourn77215012mourn
mourned1037762mourned
mourns84111012mourns
mouse77133002mouse
moused94423302moused
mousy106716942mousy
mouth105420292mouth
moved114218152moved
mowed113629012mowed
mown95424442mown_
mud67336862m_u_d
mun56143852m_un_
muni65824402m_uni
muns65535912m_uns
muon65722732muon_
muons75816172muons
noun45724182noun_
nouns56717312nouns
oud47439072_ou_d
poind84217912poind
pond75530492po_nd
pounds93714382pounds
rotund737292rotund
rounds73615612rounds
sounds74616182sounds
stound7399902stound
swound10377632swound
would95513152would
wounds103811632wounds
yond86122312yo_nd
young977742young
zounds164310172zounds

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001001.75030742.9
3Display Results1001000.0333030.3
 (SQL Overall)1786911001.87695251.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.