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

227 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
hackmen183671(None) 
hackman1836431hackman
packmen1746311packmen
acumen1049012_acumen
hacked164923512hack_ed
hackee154921832hack_ee
hackees165014102hackees
hacker154822692hack_er
hackie154615622hackie_
hackies163418242hackies
hackle154916812hackle_
hackled173312492hackled
hackler163512352hackler
hackles162917062hackles
hackney1935122hackney
hangmen1337382hangmen
harken135116342hark_en
packman1736692packman
sockmen1535452sockmen
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
backer144525533back_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
chainmen15105263chainmen
chairmen15105473chairmen
chapmen1637283cha_pmen
chicken18278983chick_en
coachmen1745013coachmen
cracksmen1943073cracksmen
dacker134920753dack_er
daimen92210573da_imen
darken114013443dark_en
daysmen1335083daysmen
deskmen1435023deskmen
gagmen103910413ga_gmen
gasmen93111563ga_smen
gatemen1047603gatemen
hacek145411843hac__ek
hack135134543hack___
hackbut1845713hackbut
hackers164619043hackers
hacking173720613hacking
hacklers173710303hacklers
hacklier1737133hacklier
hackling183310163hackling
hackly18298733hack_ly
hackneys2033683hackneys
hacks144928713hack__s
hacksaw1943713hacksaw
hacksawn2042673hacksawn
haemin113412663ha_emin
haen76229453ha___en
hake115637843ha_k_e_
hakeem15407383ha_keem
hakes126034303ha_k_es
halogen1138393halogen
hame97043133ha__me_
hames106138703ha__mes
hammed144116973ha_mmed
hammer138120033ha_mmer
handymen1744983handymen
hangman1337813hangman
hanked144220603hank_ed
hanker134622093hank_er
hankie133915713hankie_
hankies143617763hankies
hanuman1237133hanuman
happen134812193ha_ppen
hapten115312983ha_pten
harden105718533ha_rden
harked145422553hark_ed
harkens144112863hark_ens
harmed125218833ha_rmed
harmer114719553ha_rmer
harmin113117393ha_rmin
harshen1339283harshen
hasten95718563ha_sten
hatchment1945313hatchment
hausen9610383ha_usen
haven114718533ha__ven
hawked174712673hawk_ed
hawker164812663hawk_er
hawkey19507633hawk_ey
hawkie163810093hawkie_
hawkies173311243hawkies
headmen13259513headmen
headsmen1465983headsmen
hearken14338033heark_en
heckle153112093heckle_
heckled17318463heckled
heckler16278573heckler
heckles163711383heckles
hegumen1355463hegumen
henchmen1844463henchmen
herdmen13238453herdmen
hickey185011993hick_ey
hickie153812473hickie_
hickies163614743hickies
hitmen11239193h_itmen
hocked165521303hock_ed
hocker155118563hock_er
hockey184813153hock_ey
huckle153913073huckle_
huckles163612623huckles
hymen13311043h__ymen
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
packed154822603pack_ed
packer144223403pack_er
packet144726503pack_et
placemen1445783placemen
raceme1039733raceme_
racemed1237013racemed
racemes1139093racemes
racked134526083rack_ed
racker124824553rack_er
racket125229423rack_et
rackle123917293rackle_
ragmen93712183ra_gmen
ramen75625193ra__men
ranchmen1545833ranchmen
sacked135525213sack_ed
sacker125124843sack_er
sagamen10127503sagamen
sandmen1039413sandmen
shacked174015393shack_ed
shackle16409543shackle_
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
shackoes17367853shackoes
shaken134113613sha_k_en
sicken124615253sick_en
slacken13399933slack_en
sockman1535663sockman
socmen1039193soc_men
spacemen1445413spacemen
stickmen1634543stickmen
stockmen1643923stockmen
tacked134723943tack_ed
tacker124224503tack_er
tacket124627493tack_et
tackey154613083tack_ey
tackier133712523tackier
tackle123815733tackle_
tackled143913193tackled
tackler134013323tackler
tackles133816523tackles
taken94819143ta_k_en
taximen1644923taximen
taxmen15367443ta_xmen
thacked173810203thack_ed
thicken16317873thick_en
trackman1645403trackman
truckmen1643373truckmen
vanmen1138403va_nmen
wacke145918623wack_e_
wacker154920123wack_er
wackes154717713wack_es
wackier16369733wackier
waken124818473wa_k_en
watchmen1844753watchmen
whacked20458623whack_ed
whacker19368503whack_er
whackier2044673whackier
whalemen1644473whalemen
workmen1635933workmen
yachtmen1842433yachtmen
yacked164516793yack_ed
yamen104115183ya__men
yardmen1335423yardmen

Search took 9 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 Limit1340272277.67317467.4
3Display Results2272270.0902522.2
 (SQL Overall)1786912278.18621828.9
 
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.