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

170 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
herdman1323842(None) 
headman13229631headman
herdmen13238451herdmen
herdsman1465641herdsman
beadman12249152beadman
birdman1236672birdman
deadman11238422deadman
german9611982ger_man
hardpan1336442hardpan
headmen13259512headmen
headsman1446352headsman
herdsmen1464832herdsmen
herma105318882her_ma_
hermae115314472her_mae
hermai118912862her_mai
hetman112510602he_tman
leadman10237842leadman
merman10513862mer_man
reedman1037722reedman
seedman1037372seedman
yardman1335912yardman
adman84517903__adman
aidman92410623_aidman
airman82414223air_man
badman113813843_badman
barman103519703bar_man
beadmen12299453beadmen
beadsman1355613beadsman
bedamn1137813be_damn
bedeman12168843bedeman
bedpan1137583be_dpan
bellman1137183bellman
birdmen1235833birdmen
boardman1344393boardman
bondman1238043bondman
carman103920743car_man
ceramal1138843ceramal
cerumen1147763cerumen
chessman1544823chessman
choreman15117603choreman
crewman1435753crewman
deadmen11248573deadmen
deadpan11225233deadpan
decuman1236573decuman
derma84918513der_ma_
dermal93614343der_mal
dermas94116813der_mas
deskman1444323deskman
desman9311693de_sman
everyman1643513everyman
ferryman1643813ferryman
fireman1249333fireman
firman112211343fir_man
foreman12312363foreman
freedman1444143freedman
freeman1237343freeman
germane1049663ger_mane
germans1079473ger_mans
germen9612313ger_men
goodman1135933goodman
hackman1836433hackman
handyman1745233handyman
hangman1337813hangman
hanuman1237133hanuman
harden105718533hard_en
hardhat14411023hardhat
hardpans1436453hardpans
harijan1735783harijan
harmin113117393har_min
headband1544843headband
headland1345613headland
headpin1336003headpin
headsmen1465983headsmen
headway1745553headway
hebdomad1742433hebdomad
hegemon1345173hegemon
hegumen1355463hegumen
helmsman1553503helmsman
hemal104419803he__mal
hemin103620933he__min
henchman1844013henchman
herbal112513493her_bal
herd84933063herd___
herded114215643herd_ed
herder104516463herd_er
herders113914123herders
herdic123112303herd_ic
herdics13249523herdics
herding122915123herding
herds96424683herd__s
hereat93527413her_eat
herein93717793her_ein
hereon93914363her_eon
herm95636153her_m__
hermaean1343603hermaean
hermit11519443her_mit
herms105626433her_m_s
hern76134893her___n
hernia9312293hernia_
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
heroin94420593her_oin
heron85025503her__on
hessian1035853hessian
hetmans12187593he_tmans
hexosan1744333hexosan
heyday1635143heyd_ay
hitman112710223h_itman
hordein1138753hordein
horseman1346833horseman
human102716033h__uman
jordan1468063jord_an
juryman1943583juryman
kirkman1243773kirkman
landman1038923landman
leadmen10277903leadmen
leadsman1145243leadsman
legman949653le_gman
leman75622603le__man
lensman937563lensman
lurdan738363lurd_an
madman113712383_madman
meatman1137903meatman
median94117543me_dian
meridian1147683meridian
mermen10813813mer_men
messman1137283messman
newsman1245503newsman
oarsman937733oarsman
overman12311463over_man
penman10312323pe_nman
permian112612283permian
preman104117453_preman
redan66125013re_d_an
reedmen1038333reedmen
reman75730153__reman
reran57329103rer__an
rodman949713_rodman
roman75424823__roman
sandman10310173sandman
seaman84015903se_aman
sedan65620423se_d_an
seedmen1037683seedmen
seedsman1144893seedsman
serdab937833serd_ab
sermon8413553ser_mon
serumal938783serumal
sheepman1543853sheepman
surfman1236203surfman
swordman1443403swordman
teleman959573teleman
tertian7511193tertian
theremin13107283theremin
therian10311293ther_ian
thermae125310503ther_mae
thermal125010973ther_mal
turfman1243983turfman
verdant11313293verd_ant
verdin103113023verd_in
vermian12329713vermian
vermin113414523ver_min
verseman1345383verseman
wheelman1642813wheelman
wireman1237843wireman
woodman1336313woodman
workman1635613workman
yardmen1335423yardmen
yeggman1442923yeggman
yeoman1138823ye_oman

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 Limit1340271706.57620381.2
3Display Results1701700.0463695.7
 (SQL Overall)1786911707.02825425.6
 
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.