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

111 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
pressmen123883(None) 
pressman1247151pressman
chessmen1544462chessmen
expressmen2153352expressmen
freshmen1656022freshmen
messmen1137392_messmen
premen105017802pre__men
prenomen1249632prenomen
pressed103317312press_ed
presser93717622press_er
presses93523152press_es
pressrun1045032pressrun
presume11310302presume_
presumed1337972presumed
presumer1247582presumer
presumes1239842presumes
chessman1544823chessman
cragsmen1344763cragsmen
cresses94219813cress_es
cresset93319943cress_et
crewmen1436383cre_wmen
deskmen1435023_deskmen
dressed93511873dress_ed
dresser83611953dress_er
dresses83716173dress_es
dressier956863dressier
expressman2152363expressman
freedmen1444553freedmen
freemen1238463fre_emen
freshen133010883fre_shen
freshman1644623freshman
glassmen1145393glassmen
greisen856503greis_en
herdsmen1464833herdsmen
impressment1755073impressment
lensmen937883_lensmen
lessen64212433_less_en
messman1137283_messman
newsmen1235893_newsmen
peasen84815963p_eas_en
penmen10311493p_e_nmen
postmen113110423p_ostmen
praenomen1345013praenomen
prearmed1397993prearmed
preassign1244573preassign
preen75925053pre___en
pregame1239553pregame_
pregames1339003pregames
prehuman1545033prehuman
preman104117453pre__man
premed114617763pre__med
prename11412643prename_
prenames12311643prenames
prenomens1347073prenomens
presage10312293presage_
presaged1238803presaged
presager1138443presager
presages11312203presages
presale9416353presale_
presales10315263presales
prescient13411323prescient
prescreen1345103prescreen
prese75228383pre_s_e_
present94022733pre_s_ent
preset84430983pre_s_et
preshown16255633preshown
preside10715613preside_
presided12410553presided
president12410993president
presider11410423presider
presides11414913presides
presleep1244493presleep
press75425953press___
pressers103215023pressers
pressgang1342773pressgang
pressing112516443pressing
pressmark1762843pressmark
pressor93512883press_or
pressors103212693pressors
pressruns1144293pressruns
pressure1039773pressure
pressured1237333pressured
pressures1149063pressures
prester93519623pre_ster
presumers1336373presumers
presuming1437663presuming
preteen939873pre_teen
prissed103311263priss_ed
prisses94816713priss_es
prissier10157873prissier
prissies101712003prissies
propmen1338763pr_opmen
prosses94019513pross_es
prossie91812953prossie_
prossies101515223prossies
reedmen1038333_reedmen
regimen104411573_regimen
reinsmen1047073_reinsmen
reseen64318413_re_seen
resume8313783_resume_
resumed10310623_resumed
resumer9410113_resumer
resumes9313373_resumes
rodsmen1035833_rodsmen
seedsmen1144303seedsmen
trashmen1346563trashmen
tressed83714263tress_ed
tressel73010893tress_el
tresses73719543tress_es
tressier847963tressier
versemen1346853versemen

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621117.22020244.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.68623248.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.