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

165 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
emdash1224411(None) 
endash10297121endash
dash87031632__dash
emdashes14224302emdashes
encash11276942encash
mash96039402_m_ash
smash104814432sm_ash
abash106016513_abash
admass957143admass
amah98927493am_a_h
amahs107819063am_ahs
amas67746293am_as_
amass77119683am_ass
ambush1336113ambush
amias75831473amias_
amidase1036733amidase
ash67944603___ash
awash116613163_awash
badass949293badass
bash915240163__bash
bemas96424283bem_as_
brash106221563_brash
calash11312433calash
cash96636283__cash
clash106219033_clash
codas84724243codas_
crash109120013_crash
dadas75819863dadas_
dah78148983__da_h
dahs88231813__dahs
dashi95013113__dashi
dashy125612383__dashy
deash95617243_deash
demast9517063dem_ast
dish86328333__dish
dudish1148313dudish
each95530583e__ach
ease45042333e__ase
east46659103e__ast
easy76224493e__asy
eath75735663e__ath
edh76921563e_d__h
edhs86212103e_dhs_
eds46638923e_d_s_
egads74610923egads_
eidos65817753eidos_
eldest72912683eldest
elds56324853eld_s_
elfish1267963elfish
elvish1277563elvish
email74715103em_ail
embalm1236653embalm
embank14346553embank
embar94011603emba_r
embark14458523embark
embars103812883embars
embassy1442703embassy
embay123410603emba_y
embays131408333embays
embosk1464863embosk
emboss1087383emboss
emes65434663em_es_
emeus76913333emeus_
emirs76116163emirs_
emits75421473emits_
emmys12446023emmys_
empale102611263empale
empathy1743483empathy
ems56435493em__s_
emus66821683em_us_
emydes1236173emydes_
emyds1144923emyds_
encase83714363encase
endarch1345443endarch
endashes12217453endashes
ends56528523end_s_
enmesh1134893enmesh
ephah1337063epha_h
ephahs1435503ephahs
ephas10311543ephas_
eras45441503e_ras_
erase54925493e_rase
etas46432273e_tas_
etnas54713933etnas_
eyas76427433e_yas_
eyass84410783e_yass
eyelash1344563eyelash
eyewash1642583eyewash
eyras84715923eyras_
fash107232293__fash
flash115716213_flash
gash86833023__gash
gnash9449833_gnash
hash106936503__hash
immesh1334113immesh
impish13499193impish
jadish17319903jadish
judas134911883judas_
keddah1534263kedda_h
keddahs1642923keddahs
lash76539653__lash
lavash12597373lavash
leash85519213_leash
lemmas10349163lemmas_
mach116134483_m_ach
mads76845373_mads_
marsh105320853_marsh
mas58175823_m_as_
masa65034723_m_asa
mashy136016503_m_ashy
mask105227363_m_ask
mass66044943_m_ass
mast65959963_m_ast
math95437453_m_ath
meads85425323meads_
medaka1336343medaka
medal86221333meda_l
medals94218053medals
medias93620783medias_
meds75735363med_s_
medusa936293medusa
megass9219443megass
mensh105413553_mensh
mesas76823203mesas_
mesh96823003_m_esh
miasm91211093_miasm
midrash1335423midrash
moas65545343_moas_
modish123813543modish
mosh95227603_m_osh
mush94929123_m_ush
nadas66320813nadas_
nemas75321573nem_as_
nerdish1137103nerdish
odah87018933_oda_h
odahs95610083_odahs
odas57230263_odas_
oddish11107653oddish
oldish10169313oldish
omasa749483om_asa
pash95638133__pash
plash104616563_plash
potash1138273potash
quash174512163_quash
radish103516913radish
rash76039933__rash
reddish1238033reddish
rehash1237433rehash
remudas1035833remudas_
rewash1237673rewash
sash77235303__sash
slash84719683_slash
smoosh11236733smoosh
smush104410583sm_ush
snash84815673_snash
sodas64123543sodas_
splash1168823splash
squash1846833squash
stash84916973_stash
swash116316753_swash
thrash12258363thrash
trash86119763_trash
unlash938793unlash
wash106033813__wash
widish13419363widish

Search took 6 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.1231452772.4
2DLD Change Limit1127161655.54620323.8
3Display Results1651650.0463587.0
 (SQL Overall)1786911655.71531267.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.