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

227 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
endash1029712(None) 
emdash12244111emdash
encash11276941encash
dash87031632__dash
encase83714362encase
endarch1345442endarch
endashes12217452endashes
ends56528522end_s_
enmesh1134892enmesh
gnash9449832gn_ash
snash84815672sn_ash
unlash938792unlash
abash106016513_abash
agendas936933agendas_
anas46649863an_as_
ands57833613and_s_
angas65827983angas_
ankush13114433ankush
anlas55626933anlas_
annas55824883annas_
anoas57226493anoas_
antas55432033antas_
ash67944603___ash
awash116613163_awash
badass949293badass
bandas95120543bandas_
bash915240163__bash
benday123810813benda_y
bendays13327513bendays
bends85628973bend_s_
bendys12518383bendys_
beneath1236973beneath
brash106221563_brash
calash11312433calash
cash96636283__cash
centas85020703centas_
clash106219033_clash
codas84724243codas_
crash109120013_crash
dadas75819863dadas_
dah78148983__da_h
dahs88231813__dahs
dashi95013113__dashi
dashy125612383__dashy
deash95617243_deash
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
emdashes14224303emdashes
enact73525363en_act
enate54428143en_ate
encage93713503encage
encamp1235943encamp
encased103512313encased
encases93116053encases
encashed14246473encashed
encashes13227673encashes
enchase1239453enchase
enclasp1145843enclasp
encyst1136203encyst
end46834353end___
endarchy1743343endarchy
endear74110013endear
endears83710053endears
ended74421263end_ed
ender64325863end_er
enders74324053enders
endgame1145233endgame
ending83220253ending
endite73817593endite
endive103310473endive
endless839833endless
endmost1056763endmost
endocast1146683endocast
endorse879203endorse
endow94510983end_ow
endows104610423endows
endrin7312403endrin
endue64215353end_ue
endued83910373endued
endues73813903endues
endure74014143endure
enduro7338623enduro
endways1444443endways
endwise1136463endwise
enemas8812003enemas_
enface112510353enface
engage82812103engage
english1137953english
engs56121393en_gs_
enhalo987563enhalo
enlace82213233enlace
enlist6417043enlist
enolase7310193enolase
enols54718403enols_
enough1045753enough
enows85115493enows_
enrage72715073enrage
enrapt8313013enrapt
enravish1444243enravish
enrich1138943enrich
ens37245923en__s_
entail61114343entail
entases72816273entases
entasia73110063entasia
entasis73012573entasis
ephah1337063epha_h
ephahs1435503ephahs
ephas10311543ephas_
eras45441503e_ras_
erase54925493e_rase
etas46432273e_tas_
etnas54713933etnas_
eyas76427433e_yas_
eyass84410783e_yass
eyelash1344563eyelash
eyewash1642583eyewash
eyras84715923eyras_
fash107232293__fash
fends96324973fend_s_
fiendish1544033fiendish
flash115716213_flash
gash86833023__gash
genoas74013623genoas_
hash106936503__hash
hennas94211803hennas_
hennish1336863hennish
hondas10313353hondas_
incase83615283incase
indaba935613indaba
inmesh1134853inmesh
inrush936513inrush
jadish17319903jadish
judas134911883judas_
keddah1534263kedda_h
keddahs1642923keddahs
kendos114510663kendos_
knish1238603kn_ish
lash76539653__lash
lavash12597373lavash
leash85519213_leash
lends65326253lend_s_
mash96039393__mash
menads95514383menads_
mends84927693mend_s_
mensas85115853mensas_
mensh105413553men__sh
midrash1335423midrash
modish123813543modish
nadas66320813nadas_
nah69847003_n_a_h
neath86020283_neath
nemas75321573nemas_
nerdish1137103nerdish
newish1237903newish
noncash1245163noncash
nosh76223543_n_osh
odah87018933_oda_h
odahs95610083_odahs
odas57230263_odas_
oddish11107653oddish
oldish10169313oldish
onrush935343onrush
pandas95521963pandas_
pash95638133__pash
pendant10314853pendant
pends85527193pend_s_
plash104616563_plash
potash1138273potash
quash174512163_quash
radish103516913radish
rash76039933__rash
reddish1238033reddish
rehash1237433rehash
rends65129953rend_s_
rennase738713rennase
rewash1237673rewash
sash77235303__sash
sendal73314993senda_l
sendals81912263sendals
sends65528243send_s_
sennas64214233sennas_
slash84719683_slash
smash104814433_smash
snath86419803sn_ath
sneesh945893sneesh
sodas64123543sodas_
splash1168823splash
squash1846833squash
stash84916973_stash
swash116316753_swash
tends65425583tend_s_
tendus75111183tendus_
tenias64720073tenias_
thrash12258353thrash
trash86119763_trash
tundish1137283tundish
uncase83817433uncase
uncast84215713uncast
unease63816643unease
uneasy9278853uneasy
unleash1034963unleash
unmask1265903unmask
unmesh1145793unmesh
unwish1239093unwish
vandas103915993vandas_
vendace1357363vendace
vends95520893vend_s_
wash106033813__wash
wends95822813wend_s_
wennish1336243wennish
widish13419363widish
xenias133712973xenias_
yentas94614213yentas_

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.1401276364.3
2DLD Change Limit1127162275.53320371.6
3Display Results2272270.0762986.8
 (SQL Overall)1786912275.74931082.1
 
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.