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

156 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
menshen123681(None) 
menschen1543711menschen
menshes12310451menshes
lensmen937882lensmen
mensae84114052mensae_
mensches1536302mensches
mense75025632mens_e_
mensed93916542mens_ed
menses84222452mens_es
mensh105413562mensh__
menthene1347032menthene
meshed124415932me_shed
meshes115019442me_shes
messmen1137392messmen
ashen87818673__ashen
banshee121212453banshee
beechen14367703beechen
benched154713943benched
bencher144113483bencher
benches143918603benches
benthon1237693benthon
cense75121403cens_e_
censed94016323cens_ed
censer84516583cens_er
censes83721803cens_es
deashed123411303deashed
deashes113313903deashes
denizen1737663denizen
dense65923503dens_e_
denser74115193dens_er
ensign737523_ensign
ensue54013833_ensue_
ensued73610483_ensued
ensues63313813_ensues
freshen133010883freshen
genseng933983gens_eng
harshen1339283harshen
heathen133410893heathen
henchmen1844453henchmen
kenches163912273kenches
kinsmen1335653kinsmen
leashed113211163leashed
leashes103514403leashes
lengthen1243533lengthen
lense54523433lens_e_
lensed74015473lens_ed
lenses64620893lens_es
lensman937563lensman
lenten6312883len_ten
lessen64212433le_ssen
manche133515103manche_
manches143818623manches
manchet143317783manchet
manse75528233mans_e_
manses84225513mans_es
mansion9611543mansion
marchen143312073marchen
marshes123615373marshes
mashed125325043m_ashed
masher114123203m_asher
mashes115030003m_ashes
measle83513223measle_
measled10339303measled
measles92412753measles
meatmen1138243meatmen
meister93114163meister
menace103216943menace_
menaced122710093menaced
menacer112610883menacer
menaces112715523menaces
menage93216543menage_
menages103615393menages
menazon1846053menazon
mended104418683men_ded
mender93520793men_der
menhaden1444213menhaden
menhir1136783men_hir
mensa75318673mens__a
mensal84615663mens_al
mensas85115863mens_as
mensch13387103mens_ch
menschy17354013menschy
mensing103915103mensing
menswear1352183menswear
mentee84121293men_tee
mentees93214503mentees
menthenes1447703menthenes
menthol1236723menthol
mention9314373mention
merches144013763merches
mermen10813813me_rmen
mesh96823003me_sh__
meshier123410853me_shier
meshing134513813me_shing
meshy135612783me_sh_y
mesian84315503me_sian
mesne75116293me_sne_
mesnes85216213me_snes
meson74118313me_s_on
messan83912063me_ssan
messed95018183me_ssed
messes84924343me_sses
messier93412923messier
messman1137283messman
mestee84523883me_stee
minished1437873minished
minishes13310583minishes
minster93914323minster
mispen10312173m_ispen
moisten93110143moisten
monished1438133monished
monishes13311483monishes
monsoon938493monsoon
monster93214603monster
moorhen1236023moorhen
moshed124517493m_oshed
mosher114719793m_osher
moshes115222873m_oshes
mudhen1236883m_udhen
muenster1043313muenster
munched153411073munched
muncher143610373muncher
munches144215793munches
munster93710523munster
mushed124420843m_ushed
musher113820573m_usher
mushes114124563m_ushes
newsmen1235893newsmen
peahen113410133pe_ahen
peasen84815963peas_en
penmen10311493pen_men
pensee8417313pens_ee
pensees9311203pensees
pension9412203pension
penster92811953penster
reinsmen1047073reinsmen
reseen64318413re_seen
reshes94124363re_shes
sense55526823sens_e_
sensed73918163sens_ed
sensei64712593sens_ei
senses63923943sens_es
tenches123515523tenches
tense55225843tens_e_
tensed74817833tens_ed
tenser64919433tens_er
tenses64722553tens_es
tension7311803tension
unseen62012623_unseen
unshed10313773_unshed
welshed14277203welshed
welsher13377443welsher
welshes13379093welshes
wenched163910913wenched
wencher153811133wencher
wenches152914133wenches

Search took 7 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 Limit1340271566.00022337.8
3Display Results1561560.0602600.0
 (SQL Overall)1786911566.48327563.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.