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

211 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
packmen174631(None) 
hackmen1836711hackmen
packman1736691packman
acumen1049012_acumen
hackman1836432hackman
packed154822602pack_ed
packer144223402pack_er
packet144726502pack_et
placemen1445782placemen
sockmen1535452sockmen
spacemen1445412spacemen
trackmen1635572trackmen
ackee115825373_ack_ee
ackees124914583_ackees
acme86924323_ac_me_
acmes96020653_ac_mes
acumens1136953_acumens
admen84516183_a_dmen
aidmen92610373_aidmen
airmen82612353_airmen
amen66733153_a__men
ashmen1168173_ashmen
attackmen1752153attackmen
axemen1547493_axemen
axmen145112273_a_xmen
backbend1944783backbend
backed155725723back_ed
backer144525523back_er
backset15314193backset
badmen114613833ba_dmen
bagmen115412533ba_gmen
barmen105418533ba_rmen
basemen1139083basemen
batmen104414303ba_tmen
batsmen1146883batsmen
baymen134212003ba_ymen
blacken15439793black_en
bookmen15126263bookmen
bracken15409813brack_en
buckeen1536703buckeen
cabmen123610653ca_bmen
cackle143416923cackle_
cackled164613303cackled
cackler153812573cackler
cackles153717203cackles
carmen104019343ca_rmen
cavemen1437143cavemen
coachmen1745013coachmen
cracksmen1943073cracksmen
dacker134920753dack_er
daimen92210573da_imen
darken114013443dark_en
daysmen1335083daysmen
deskmen1435023deskmen
gagmen103910413ga_gmen
gasmen93111563ga_smen
gatemen1047603gatemen
hacked164923513hack_ed
hackee154921833hack_ee
hackees165014103hackees
hacker154822693hack_er
hackie154615623hackie_
hackies163418243hackies
hackle154916813hackle_
hackled173312493hackled
hackler163512353hackler
hackles162917063hackles
hackney1935123hackney
hangmen1337383hangmen
harken135116343hark_en
icemen1037893_icemen
jacked204817523jack_ed
jacker194417583jack_er
jacket194720673jack_et
jackies202912623jackies
jackleg2135043jackleg
jazzmen2442503jazzmen
junkmen2033633junkmen
kirkmen1232923kirkmen
lacked135324653lack_ed
lacker125325623lack_er
lackey154813353lack_ey
landmen1038553landmen
lawmen11308593la_wmen
laymen113010843la_ymen
linkmen1335363linkmen
mackle143716433mackle_
mackled164111923mackled
mackles154415753mackles
madmen113511743ma_dmen
mailmen1137273mailmen
marksmen1644533marksmen
milkmen1565213milkmen
nankeen1135043nankeen
oaken95814383oa_k_en
oarsmen938093oarsmen
pace86345773pac__e_
paced106931683pac__ed
pacer96131613pac__er
paces96741113pac__es
pacey126720283pac__ey
pacier105018683pac_ier
pack125535443pack___
package16128013package
packaged18115753packaged
packager17136153packager
packages17138733packages
packers153818893packers
packeted17148283packeted
packets155114773packets
packing164420723packing
packly17228333pack_ly
packness1636933packness
packs135528933pack__s
packwax2542853packwax
paction112713963paction
paiked135113433paik_ed
palmed114314643pa_lmed
palmer105816543pa_lmer
pangen94115913pa_ngen
parament12415393parament
parchment1846913parchment
parked134425143park_ed
parker124121373park_er
paten74827343pa__ten
patten84418193pa_tten
pavement1549443pavement
pawkier16236613pawkier
payment14310703pa_yment
pecked155019103peck_ed
pecker144615363peck_er
peckier153910523peckier
pecten102711103pec_ten
penmen10311493p_enmen
picked154421313pick_ed
pickeer153710113pickeer
picker144422173pick_er
picket144924313pick_et
pickier153912973pickier
pickle144215653pickle_
pickled164011883pickled
pickles153215443pickles
pikemen1535333pikemen
pinken124513283pink_en
pitchmen1744333pitchmen
pitmen102510793p_itmen
placeman1445683placeman
placement1548183placement
placket15412873plack_et
plowmen1434883plowmen
pocked154818983pock_ed
pocket144622623pock_et
pockier153911603pockier
pocosen1146833pocosen
postmen113110423postmen
potmen102713093p_otmen
premen105017803p_remen
propmen1338763propmen
pucker143817633puck_er
putamen1135923putamen
raceme1039733raceme_
racemed1237013racemed
racemes1139093racemes
racked134526083rack_ed
racker124824553rack_er
racket125229423rack_et
rackle123917293rackle_
ragmen93712183ra_gmen
ramen75625193ra__men
ranchmen1545833ranchmen
sacked135525213sack_ed
sacker125124843sack_er
sagamen10127503sagamen
sandmen1039413sandmen
sicken124615253sick_en
slacken13399933slack_en
sockman1535663sockman
socmen1039193soc_men
spaceman1445323spaceman
spackle15369573spackle_
spackled17297803spackled
spackles16319953spackles
specimen1444423specimen
stickmen1634543stickmen
stockmen1643923stockmen
tacked134723943tack_ed
tacker124224503tack_er
tacket124627493tack_et
tackey154613083tack_ey
tackier133712523tackier
tackle123815733tackle_
tackled143913193tackled
tackler134013323tackler
tackles133816523tackles
taken94819143ta_k_en
taximen1644923taximen
taxmen15367443ta_xmen
trackman1645403trackman
truckmen1643373truckmen
vanmen1138403va_nmen
wacke145918623wack_e_
wacker154920123wack_er
wackes154717713wack_es
wackier16369733wackier
waken124818473wa_k_en
watchmen1844753watchmen
workmen1635933workmen
yachtmen1842433yachtmen
yacked164516793yack_ed
yamen104115183ya__men
yardmen1335423yardmen

Search took 10 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 Limit1340272118.89015076.2
3Display Results2112110.0762776.3
 (SQL Overall)1786912119.38919032.0
 
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.