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

230 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
herdmen1323845(None) 
headmen13259511headmen
herdman13238421herdman
herdsmen1464831herdsmen
beadmen12299452beadmen
birdmen1235832birdmen
cerumen1147762cerumen
deadmen11248572deadmen
germen9612312ger_men
harden105718532hard_en
headman13229632headman
headsmen1465982headsmen
hegumen1355462hegumen
herded114215642herd_ed
herder104516462herd_er
herdsman1465642herdsman
leadmen10277902leadmen
mermen10813812mer_men
reedmen1038332reedmen
seedmen1037682seedmen
yardmen1335422yardmen
admen84516183__admen
aidmen92610373_aidmen
airmen82612353air_men
badmen114613833_badmen
barmen105418533bar_men
beadman12249153beadman
beadsmen1385883beadsmen
bedemen12910183bedemen
bellmen1138143bellmen
berime105317333berime_
berimed124912283berimed
berimes115216643berimes
berme96022943ber_me_
bermed115217723ber_med
bermes106023003ber_mes
birdman1236673birdman
boardmen1344073boardmen
bondmen1237893bondmen
burden9412473burd_en
carmen104019343car_men
cerement12315133cerement
cermet10321153cer_met
cerumens1235763cerumens
chessmen1544463chessmen
choremen1597603choremen
crewmen1436383crewmen
deaden83714323dead_en
deadman11238423deadman
deskmen1435023deskmen
duramen1096903duramen
everymen1644423everymen
examen1538283_examen
ferment12315573fer_ment
ferrymen1643943ferrymen
firemen1238773firemen
foramen12310533foramen
foremen12412923foremen
freedmen1444553freedmen
freemen1238463freemen
garden84215083gard_en
german9611983ger_man
germens1078633ger_mens
goodmen1135623goodmen
hackmen1836713hackmen
handymen1744983handymen
hangmen1337383hangmen
hardens113815023hard_ens
harder105022403hard_er
hardier114721543hardier
hardies114923233hardies
hardiment1546063hardiment
hardpan1336443hardpan
hardset113415833hardset
harken135116343har_ken
harmed125218833har_med
harmer114719553har_mer
harmin113117393har_min
harshen1339283harshen
headed114020473head_ed
headend12398363head_end
header104422543head_er
headier113212953headier
headpin1336003headpin
headset11312603headset
headsman1446353headsman
hearken14338023hearken
hearten102411753hearten
heathen133410893heathen
heaume1137543heaume_
heaumes1237423heaumes
heaven123912603he_aven
heddle114211163heddle_
heddles123311623heddles
heder95623643he_d_er
hedge105317353he_dge_
hedged125211813he_dged
hedger114912653he_dger
hedges115016263he_dges
heeded114215763heed_ed
heeder104216043heed_er
hegemon1345173hegemon
hegumene1443983hegumene
hegumens1444303hegumens
hegumeny1742903hegumeny
helmed124513693he_lmed
helmet113718933he_lmet
helmsmen1552843helmsmen
heme95034413he__me_
hemes105031083he__mes
hemin103620933he__min
hemmed144211463he_mmed
hemmer134112643he_mmer
hempen1338963he_mpen
henchmen1844453henchmen
herbed123513453her_bed
herbier1239593herbier
herd84933063herd___
herders113914123herders
herdic123112303herd_ic
herdics13249523herdics
herding122915123herding
herds96424683herd__s
here76447103her__e_
heredes11313133heredes
herein93717793her_ein
hereon93914363her_eon
heres86245903her__es
herm95636153her_m__
herma105318883her_m_a
hermae115314473her_mae
hermaean1343603hermaean
hermai118912863her_mai
hermit11519443her_mit
herms105626433her_m_s
hern76134893her___n
heroes94923823her_oes
heroin94420593her_oin
heroine103517483heroine
heron85025503her__on
herpes115517323her_pes
herried113514453herried
herries104025073herries
hertzes1938303hertzes
hetman112510603he_tman
heydey1634633heyd_ey
hidden11429743h_idden
hitmen11239193h_itmen
hodden113811453h_odden
hoiden103612333hoid_en
holden104113953hold_en
horde94623053hord_e_
horded115420483hord_ed
hordein1138753hordein
hordes104921633hord_es
horsemen1347483horsemen
hoyden13328933hoyd_en
hurdies114015663hurdies
hurdle103712793hurdle_
hurdled12379833hurdled
hurdler113610003hurdler
hurdles113613373hurdles
hymen13311043h__ymen
jurymen1943133jurymen
kermes124616133ker_mes
kerogen1236093kerogen
kirkmen1232923kirkmen
landmen1038553landmen
leaden74515223lead_en
leadman10237843leadman
leadsmen1154793leadsmen
legmen939343le_gmen
lensmen937883lensmen
madmen113511743_madmen
meatmen1138243meatmen
merde84320123merd_e_
merdes94518603merd_es
merman10513863mer_man
messmen1137393messmen
nerdier83110353nerdier
newsmen1235893newsmen
oarsmen938093oarsmen
overmen12311803over_men
penmen10311493pe_nmen
perdie94718513perdie_
perdue93912633perdue_
perdues103511333perdues
permed115217353per_med
premen105017803_premen
ramen75625193__ramen
redden83613623re_dden
reedman1037723reedman
regimen104411573regimen
rerisen73613643rerisen
rodmen939713_rodmen
rumen74419503__rumen
sandmen1039413sandmen
seamen84518563se_amen
seedman1037373seedman
seedsmen1144303seedsmen
semen75724103se__men
sermon8413553ser_mon
sheepmen1544643sheepmen
surfmen1235993surfmen
swordmen1443003swordmen
tegmen988403te_gmen
tegumen10105423tegumen
telemen9310173telemen
termed94816703ter_med
termer85717253ter_mer
terreen7257573terreen
theremin13107283theremin
therme115814993ther_me_
thermel12569893ther_mel
thermes126214613ther_mes
turfmen1244163turfmen
velamen1237123velamen
verdin103113023verd_in
vermes115019143ver_mes
vermin113414523ver_min
versemen1346853versemen
warden104515513ward_en
weldment1445823weldment
wheelmen1643313wheelmen
wiremen1236903wiremen
woodmen1356053woodmen
workmen1635933workmen
yardman1335913yardman
yeggmen1442673yeggmen
yeomen1138183ye_omen

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.403443402.0
2DLD Change Limit1340272306.76619808.9
3Display Results2302300.0802875.0
 (SQL Overall)1786912307.24924650.4
 
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.