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

154 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
seedman103737(None) 
reedman1037721reedman
seedmen1037681seedmen
seedsman1144891seedsman
beadman12249152beadman
bedeman12168842bedeman
deadman11238422deadman
freedman1444142freedman
headman13229632headman
herdman13238422herdman
leadman10237842leadman
reedmen1038332reedmen
sandman10310172sandman
seaman84015902s_eaman
sedan65620422s_ed_an
seedsmen1144302seedsmen
sheepman1543852sheepman
sideman1037972sideman
adman84517903__adman
aidman92410623_aidman
axeman1538103axe_man
badman113813843_badman
beadmen12299453beadmen
beadsman1355613beadsman
bedamn1137813_bedamn
bedemen12910183bedemen
bedesman1345083bedesman
bedpan1137583_bedpan
bellman1137183bellman
birdman1236673birdman
bondman1238043bondman
crewman1435753crewman
deadmen11248573deadmen
deadpan11225233deadpan
decuman1236573decuman
deewan10267553dee_wan
deskman1444323deskman
desman9311693_desman
edema8610553_edema_
edemas9310503_edemas
feedbag14112973feedbag
foeman11311233foe_man
freedmen1444553freedmen
freeman1237343freeman
german9611983_german
gleeman1035363gleeman
goodman1135933goodman
headmen13259513headmen
headsman1446353headsman
herdmen13238453herdmen
herdsman1465643herdsman
hetman112510603_hetman
iceman1037853ice_man
landman1038923landman
leadmen10277903leadmen
leadsman1145243leadsman
legman949653_legman
leman75622603_le_man
lensman937563lensman
madman113712383_madman
meatman1137903meatman
median94117543_median
merman10513863_merman
messman1137283messman
newsman1245503newsman
oedema936573oedema_
oedemas1056693oedemas
overman12311463overman
penman10312323_penman
preman104117453pre_man
redan66125013_red_an
redemand1245923redemand
reman75730153_re_man
rodman949713_rodman
sagaman10117563sagaman
salesman1047353salesman
sandmen1039413sandmen
seamen84518563s_eamen
seawan94111223s_eawan
sedans74816093s_ed_ans
seed55549483seed___
seedbed11246613seedbed
seedcake1543423seedcake
seedcase1144063seedcase
seeded84520463seed_ed
seeder74320773seed_er
seeders83017113seeders
seedier83513633seedier
seedily1178583seedily
seeding93719483seeding
seedling102610953seedling
seedpod1144013seedpod
seeds64330063seed__s
seedy94821533seed__y
seem65438563see_m__
seemed95117613see_med
seemer84418043see_mer
seeming103216263see_ming
seemly1138433see_mly
seems75525023see_m_s
seen46943123see___n
seesaw935973see_saw
seismal937303seismal
seitan62613233s_eitan
selectman1343553selectman
semen75724103s_e_men
semimat11412913semimat
sendal73314993send_al
serdab937833serd_ab
sermon8413553s_ermon
serumal938783serumal
sewan85921293s_e_wan
sextan13389643s_extan
shaman113314283s_haman
shebean1235763shebean
sheepmen1544643sheepmen
sheitan1036573sheitan
shipman14247133shipman
shopman14247263shopman
showman15257293showman
sidemen1037943sidemen
sierran737193sierran
skean94415623ske__an
skyman1535313s_kyman
smegma1134113smegma_
smegmas1233503smegmas
snowman12226623snowman
sockman1535663sockman
socman1039813s_ocman
sokeman1337263sokeman
soldan73511853sold_an
soman75024903s__oman
soudan73210353soud_an
soundman1144713soundman
spean74620513spe__an
spearman1244943spearman
speedway1743313speedway
spelean937123spelean
steersman1143263steersman
stemma10328133stemma_
stemmas11256973stemmas
stewpan1234193stewpan
subdean1037403subdean
suldan72611043suld_an
superman12310233superman
surfman1236203surfman
swagman1334913swagman
swordman1443403swordman
teleman959573teleman
wheelman1642813wheelman
woodman1336313woodman
yardman1335913yardman
yeggman1442923yeggman
yeoman1138823_yeoman

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.423422437.4
2DLD Change Limit1340271547.06318975.9
3Display Results1541540.0602566.7
 (SQL Overall)1786911547.54623680.2
 
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.