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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
manhood133899(None) 
manhoods1447241manhoods
humanhood1852222humanhood
ladhood1246472ladhood
maidhood1543912maidhood
mangold1137212mangold
manhole12311342manhole
monkhood1884992monkhood
sonhood1168312sonhood
unhood1039232_unhood
womanhood1852462womanhood
achoo10315083_achoo_
ahold94714253_a_hold
anthoid11313313_anthoid
aunthood1254723aunthood
babyhood1953103babyhood
baywood1646443baywood
boyhood1646493boyhood
cahoot11416473ca_hoot
canoed94618963can_oed
cashoo11312253cashoo_
cashoos12310793cashoos
dagwood1344833dagwood
dahoon1039053da_hoon
fanfold1485373fanfold
fantod102010033fan_tod
fatwood1486393fatwood
ganoid8314443gan_oid
godhood1345143godhood
handhold1645633handhold
hood85132333___hood
humanhoods1951953humanhoods
kinghood1753983kinghood
ladhoods1345873ladhoods
ladyhood1643193ladyhood
macho126120153mach_o_
machos135217493mach_os
machzor2344263machzor
madzoon1996063madzoon
mahoe10315573ma_h_oe
mahoes11313103ma_hoes
mahout11415803ma_hout
mahzor2035113ma_hzor
maidenhood1752033maidenhood
maidhoods1643633maidhoods
mamboed14417623mamboed
managed113212603managed
manatoid1148823manatoid
mandola1039023mandola
maned86634103man__ed
mangled113615263mangled
mango85724323man_go_
mangoes104316133mangoes
mangolds1235193mangolds
mangos94319333man_gos
manholes13311183manholes
manhunt1247073manhunt
manifold1484943manifold
manihot121112053manihot
manihots13126443manihots
manioc103914823man_ioc
manioca11358943manioca
maniocs113611443maniocs
manito8518693manito_
manitos9314053manitos
manitou938463manitou
mankind1437773mankind
manned94418643man_ned
mannose939243mannose
mano66536813man__o_
manor78023933man__or
manors84420883man_ors
manos74933623man__os
manrope1138033manrope
mansard1049313mansard
mansion9611543mansion
mantid93820383man_tid
mantled104113393mantled
manured1039473manured
manward1349093manward
manyfold1792743manyfold
markhoor1742973markhoor
maroon83118203ma_roon
mashed125325043mash_ed
mastoid10711233mastoid
matchwood2093433matchwood
mattoid1079283mattoid
matzoon1896473matzoon
method1239023meth_od
monkhoods1984353monkhoods
monkshood1982853monkshood
monopod1247493monopod
monsoon938493monsoon
mood76332063m___ood
nonfood1156653nonfood
pandoor10358583pandoor
sainthood1343903sainthood
santoor737433santoor
sapwood1366913sapwood
snood64616163_sn_ood
sonhoods1247083sonhoods
tandoor8278563tandoor
tangoed9318833tangoed
unhoods1137503_unhoods
unhook1347523_unhook
vanload1144703vanload
vanpool1243763vanpool
wahoo112413083wa_hoo_
wahoos122310593wa_hoos
womanhoods1952053womanhoods
yahoo112911543ya_hoo_
yahoos12209243ya_hoos

Search took 8 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.406440125.6
2DLD Change Limit1340271126.98319193.3
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.43524033.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.