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

178 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
messmen113739(None) 
messman1137281messman
chessmen1544462chessmen
deskmen1435022deskmen
lensmen937882lensmen
lessen64212432less_en
meatmen1138242meatmen
menshen1236812menshen
mermen10813812me_rmen
messan83912062mess_an
messed95018182mess_ed
messes84924342mess_es
messier93412922messier
newsmen1235892newsmen
pressmen1238832pressmen
almsmen1144583almsmen
amassment1346413amassment
ashmen1168173_ashmen
basemen1139083basemen
batsmen1146883batsmen
beadmen12299453beadmen
beadsmen1385883beadsmen
bedemen12910183bedemen
bedesmen1355713bedesmen
bellmen1138143bellmen
bushmen1436303bushmen
busmen1039893_busmen
cerumen1147763cerumen
cessed94615613cess_ed
cesses84221363cess_es
cession939813cession
chessman1544823chessman
daysmen1335083daysmen
deadmen11248573deadmen
deskman1444323deskman
desman9311693de_sman
dustmen1035773dustmen
esses56422973_ess_es
essoin638193_essoin
examen1538283_examen
fesse86116333fess_e_
fessed104515063fess_ed
fesses94820253fess_es
freshmen1656023freshmen
gamesmen1345113game_smen
gasmen93111563_gasmen
germen9612313ge_rmen
gessoed935743gessoed
gessoes838293gessoes
glassmen1145393glassmen
headmen13259513headmen
headsmen1465983headsmen
hegumen1355463hegumen
helmsmen1552843helmsmen
herdmen13238453herdmen
herdsmen1464833herdsmen
hessian1035853hessian
jesse126012833jess_e_
jessed144112303jess_ed
jesses135215953jess_es
kinsmen1335653kinsmen
leadmen10277903leadmen
leadsmen1154793leadsmen
legmen939343le_gmen
lensman937563lensman
lessee64116363less_ee
lessees73510243lessees
lessens7409383less_ens
lesser63514853less_er
lesson64412043less_on
madmen113511743m_admen
mailmen1137273mailmen
marksmen1644533marksmen
masse75125293mass_e_
massed94421323mass_ed
masses85028713mass_es
massier93615223massier
measle83513223measle_
measled10339303measled
measles92412753measles
meatman1137903meatman
meister93114163meister
melamed1249633melamed
meme85330553me__me_
memes94927703me__mes
mensae84114053mensae_
menschen1543713menschen
mense75025633mens_e_
mensed93916543mens_ed
menses84222453mens_es
menshes12310453menshes
merman10513863me_rman
mesclun1144013mesclun
mesdames1346043mesdames
meseemed1343963meseemed
meseems1165603meseems
meshed124415933me_shed
meshes115019443me_shes
meshier123410853meshier
mesian84315503me_sian
mesne75116293me_sne_
mesnes85216213me_snes
mesomere1247193mesomere
meson74118313me_s_on
mesosome1246023mesosome_
mesosomes1345763mesosomes
mess65932433mess___
message1037833message
messaged1235543messaged
messages1138233messages
messans92710463messans
messiah1246793messiah
messiest103112423messiest
messily12298813messily
messing103916393messing
messmate1246393messmate
messmates1346233messmates
messy104913833mess__y
mestee84523883me_stee
mestees94617753mestees
metamer1139613metamer
milkmen1565213milkmen
mismet103722373m_ismet
mispen10312173m_ispen
missed94423603miss_ed
missel85216523miss_el
missend104411373miss_end
missent94318713miss_ent
misses85130873miss_es
misset85028153miss_et
missies93423983missies
mission9312743mission
misspend1345243misspend
misspent1259173misspent
misstep11158463misstep
moisten93110143moisten
mossed94818893moss_ed
mosser84618273moss_er
mosses85527683moss_es
mossier94413813mossier
mussed94418903muss_ed
mussel83412903muss_el
musses84624783muss_es
mussier93314363mussier
nesses64718323ness_es
newsman1245503newsman
oarsmen938093oarsmen
peasen84815963peas_en
penmen10311493pe_nmen
postmen113110423postmen
pressman1247163pressman
reedmen1038333reedmen
regimen104411573regimen
reinsmen1047073reinsmen
reseen64318413re_seen
resume8313783resume_
resumed10310623resumed
resumer9410113resumer
resumes9313373resumes
rodsmen1035833rodsmen
seamen84518563se_amen
seedmen1037683seedmen
seedsmen1144303seedsmen
semen75724103__semen
sesame8311013sesame_
sesames9310743sesames
session739763session
tegmen988403te_gmen
tegumen10105423tegumen
telemen9310173telemen
velamen1237123velamen
versemen1346853versemen
vessel937953vess_el
vestment13109203vestment
yeggmen1442673yeggmen
yeomen1138183ye_omen
yessed104511163yess_ed
yesses93615813yess_es

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.406440125.6
2DLD Change Limit1340271786.98319193.3
3Display Results1781780.0632825.4
 (SQL Overall)1786911787.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.