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

137 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
endashes1221745(None) 
emdashes14224301emdashes
encashes13227671encashes
dashes106124982__dashes
encases93116052encas_es
encashed14246472encashed
endash10297122endash__
enmeshes1345342enmeshes
entases72816272entas_es
gnashes11419572gn_ashes
snashes105214752sn_ashes
unlashes11238042unlashes
abashes12510373_abashes
andantes9310853andantes
ankushes1544583ankushes
anlases72514903anlas_es
ashes86230613___ashes
badasses1136173badasses
bashes115631393__bashes
berdaches1745053berdaches
brashes124518463_brashes
calashes13310533calashes
cashes114729883__cashes
clashes124017283_clashes
crashes124618403_crashes
dashed115920563__dashed
dasher104318983__dasher
dashers115016863__dashers
dashis104414393__dashis
deashes113313903_deashes
dishes104622653__dishes
earaches13411303earaches
eases56041613e__as_es
easies64126633e__asies
ecdyses1333413ecdys_es
ectases92911673ectas_es
emdash12244113emdash__
enables92813123en_ables
enates64026433en_a_tes
encages103313783enca_ges
encase83714363encas_e_
encased103512313encas_ed
encash11276943encash__
enchases13310273enchas_es
endamages1343773endamages
endanger1045853endanger
endangers1144943endangers
endarchies1644463endarchies
endgames1245423endgames
endites83717063end_ites
endives113710693end_ives
endnotes945943endnotes
endorsees1045503endorsees
endorses959973endorses
endosmos1144353endosmos
endosomes1246663endosomes
endostea944953endostea
endues73813903end__ues
endures83314603end_ures
enfaces122110913enfa_ces
engages92912493enga_ges
englishes1345103englishes
enhaloes1197343enhaloes
enhances1339293enhances
enisles72312603en_isles
enlaces92313393enla_ces
enlarges946073enlarges
enmeshed1444163enmeshed
enolases8411013enolas_es
enrages83114853enra_ges
enravishes1642153enravishes
enriches1337263enriches
ensues63313813en__sues
enswathes1543433enswathes
entasias8269143entasias
entasis73012573entas_is
erases64425403e_ras_es
eyases94513683e_yas_es
eyasses10388023e_yasses
eyelashes1542853eyelashes
eyewashes1842163eyewashes
fashes124524023__fashes
flashes133916103_flashes
gamashes1456943gamashes
gashes105725153__gashes
gendarmes1343923gendarmes
gnashed12317523gn_ashed
hashes125024803__hashes
headaches1845033headaches
incases93615973incas_es
inmeshes1345613inmeshes
inrushes1136273inrushes
judases1534443judas_es
knishes1438263kn_ishes
lashes94831003__lashes
lavashes1445573lavashes
leashes103514403_leashes
mashes115030003__mashes
menshes12310443men__shes
naches114622413_n_aches
noshes96618233_n_oshes
onrushes1135213onrushes
pashes115828393__pashes
plashes124417393_plashes
potashes1337833potashes
quashes192110973_quashes
radishes1269463radishes
rashes95330153__rashes
rehashes1436953rehashes
rennases848983rennas_es
rewashes1447033rewashes
sashes94728483__sashes
slashes103619103_slashes
smashes123914613_smashes
snathes104816493sn_athes
sneeshes1136513sneeshes
splashes1337503splashes
squashes20207803squashes
stashes103916173_stashes
swashes134714403_swashes
tendances1247573tendances
teniases838623tenias_es
thrashes1487653thrashes
trashes104119263_trashes
tundishes1344543tundishes
uncases93516553uncas_es
uncashed14299763uncashed
uneases73316263uneas_es
unlashed12289183unlashed
unleashes1245123unleashes
unmeshes1346153unmeshes
unwashed15288483unwashed
unwasheds16233103unwasheds
unwishes14147483unwishes
vendables15165153vendables
vendaces1457183venda_ces
washes124425493__washes

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.423422437.4
2DLD Change Limit1461621376.58022213.1
3Display Results1371370.0602283.3
 (SQL Overall)1786911377.06325299.6
 
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.