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

168 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
mensches153628(None) 
menschen1543691menschen
menshes12310441mens_hes
benches143918602ben_ches
kenches163912272ken_ches
manches143818622man_ches
menaces112715522menac_es
menarches1646682menarches
mensch13387082mensch__
menschy17353992mensch_y
menses84222452mens__es
menshen1236802mens_hen
merches144013762me_rches
meshes115019442me_s_hes
munches144215792mun_ches
penoches1538932penoches
penuches1536942penuches
tenches123515522ten_ches
wenches152914132wen_ches
beaches144120653be_aches
beeches143413883be_eches
belches143514343be_lches
benched154713943ben_ched
bencher144113483ben_cher
benchers153611013ben_chers
blenches153310763blen_ches
borsches1536003borsches
bunches144116033bun_ches
cenacles1238023cenacles
censes83721803cens__es
censures102211623censures
censuses10187543censuses
ceviches1834843ceviches
cinches144215773cin_ches
clenches152910953clen_ches
conches144019813con_ches
deashes113313903deas_hes
detaches1439653detaches
drenches14309803dren_ches
dunches133312583dun_ches
eches106322163_e__ches
enriches1337263_enriches
ensiles72714833_ensiles
enskies1138573_enskies
ensues63313813_ens_ues
ensures73315903_ensures
eschew1436333_e_schew
eschews1534553_e_schews
etches114217763_e_tches
fences114617113fen_c_es
fescues1236783fe_scues
fetches153413893fe_tches
fetiches1636953fetiches
finches153914193fin_ches
flenches163410533flen_ches
flysches1933123flysches
frenches163311633fren_ches
ganaches1437413ganaches
hunches153913463hun_ches
inches114419673_in_ches
ketches164012193ke_tches
kirsches1743843kirsches
kitsches1734073kitsches
leaches123319343le_aches
leashes103514403leas_hes
leches115421313le__ches
leeches123911933le_eches
lenses64620893lens__es
letches124015483le_tches
lunches124115443lun_ches
lynches15378873lyn_ches
maches134827233m__aches
manacles1239523manacles
manche133515103man_che_
manchet143317773man_chet
manchets15269573man_chets
manses84225513mans__es
marches143921173m_arches
marshes123615373mars_hes
mashes115030003m_as_hes
matches143219783m_atches
measles92412753meas_les
measures1038913measures
menace103216943menac_e_
menaced122710093menac_ed
menacer112610883menac_er
menacers12279303menacers
menages103615393men_ages
menarche1545813menarche_
meninges1137433meninges
meniscus1243773menisc_us
meniscuses1442773meniscuses
mensae84114043mens_ae_
mensas85115853mens__as
mense75025633mens__e_
mensed93916543mens__ed
menseless1145203menseless
mensh105413553mens_h__
mentees93214503men_tees
merces105720743me_rc_es
mercies113817563me_rcies
mescals112911553me_scals
meshed124415933me_s_hed
mesnes85216213me_s_nes
messages1138233messages
messes84924343me_s_ses
mestees94617753me_stees
miches134320733m__iches
minces104420803min_c_es
minishes13310583minishes
miscues11312393m_iscues
monishes13311483monishes
monocles12310673monocles
mooches143714453m_ooches
moshes115222873m_os_hes
mouches143815963m_ouches
muches134718993m__uches
mulches143210673m_ulches
munched153411073mun_ched
muncher143610373mun_cher
munchers15318773mun_chers
munchies1539253mun_chies
muscles11310563m_uscles
mushes114124563m_us_hes
mutches143314283m_utches
naches114622413__naches
niches114419143__niches
nonsuches1444493nonsuches
panaches15310283panaches
panoches1548123panoches
peaches144120053pe_aches
penoche1447043penoche_
pensees9311203pens_ees
penuche1435943penuche_
penuchis1544283penuchis
penuchles1643763penuchles
perches143717953pe_rches
pinches144117933pin_ches
pinscher1544803pinscher
pinschers1644373pinschers
plenches153110623plen_ches
punches144816133pun_ches
putsches1535313putsches
quenches2236013quen_ches
ranches123620113ran_ches
reaches123423203re_aches
rescues9312753re_scues
reshes94124363re_s_hes
retches123318513re_tches
searches132112903searches
seiches12513813se_iches
sensates8511133sensates
senses63923943sens__es
seviches1635803seviches
stenches132110293sten_ches
teaches122718353te_aches
tenaces92814513tenac_es
tenses64722553tens__es
trenches133512603tren_ches
tusches1237903_tusches
vetches153411263ve_tches
welches153710313we_lches
welshes13379093wels_hes
wenched163910913wen_ched
wencher153811133wen_cher
wenchers16319213wen_chers
winches154714373win_ches
wrenches163210233wren_ches

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.1731032896.0
2DLD Change Limit1461621687.65619091.2
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.89222642.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.