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

75 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
mourns8411101(None) 
bourns84114061bourns
morns75527441mo_rns
mourn77215011mourn_
amours83512642amour_s
bourgs9459992bourgs
bourn75518482bourn_
bourne83714092bourne
bournes93615022bournes
burns74926772_burns
churns114910232churns
corns76034762co_rns
courts84216162courts
curns74924272_curns
douras75016722douras
durns64819862_durns
fours85521492four_s
gourds8108252gourds
horns86125332ho_rns
houris94514562houris
hours85422382hour_s
inurns63310982inurns
journo13135292journo
journos14134942journos
kouros1039182kouros
lours55125292lour_s
moans74624362mo_ans
moderns1037962moderns
mohurs1135932mohur_s
moires8915632moires
mons68152252mo__ns
monurons1037092monurons
moons75331002mo_ons
moors74923142moor_s
moras76438762mo_ras
mores76249642mo_res
morn66237562mo_rn_
morons84919542morons
morris83814722morris
morros83714672morros
mors65950062mo_r_s
morts75533562mo_rts
moues75732842mou_es
moulds94910992moulds
moulins9312702moulins
moults84713702moults
mound83918312mou_nd
mounds93915132mounds
mount74128062mou_nt
mounts84115072mounts
mourned1037762mourned
mourner938082mourner
mourners1036912mourners
mouses85531422mouses
mouths115214532mouths
moutons9410312moutons
muns65535912m_u_ns
muons75816172m_uons
muras75329562m_uras
mures75937212m_ures
murks114821722m_urks
murrs75521292m_urrs
nouns56717312nou_ns
ours47237562_our_s
porns75527342po_rns
pours74623182pour_s
rouens64814442rouens
sorns55028412so_rns
sours55230502sour_s
spurns84811382spurns
tours55325862tour_s
turns55623232_turns
urns46323892__urns
yourn87512772yourn_
yours85217872your_s

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 Filter178691825510.250714764.0
2DLD Change Limit82551756.37312953.2
3Display Results75750.0461630.4
 (SQL Overall)178691756.66926794.3
 
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.