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

85 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
moorhens134484(None) 
moorhen1236021moorhen_
gorhens1137182_gorhens
moochers15369122moochers
mooches143714452mooche_s
moreens939962m_oreens
morgens10310462m_orgens
smoothens14194252smoothens
woodhens1534102woodhens
boreens9310403_boreens
chortens13308793chortens
coarsens10348123coarsens
cooches143515833cooche_s
doorless936713doorless
doormen1036753doormen_
gorhen1038893_gorhen_
hoarsens11306023hoarsens
hooches153812523hooche_s
loosens716310953loo_sens
martens93714953m_artens
mohels115011323m_o_hels
moires8915633moir_e_s
moistens10268773moistens
mooched153910533mooche_d
moocher143610673mooche_r
mooching16259063mooching
mooleys1236863moo_leys
mooners94015343moo_ners
moonless10278043moonless
moonlets10247473moonlets
moons75331003moo___ns
moonsets10216413moonsets
moorages1139043moorages
moored93814173moor_e_d
moorier93113073moorie_r
mooriest102812723mooriest
mooring102514443moor_ing
moorings11257693moorings
moorland1144683moorland
moorlands1244203moorlands
moors74923143moor___s
mooters93818623moo_ters
mootness1036753mootness
mordent10313993m_ordent
mordents1138813m_ordents
moreen8313343m_oreen_
morels84820013m_or_els
mores76249643m_or_e_s
morgans10310123m_organs
morgen9312203m_orgen_
morions94014633m_orions
morns75527443m_or__ns
morons84919543m_or_ons
morphins1538643morphins
morrions1077653morrions
morsels94112653m_orsels
moshers124017843m_oshers
moshes115222873m_oshe_s
mothers123717623m_others
motorless1145723motorless
motormen1245703motormen_
mouches143815963mouche_s
mourners1036913mourners
mourns84111013mour__ns
mouthers133811303mouthers
mudhens1335103m_udhens
pooches143214163pooche_s
poorness1036353poorness
roughens12286893roughens
shortens11288983shortens
smoochers16184833smoochers
smooches15217263smooche_s
smooshes13206863smooshe_s
smoothen13204953smoothen_
smoothers14206043smoothers
smoothes13218533smoothe_s
soothers113913433soothers
soothes103917103soothe_s
toughens12286723toughens
woodhen1454723woodhen_
woolens10398843woo_lens
woollens1144093woollens
wooshes13169883wooshe_s
worsens104610263_worsens
youthens1435383youthens

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit146162858.09318060.3
3Display Results85850.0332575.8
 (SQL Overall)178691858.28221575.8
 
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.