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

236 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
mensch1338708(None) 
menschy17353991menschy
mensh105413551mens_h
bench125619502ben_ch
kench145513922ken_ch
menace103216942menace
menisci1144772menisci
mensa75318662mens_a
mensae84114042mensae
mensal84615652mensal
mensas85115852mensas
menschen1543692menschen
mensches1536282mensches
mense75025632mens_e
mensed93916542mensed
menses84222452menses
merch125417962me_rch
mesh96823002me_s_h
munch124917102mun_ch
tench105620002ten_ch
wench136214782wen_ch
amens75624843amens__
beach124623893be_ach
beech124315503be_ech
belch124415503be_lch
bens65945703bens__
blench133710453blen_ch
borsch1336133borsch
bunch125118603bun_ch
cense75121403cens_e
censed94016323censed
censer84516583censer
censes83721803censes
censor84011283censor
census84310303census
cinch124516243cin_ch
clench133910053clen_ch
conch124620073con_ch
deash95617243deas_h
dens55945073dens__
dense65923503dens_e
denser74115193denser
detach12310413detach
drench12369593dren_ch
dunch115316263dun_ch
each95530583_e_ach
enact73525363_enact
enrich1138943_enrich
ens37245923_ens__
ensky1235093_ensky
ensue54013833_ensue
epoch1248203_epoch
etch95419143_e_tch
eunuch1154363eunuch
fence105319913fen_ce
fens76139763fens__
fetch134913473fe_tch
fetich1479693fetich
finch135416973fin_ch
flench144010813flen_ch
flysch1732893flysch
french143511213fren_ch
genic85119393genic_
gens55740073gens__
hence104920043hen_ce
hens75642573hens__
heuch135312333he_uch
hunch136416213hun_ch
inch95420823_in_ch
kens85435233kens__
ketch144912023ke_tch
kirsch1532713kirsch
kitsch1533353kitsch
leach105422523le_ach
leash85519213leas_h
lech96825443le__ch
leech104913213le_ech
length1046103length
lens46146493lens__
lense54523433lens_e
lensed74015473lensed
lenses64620893lenses
letch105215803le_tch
lunch104917243lun_ch
lynch13468983lyn_ch
mach116134473m__ach
manche133515103man_che
manic94629433manic_
manics103919933manics
mans66354533mans__
manse75528223mans_e
manses84225513manses
march125622893m_arch
marsh105320853mars_h
mash96039393m_as_h
match125621103m_atch
matsah1138233matsah
means75831223means__
measle83513223measle
measly113610443measly
mecca1139933me_cca
medic104619653medic_
medick154010133medick
medico113711163medico
medics114115353medics
meds75735363meds__
megs75530633megs__
melic94722333melic_
mels65941533mels__
mems85931503mems__
men59252843men___
menaced122710093menaced
menacer112610883menacer
menaces112715523menaces
menad85918983men_ad
menads95514383menads
menage93216543menage
menarche1545813menarche
mend75334023men__d
mended104418683mended
mender93520793mender
mends84927693men_ds
menhir1136783menhir
menial84223033menial
meninx1538703meninx
meniscal1246183meniscal
meniscus1243773meniscus
meno66031353men__o
menorah1247933menorah
menshen1236803menshen
menshes12310443menshes
mensing103915103mensing
menta74424423men_ta
mental84521603mental
mentee84121293mentee
mentor8414363mentor
mentum104511713mentum
menu65130223men__u
menudo945793menudo
menus75822843men_us
merc87225623me_rc_
mercs96020453me_rcs
mercy125916183me_rcy
mesa67025483me_s_a
mesarch1445533mesarch
mesas76823203me_sas
mescal104113483me_scal
meshy135612783me_shy
mesic93617863me_sic
mesne75116293me_sne
mesnes85216213mesnes
meson74118313me_son
mess65932433me_s_s
messan83912063messan
messed95018183messed
messes84924343messes
messiah1246793messiah
messy104913833me_ssy
meth95827843me__th
mews96629333mews__
miens76118303miens__
milch124413373m_ilch
mince95325233min_ce
mincy125817413min_cy
minish115216303minish
moloch1356483moloch
monarch1445953monarch
monish114217593monish
mons68152253mons__
month104818423mon_th
mooch125313613m_ooch
mosh95227603m_os_h
mouch124715803m_ouch
much115224033m__uch
mulch124012973m_ulch
muns65535913muns__
musca9311763m_usca
mush94929123m_us_h
musth105314783m_usth
mutch125016173m_utch
mynah13569563myn_ah
nonsuch1244683nonsuch
omens75618963omens__
peach125422493pe_ach
pech116125453pe__ch
pence94924453pen_ce
penoche1447043penoche
pens65649643pens__
pensee8417313pensee
pensil83013333pensil
penuche1435943penuche
penuchi1444033penuchi
perch124518833pe_rch
pinch125619303pin_ch
plench134010813plen_ch
punch125118423pun_ch
putsch1334933putsch
quench2036633quen_ch
ranch105019793ran_ch
reach105123883re_ach
resh76523453re_s_h
retch104818303re_tch
search113312423search
seneca839793seneca
sensa54117473sens_a
sense55526823sens_e
sensed73918163sensed
sensei64712593sensei
senses63923943senses
sensor63813833sensor
sensum849353sensum
stench114111163sten_ch
synch135011793syn_ch
teach105221123te_ach
tech95925443te__ch
tenace82715693tenace
tens45647413tens__
tense55225843tens_e
tensed74817833tensed
tenser64919433tenser
tenses64722553tenses
tensor63812673tensor
tenth85421833ten_th
teuch105214853te_uch
trench114211613tren_ch
vetch134411843ve_tch
welch134411493we_lch
welsh113110363wels_h
wens76337933wens__
winch135016663win_ch
wrench14439353wren_ch
xenic144114643xenic_
yecch15558093ye_cch
yech127220533ye__ch
yens75832263yens__
zenith1839073zenith

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 Filter1786911127160.283631417.0
2DLD Change Limit1127162366.73316740.8
3Display Results2362360.0802950.0
 (SQL Overall)1786912367.09625181.9
 
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.